Module 02525 (2006)
Syllabus page 2006/2007
06-02525
Databases 2
Level 3/H
Links | Outline | Aims | Outcomes | Prerequisites | Teaching | Assessment | Books | Detailed Syllabus
The Module Description is a strict subset of this Syllabus Page. (The University module description has not yet been checked against the School's.)
Changes and updates
Major changes made to module description during Semester 1.
Relevant Links
Outline
The module begins with a swift recap of the standard database canon: SQL and ER modelling, albeit from a more advanced perspective. This is followed by a discussion of relational algebra and functional dependencies, and their role in verifying and improving the ER model (towards Boyce-Codd normal form). In the second part of the module, the inner workings of a database management system are presented and it is discussed how they impact on query evaluation efficiency. In the final part, XML is presented as an alternative to the relational data model.
Aims
The aims of this module are to:
- Present the key concepts of relational database theory
- Present the background to physical database design and performance tuning
- Present an alternative data model
Learning Outcomes
| On successful completion of this module, the student should be able to: | Assessed by: | |
| 1 | Use SQL for querying a relational database | Examination, Continuous assessment |
| 2 | Design a relational database using extended entity-relationship diagrams | Examination, Continuous assessment |
| 3 | Translate extended entity-relationship diagrams into SQL CREATE statements | Examination, Continuous assessment |
| 4 | Translate between SQL and relational algebra | Examination, Continuous assessment |
| 5 | Analyse a relational database design using functional dependencies and perform transformations towards Boyce-Codd Normal Form | Examination, Continuous assessment |
| 6 | Demonstrate an understanding of database implementation principles, and their impact on query evaluation efficiency | Examination |
| 7 | Demonstrate an understanding of XML as an alternative data model, and its advantages and disadvantages over the relational model | Examination |
Restrictions, Prerequisites and Corequisites
Restrictions:
None
Prerequisites:
06-19321 Software System Components 2 (or some other introductory course in databases)
Co-requisites:
None
Teaching
Teaching Methods:
2 lectures and one exercise class per week during term time plus revision lectures. Weekly exercise sheets.
Contact Hours:
Assessment
- Sessional: 1.5 hr examination (80%), continuous assessment (20%).
- Supplementary (where allowed): By examination only.
- The continuous assessment consists of three class tests weighted at 6, 7, and 7%.
Recommended Books
| Title | Author(s) | Publisher, Date |
| Database Management Systems (3rd ed.) | R Ramakrishnan & J Gehrke | McGraw Hill, 2003 |
Detailed Syllabus
- Querying a relational database with SQL
- Modelling a real-world situation with (extended) entity-relationship diagrams
- ER modelling
- Extended ER diagrams
- Translating EER diagrams to tables
- Logical analysis of database designs
- Relational algebra
- Functional dependencies
- Normalisation
- RDBMS implementation technology
- File organisation and retrieval
- Indexes
- Algorithms for relational operators
- Query Execution
- Query Optimisation
- Transactions
- XML
Last updated: 29 Nov 2006
Source file: /internal/modules/COMSCI/2006/xml/02525.xml
Links | Outline | Aims | Outcomes | Prerequisites | Teaching | Assessment | Books | Detailed Syllabus