CSC-20061 - Module Specification
School of Computing and Mathematics
Faculty of Natural Sciences

Programme/Approved Electives for 2020/21

Available as a Free Standing Elective

Co-requisites

None

Prerequisites

None

Barred Combinations

None

Description for 2020/21

This module introduces learners 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
show awareness and knowledge of other types of database interfaces: 1
distinguish 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)
6 hours tutorials/workshops (supported online and in block release)
16 hours online lectures
112 hours Independent study/coursework

School Rules

None

Description of Module Assessment