School of Computer Science

Module 02525 (2011)

Module description - Databases 2

The Module Description is a strict subset of the Syllabus Page.

Module Title Databases 2
School School of Computer Science
Module Code 06-02525
Level 3/H
Member of Staff Ata Kaban
Semester Semester 2 - 10 credits
Delivery

2 lectures and one exercise class per week during term time plus revision lectures. Weekly exercise sheets.

Outcomes

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

  • Use SQL for querying a relational database
  • Design a relational database using extended entity-relationship diagrams
  • Translate extended entity-relationship diagrams into SQL CREATE statements
  • Translate between SQL and relational algebra
  • Analyse a relational database design using functional dependencies and perform transformations towards Boyce-Codd Normal Form
  • Demonstrate an understanding of database implementation principles, and their impact on query evaluation efficiency
  • Structure a series of queries as transactions, and demonstrate an understanding of the impact this has on database behaviour and performance.
Assessment
  • Sessional: 1.5 hr examination (80%), continuous assessment (20%).
  • Supplementary: By examination only.