CS952 – Database & Web Systems Development

TIMETABLE TEACHING MATERIAL
Credits 20
Level 5
Semester 2
Prerequisites N/A
Availability Possible elective
Contact Lectures: 18 | Tutorials: 0 | Labs: 18
Assignments: 80 | Self study: 84
Assessment Assessment will be 50% written examination and 50% coursework.
Resit TBC
Lecturer Dr Alex Coddington | Dr John Wilson

General Aims

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.

Learning Outcomes

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.

Syllabus

  • 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.

Recommended Text/Reading*

* 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.

Internet & World Wide Web How to Program (4th Edition). Deitel, H. and Deitel, P. Prentice Hall, 2007. ISBN-13: 978-0136035428 | Stocked at Amazon (Other retailers are available)

Database Systems: A Practical Approach to Design, Implementation and Management (6th Edition). Connolly. T.M. and Begg, C.E. Pearson, 2014. | Stocked at Amazon (Other retailers are available)

Database Principles and Design (3rd Edition). Ritchie, C. Cengage, 2008. ISBN-13: 978-1844805402 | Stocked at Amazon (Other retailers are available)