CSC-20091 - Module Specification
School of Computer Science and Mathematics
Faculty of Natural Sciences

Programme/Approved Electives for 2025/26

Available as a Free Standing Elective

Co-requisites

None

Prerequisites

Programming for Data Scientists

Barred Combinations

None

Description for 2025/26

This module introduces basic to advanced concepts relating to databases and database management systems by providing theoretical knowledge and practical experience in data modelling, database design, implementation and administration.

To introduce learners to databases and database management systems by providing theoretical knowledge and practical experience in data modelling, database design, implementation and administration.

Intended Learning Outcomes

describe and advise upon the benefits and characteristics of database models and database management systems (DBMS) and the importance of data independence: 1
determine whether a given relational database is well designed (ie. meets BCNF criteria) and transform a schema into BCNF: 1
create and query a relational database using command level SQL: 1
describe and advise upon the important aspects of a database implementation, operation and maintenance: 1
use data modelling techniques for the design of databases: 1
use different types of database interfaces: 1
describe the important characteristics of the relational model for the purposes of developing relational databases: 1

Study hours

16 hours practical work (supported online and in block release)
4 hours tutorials/workshops (supported online and in block release)
16 hours online lectures
114 hours Independent study/coursework

School Rules

None

Description of Module Assessment