CS990 – Database Fundamentals

TIMETABLE TEACHING MATERIAL
Credits 10
Level 5
Semester 2
Prerequisites N/A
Availability Possible elective
Contact Lectures: 10 | Tutorials: 0 | Labs: 20
Homework / Private Study: 70
Assessment Individual assignments worth 50% and a 2-hour written examination worth 50%.
Resit The resit assessment will involved completing an assignment and/or taking a 2-hour exam.
Lecturer Dr John Wilson

General Aims

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

Learning Outcomes

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.

Syllabus

  • 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.

Recommended Text/Reading*

* This list is indicative only – the class lecturer may recommend alternative reading material. Please do not purchase any of the reading material listed below until you have confirmed with the class lecturer that it will be used for this class.

Database Systems: A Practical Approach to Design, Implementation and Management (6th Edition). Thomas M. Connolly and Carolyn E. Begg, Pearson, 2014. ISBN-10: 0132943263 | Stocked at Amazon (Other retailers are available)