Skip to content Search
Search our website:

Introduction to Database Technology

Short name: DT
SITS code: COIY068H4
Credits: 15
Level: 4
Module leader: Peter Wood, Tingting Han
Online material: https://moodle.bbk.ac.uk/

Aims

  • To introduce the basics of relational database design using the Open Source Relational Database Management System MySQL.
  • To introduce a range of data retrieval methods using MySQL.
  • To apply these techniques to a small business case study.
  • To develop a range of professional IT skills enabling students to apply relational database open source technology in the workplace.

Syllabus

  • Relational databases: uses; advantages/disadvantages; comparison with flat-file databases.
  • Relational Database Management Systems: MySQL and benefits of open source software.
  • Basic database concepts: Entities and attributes; tables and relationships; primary and foreign keys; data types.
  • Gain experience in the use of the SQL query language for data definition and data manipulation. This module provides a practical grounding for further study of information systems.
  • Database design: Use of entity-relationship diagrams to model user requirements; database documentation.
  • Data manipulation: Enter, update and delete data; define criteria to retrieve specified data; use JOIN to retrieve data from multiple tables.

Prerequisites

  • Good IT skills.
  • Use of file compression tools (compress files, extract compressed files using WinZip).
  • Folder and file management (create, rename and organise folders, recognise filetypes from their file extension, change folder options).
  • Web searching using a browser (save a web page, view a page source, open local files, adding to favourites, change browser settings, use History menu, download resources).

Timetable

All dates and timetables are listed in programme handbooks, found in the downloads section of individual programme pages.

Enrolled students can find their personal teaching timetable and location of classes on their My Birkbeck profile.