Introduction to databases

Module title:

Introduction to databases

Module overview:

This module introduces students to concepts of relational databases and relational database management systems (RDBMS).

This module is core to both Applied Computer Engineering and Multimedia Computing study programmes and provides the foundation for database related modules that students of Applied Computing study programme will take in the following semesters. For Multimedia Computing study programme, this module is important because of backend programming modules in the next semesters. In both cases, skills learnt in this module will contribute significantly to students’ development as professionals in respecting fields.

Students will learn:
• Relational databases concepts, which are necessary to build skills that are more complex and required in the labour market.
• Normal forms (1NF, 2NF, 3NF) and the normalization process.
• How to construct and interpret SQL statements for selecting, inserting, deleting and updating data.
• How to write more complex SQL queries that include JOIN mechanics, grouping, aggregate functions and subqueries.

The module is taught in Transact-SQL dialect of SQL programming language. The module assessment is based on solving a series of smaller practical tasks. Database design tasks are solved by using a defined tool for ER Modelling, whereas database querying tasks are solved by using a defined database client tool to connect to an actual database.

Literature:

Essential reading:
1. Harrington, J. L. (2016) Relational Database Design and Implementation. 4th edn. Amsterdam: Elsevier Inc.

Recommended reading:
1. Churcher, C. (2012) Beginning Database Design: From Novice to Professional. New York City: Apress.