Syllabuses - PG

CS990 - Database Fundamentals

TIMETABLETEACHING MATERIAL
Credits10
Level5
SemesterSemester 2
Availability
Possible elective
PrerequisitesN/A
Learning Activities BreakdownLectures: 10 | Tutorials: 0 | Labs: 10
Homework / Private Study: 80
AssessmentTBC
LecturerLisa McCann

Aims and Objectives

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 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)

Last updated: 2022-09-09 13:46:02