COMP2202 Database and Database Applications
Aims and Objectives
This module aims to give students an understanding of the role of database systems in information management, the theoretical and practical issues that influence the design, implementation and applications of database management systems and languages.
Knowledge and Understanding
Having successfully completed this module, you will be able to demonstrate knowledge and understanding of:
- Understand the role of database systems in information management
- Understand the concept of data modelling
- Understand the theoretical properties of relational databases
Subject Specific Intellectual and Research Skills
Having successfully completed this module you will be able to:
- To be able to apply entity-relationship modelling
- To be able to normalise data
- To be able to use SQL to create, update and query a database
- Rationale behind Database Systems - Database Modelling using the Entity-Relationship Model - Database System Architecture - Data Models and Data Sublanguages - SQL - Database Management Issues: concurrency, security, integrity - Application of Database - No SQL databases
Learning and Teaching
|Wider reading or practice||50|
|Supervised time in studio/workshop||12|
|Completion of assessment task||12|
|Preparation for scheduled sessions||16.5|
|Total study time||150|
Resources & Reading list
Elmasri, R. and S. Navathe (2007). Fundamentals of database systems.
Rothwell DM (1993). Databases: An Introduction.
Date CJ (2004). An Introduction to Database Systems.
Connolly, T. M. and C. E. Begg. Database systems : a practical approach to design, implementation, and management.
Garcia-Molina, H., J. D. Ullman, et al (2009). Database systems: The Complete Book.
The initial coursework will be online from week 1. However, a hand-in of the database design is required in week 3. Formative feedback and in-class discussion of an appropriate design will be given in week 4. This will then be used to answer the remaining part of the assignment. No engagement in the exercise will limit your understanding of the problem to be addressed.
|Database design and implement||20%|
Repeat type: Internal & External