2009/2010, Semester 1
School of Computing (Computer Science)
Modular Credits: CS2102 ( 4 ) / CS2102S ( 5 )
The aim of this module is to introduce the fundamental concepts and techniques necessary for the understanding and practice of design and implementation of database applications and of the management of data with relational database management systems. The module covers practical and theoretical aspects of design with entity-relationship model, theory of functional dependencies and normalisation by decomposition in second, third and Boyce-Codd normal forms. The module covers practical and theoretical aspects of programming with SQL data definition and manipulation sublanguages, relational tuple calculus, relational domain calculus and relational algebra.
(CS1102 or CS1102C or CS1102S) and (CS1231 or MA1100)