Module 1
Basic Concepts – Purpose of database systems-Components of DBMS – DBMS Architecture and Data Independence- Data modeling – Entity Relationship Model,
Relational – Network- Hierarchical and object oriented models-Data Modeling using the Entity Relationship Model.
Basic Concepts – Purpose of database systems-Components of DBMS – DBMS Architecture and Data Independence- Data modeling – Entity Relationship Model,
Relational – Network- Hierarchical and object oriented models-Data Modeling using the Entity Relationship Model.
Module 2
Structure of relational databases – relational databases – relational algebra- tuple relational calculus. Data definition with SQL, insert, delete and update statements in SQL – views – data manipulation with SQL
Structure of relational databases – relational databases – relational algebra- tuple relational calculus. Data definition with SQL, insert, delete and update statements in SQL – views – data manipulation with SQL
Module 3
Introduction to Transaction Processing- Transaction and System Concepts- Desirable properties of Transactions- Schedules and Recoverability- Serializability of Schedules-Query processing and Optimization- Concurrency Control- -assertions – triggers.
Oracle case study: The basic structure of the oracle system – database structure and its manipulation in oracle- storage organization in oracle – Programming in PL/SQL- Cursor in PL/SQL
Introduction to Transaction Processing- Transaction and System Concepts- Desirable properties of Transactions- Schedules and Recoverability- Serializability of Schedules-Query processing and Optimization- Concurrency Control- -assertions – triggers.
Oracle case study: The basic structure of the oracle system – database structure and its manipulation in oracle- storage organization in oracle – Programming in PL/SQL- Cursor in PL/SQL
Module 4
Database Design– Design guidelines– Relational database design – Integrity Constraints – Domain Constraints- Referential integrity – Functional Dependency- Normalization using Functional Dependencies, Normal forms based on primary keys- general definitions of Second and Third Normal Forms. Boyce Codd Normal Form– Multivalued Dependencies and Forth Normal Form – Join Dependencies and Fifth Normal Form – Pitfalls in Relational Database Design.
Database Design– Design guidelines– Relational database design – Integrity Constraints – Domain Constraints- Referential integrity – Functional Dependency- Normalization using Functional Dependencies, Normal forms based on primary keys- general definitions of Second and Third Normal Forms. Boyce Codd Normal Form– Multivalued Dependencies and Forth Normal Form – Join Dependencies and Fifth Normal Form – Pitfalls in Relational Database Design.
Module 5
Distributed databases: Distributed Database Concepts- Data Fragmentation, Replication and Allocation Techniques- Different Types- Query Processing – semijoin -Concurrency Control and Recovery.
Distributed databases: Distributed Database Concepts- Data Fragmentation, Replication and Allocation Techniques- Different Types- Query Processing – semijoin -Concurrency Control and Recovery.
Text Book
Fundamentals of Database System Elmasri and Navathe (3rd Edition), Pearson Education Asia
References
1. Database System Concepts – Henry F Korth, Abraham Silbershatz, Mc Graw Hill 2nd edition.
2. An Introduction to Database Systems – C.J.Date (7th Edition) Pearson Education Asia
3. Database Principles, Programming and Performance – Patrick O’Neil, Elizabeth O’Neil
4. An Introduction to Database Systems – Bibin C. Desai
2. An Introduction to Database Systems – C.J.Date (7th Edition) Pearson Education Asia
3. Database Principles, Programming and Performance – Patrick O’Neil, Elizabeth O’Neil
4. An Introduction to Database Systems – Bibin C. Desai