Module 02381 (2004)
Syllabus page 2004/2005
06-02381
Databases 1
Level 2/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
Getting started with PostgreSQL
PostgreSQL Manual
Outline
An introduction to the theory and practice of Relational Database design, construction and use.
Aims
The aims of this module are to:
- Present the underlying theory of database systems
- Enable the students to develop the skills and knowledge necessary for competent use of SQL and relational algebra
- Show the students how to use database theory to design and implement database systems.
- give an appreciation of the use and value of databases and database technology
Learning Outcomes
| On successful completion of this module, the student should be able to: | Assessed by: | |
| 1 | Query a database using SQL and Relational Algebra | Examination and problem assignments |
| 2 | Read and understand SQL and Relational Algebra queries | Examination and problem assignments |
| 3 | Use dependency theory to reason about database redundancy and modification anomaly problems and normalise a database schema to BCNF | Examination and problem assignments |
| 4 | Design a relational database using Extended Entity Relationship Attribute modelling techniques | Examination and problem assignments |
| 5 | explain the design decisions involved in data design | Examination |
Restrictions, Prerequisites and Corequisites
Restrictions:
None
Prerequisites:
06-18189 (Mathematics for Computer Science)
Co-requisites:
None
Teaching
Teaching Methods:
2 hrs/week, conventional lectures, with much use made of tutorial sheets. Self study exercises are set using available database management systems. Revision lectures
Contact Hours:
Assessment
- Supplementary (where allowed): As the sessional assessment
- The continuous assessment consists of problem assignments.
Recommended Books
| Title | Author(s) | Publisher, Date |
| Database Management Systems (2nd ed.) | Raghu Ramakrishnan & Johannes Gehrke | McGraw Hill, 2000 |
Detailed Syllabus
-
Relational Theory
- Relations and relational algebra
- Functional dependencies
- Normalization (1NF, 2NF, 3NF, BCNF)
- The SQL language
- Data design
- Data centric analysis of applications
- Enterprise, Conceptual and Logical models
- Extended Entity Relationship Attribute Diagrams
- Top down and bottom up design and validation
Last updated: 15 Jan 2005
Source file: /internal/modules/COMSCI/2004/xml/02381.xml
Links | Outline | Aims | Outcomes | Prerequisites | Teaching | Assessment | Books | Detailed Syllabus