|Contact||Lectures: 10 | Tutorials: 0 | Labs: 20
Homework / Private Study: 70
|Assessment||Individual assignments worth 50% and a 2-hour written examination worth 50%.|
|Resit||The resit assessment will involved completing an assignment and/or taking a 2-hour exam.|
|Lecturer||Dr John Wilson|
The aim of the class is to provide students with a conceptual and practical understanding of data modelling, database design and database technology.
On completion of this class students will be able to:
- display knowledge of the process of designing a database system, starting from an informal specification;
- display skill in formulating database queries using SQL;
- show an appreciation of the facilities and services which should be provided by a fully featured database management system;
- demonstrate knowledge of commonly occurring data models;
- demonstrate experience of using a relational database management system in a client-server environment;
- display knowledge of potential future developments in database technology.
- Introduction to the Database Environment: data models and functions of a database management system.
- Entity Relationship modelling, database design.
- The Relational data model and its implementations: relational query languages; normalisation.
- Databases and the Cloud.
* This list is indicative only – the class lecturer may recommend alternative reading material. Please do not purchase any of the reading material listed below until you have confirmed with the class lecturer that it will be used for this class.