Module 21980 (2012)
Syllabus page 2012/2013
06-21980
ICY: Databases
Level 1/C I
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.)
Relevant Links
Essential Additional Information
Outline
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.
Aims
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
Learning Outcomes
| On successful completion of this module, the student should be able to: | Assessed by: | |
| 1 | Use SQL to create, modify and query databases | Examination, Continuous assessment |
| 2 | Analyse a real-world scenario and perform a conceptual database design for it | Examination, Continuous assessment |
| 3 | Take a conceptual data design model and translate it into the relational model | Examination, Continuous assessment |
| 4 | Use an existing database system | Continuous assessment |
Restrictions, Prerequisites and Corequisites
Restrictions:
May not be taken by anyone who has taken or is taking 06-02525 (Databases 2)
Prerequisites:
None
Co-requisites:
None
Teaching
Teaching Methods:
2 hrs lectures/tutorials per week (plus 22 hours of assisted labs)
Contact Hours:
Assessment
- Sessional: 1.5hr examination (80%), continuous assessment (20%)
- Supplementary (where allowed): 1.5 hour examination (100%)
Recommended Books
| Title | Author(s) | Publisher, Date |
| Database Principles: Fundamentals of Design, Implementation and Management, 10th Edition (International version) | C. Coronel, S. Morris and P. Rob | Cengage Learning, 2013 |
Detailed Syllabus
- Tables and SQL: using the existing relational database implementation, simple select queries, nested queries, aggregate functions, grouping, table creation and modification, etc.
- Conceptual database design: entities and relationships, generalisation hierarchies, keys and weak entities, ER diagrams.
- Logical database design and relational theory: translating ER diagrams into tables, relational algebra, functional dependencies, normalisation, de-normalisation.
- Discrete-mathematical underpinning of database relations, relationships and relational algebra.
Last updated: 7 February 2012
Source file: /internal/modules/COMSCI/2012/xml/21980.xml
Links | Outline | Aims | Outcomes | Prerequisites | Teaching | Assessment | Books | Detailed Syllabus