CS952 - Database and Web Systems Development

TIMETABLE	TEACHING MATERIAL
Credits	20
Level	5
Semester	Semester 2
Availability	Possible elective
Prerequisites	N/A
Learning Activities Breakdown	Lectures: 18 \| Tutorials: 0 \| Labs: 18 Assignments: 80 \| Self study: 84
Assessment	The class will be assessed by coursework (50%) and by examination (50%),
Lecturer	Alex Coddington, Muhammad Irfan

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.

Syllabuses - PG