|Contact||Lectures: 18 | Tutorials: 0 | Labs: 18
Assignments: 80 | Self study: 84
|Assessment||Assessment will be 50% written examination and 50% coursework.|
|Lecturer||Dr Alex Coddington | Dr John Wilson|
This module aims to:
- provide conceptual and practical understanding of data modelling, database design and database technology;
- give practical experience of developing web-based applications that integrate database server interaction.
On completion of this module 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;
- to understand the typical topology of internet applications;
- to develop simple internet-based applications that make use of:
- server-side technologies
- back-end technologies for storing server-side data.
- Introduction to the Database Environment: functions of a database management system.
- Entity Relationship modelling, database design.
- The Relational data model and its implementations: relational query languages; normalisation.
- Object oriented and other data models.
- Distributed databases.
- Indexing and transactions.
- Web application architectures; client-side technologies; server-side technologies.
* 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.