CS990 - Database Fundamentals

Credits

Level

Semester

Semester 2

Availability

Possible elective

Prerequisites

N/A

Learning Activities Breakdown

Lectures: 10 | Tutorials: 0 | Labs: 10
Homework / Private Study: 80

Items of Assessment

Assessment

The class will be assessed by Class Tests (30%) and by a 1-hour Examination (70%).

Lecturer

Muhammad Irfan

The aim of the class is to provide students with a conceptual and practical understanding of data modelling, database design and database technology.

On completion of this class students will be able to:

display knowledge of the process of designing a database system, starting from an informal specification;
display skill in formulating database queries using SQL;
show an appreciation of the facilities and services which should be provided by a fully featured database management system;
demonstrate knowledge of commonly occurring data models;
demonstrate experience of using a relational database management system in a client-server environment;
display knowledge of potential future developments in database technology.

Introduction to the Database Environment: data models and functions of a database management system.
Entity Relationship modelling, database design.
The Relational data model and its implementations: relational query languages; normalisation.
Databases and the Cloud.

Syllabuses - PG