Module 21923 (2013)

Module Description - Fundamentals: Databases

The Module Description is a strict subset of the Syllabus Page, which gives more information

Module TitleFundamentals: Databases
SchoolComputer Science
Module Code06-21923
DescriptorCOMP/06-21923/LM C
Member of StaffJohn Barnden
LevelM C
Credits10
Semester1
Pre-requisitesNone
Co-requisitesNone
RestrictionsMay not be taken by anyone who has taken or is taking 06-02525 (Databases 2)
Contact hours24
Delivery2 hrs lectures/tutorials per week (plus 22 hours of assisted labs)
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.
Outcomes
On successful completion of this module, the student should be able to:Assessed by:
Use SQL to create, modify and query databases Examination, Continuous Assessment
Analyse a real-world scenario and perform a conceptual database design for it Examination, Continuous Assessment
Take a conceptual data design model and translate it into the relational model Examination, Continuous Assessment
Use an existing database system Continuous Assessment
Apply relational algebra and the mathematical theory of relations to describe databases, queries, and consistency conditions Examination, Continuous Assessment
AssessmentSessional: 1.5hr examination (80%), continuous assessment (20%)
Supplementary (where allowed): 1.5 hour examination (100%)
TextsC. Coronel, S. Morris and P. Rob, Database Principles: Fundamentals of Design, Implementation and Management, 10th Edition (International version), 2013