2007/2008, Semester 1
School of Computing (Computer Science)
Modular Credits: --
This module addresses the design of relational databases and object oriented databases. Topics covered include: normalisation theory: functional, multi-valued and join dependency, normal forms, relational database schema design using decomposition method and synthesizing method; entity-relationship approach: normal form entity-relationship diagram, its derivation, and its translation to relational, network, and hierarchical database schemas; schema integration: view integration and database integration, schema conflict resolution; nested relations: normal form nested relations, nested relations design using decomposition method and entity-relationship approach; object-oriented databases: basic concepts, inadequacies in object-oriented data models, inheritance conflict resolution, translate relational database schemas and entity-relationship diagrams to object-oriented database schemas.