CSC621: Advanced Databases 6 credits (40-10-10)

Objectives

To focus on the development and management of database to support business operations and semantic data modelling, normalization, SQL, fourth generation languages, and client-server database applications.

Contents

Relational model; dependencies and normal form; database specification; the relational design; syntactic and semantic design issues in data analysis; the three-schema approach; semantic modelling; mapping to relational; network; hierarchical data model; database management system; failure and recovery; concurrency management; database security; integrity and control; distributed databases; knowledge base and database systems; object-oriented databases; fourth generation languages and client-server database applications; current topics in database research.