Introduction to DBMS:Database System Vs File system, Database systems applications, Purpose of database systems – Data models. Relational models: Structure of relational databases – database schema keys – schema diagrams. Relational Query Languages – fundamental relational algebra operations – additional relational algebra operations.
Introduction to SQL –
Background – SQL data definition –structure of SQL queries – set operations – null values – aggregate functions – modifications to the database.
Database design – overview of the design process – the entity-relationship model – constraints – entity-relationship diagrams – reduction to relation schemas – Entity-relationship design issues – weak entity sets – extended E-R features. Intermediate SQL: Nested subqueries – Join expression – Views – Transactions – integrity constraints – authorization. Advanced SQL –
Accessing SQL from a program – functions and procedures – triggers.
Relational database design – features of good relational designs – atomic domains and normal forms – 1NF, 2NF, 3NF, 4NF and BCNF – decomposition using functional dependencies – functional dependency theory – algorithm for decomposition -decomposition using multi values dependencies – PJNF and DKNF. Over view of Transaction Management and Concurrency control