Advanced Database Design and Management

Relational databases: Mapping conceptual schema to relational schema; Data models; Normalization; Database connection in Linux/mysql and Windows/Access; Database access from a programming language.  Practical exercises using a standard DBMS, Analysis of Open Database Connectivity standard; Stored-procedure; Object-oriented Relational Database Management Systems (e.g. Oracle) should be studied and used. Data Modelling, Relational Database Design including the use of Entity Relationship (ER) modelling using practical examples, Report generation. DBMS terminology and concepts, Transaction Management, Concurrency and Recovery; Physical design issues, Database Administrator Functions, and Distributed databases.