Spring semester

Unit(s) of Assessment	Weighting Towards Module Mark ( %)
Coursework    Software development and report	40
Examination    1.5 hours, unseen	60
Qualifying Condition(s)      A weighted aggregate mark of 40% is required to pass the module.

This module provides an introduction to database design and the programming language SQL

None

• To examine the development of databases and database management systems.
• To critically investigate database analysis and development methods.
• To provide an opportunity to use and to critically appraise database development software.

On completion of this unit, students will be able to: 

• Demonstrate an understanding of the key principles involved in database application development.
• Demonstrate competence in using software tools for developing 
  database applications.
• Analyse practical problems and design databases suitable for these problem domains.

            The context of database management:

•           The database environment

•           Database development process

•           Database analysis

•           The Entity-Relationship model

•           Database design

•           Logical database design and the relational model

•           Implementation

•           SQL

•           Client-server architectures

•           Object oriented databases

•           Web databases

•           Data administration

•           Role of data administrators, security, recovery, concurrency

•           The Data Protection Act

Two one-hour lectures and a one-hour laboratory session per week.

Recommended:

Database System by P. Rob, Thompson Publishers, ISBN 1-418-83593-5 (2007)

A guide to MySQL by P. J. Pratt, Thompson Publishing, 1-4188-3635-4 (2006)

Other Texts:

HMSO – The Data Protection Act 1998 http://www.legislation.hmso.gov.uk/acts/acts1998/19980029.htm

Module website: http://www.computing.surrey.ac.uk/courses/cs263/

28 August 2008