Fundamentals Databases module

Module Title - Fundamentals Databases
Number of credits – 10

Module description 

The module will explore some of the fundamentals of databases. Topics will include: relational theory, relational algebra, query languages, data design. The necessary mathematical background will be developed alongside its application in databases. Students will be introduced to an existing database system. The module is particularly suitable for MSc students who have little previous background in Computer Science.

The aims of this module are to:

  • Introduce the fundamentals of database theory
  • Introduce the core of the SQL query language
  • Enable students to design a database

On successful completion of this module, you should be able to:

  • Use SQL to create, modify and query databases
  • Analyse a real-world scenario and perform a conceptual database design for it
  • Take a conceptual data design model and translate it into the relational model
  • Use an existing database system
  • Apply relational algebra and the mathematical theory of relations to describe databases, queries, and consistency conditions

Teaching and assessment:

Sessional: 1.5 hour examination (80%), continuous assessment (20%). 
Supplementary (where allowed): 1.5 hour examination (100%)
Semester 1
Contact hours - 24