UNIT I
Introduction to Database Systems – Relational Model – Structure – Relational Algebra – Null Values – SQL – Set Operation – Views – Advanced SQL – Embedded SQL – Recursive Queries – The Tuple Relational Calculus – Domain Relational Calculus.
UNIT II
E-R Model – Constraints – E-R- Diagrams Weak Entity Sets – Reduction to Relational Schemes – Relational Database Design – Features of Relational Design – Automatic Domains and First Normal Form – Decomposition using Functional Dependencies – Multivalued Dependencies – More Normal Forms – Web Interface – Object – Based Databases – Structured Types and inheritance in SQL – Table inheritance – Persistent.
UNIT III
Storage and File Structure – RAID – File Organisation – Indexing and Hashing – B Tree – B Tree Index files - Static and Dynamic Hashing – Query Processing – Sorting & Join Operators – Query Optimization – Choice of Evaluation Plans.
UNIT IV
Transaction Management – Implementation of Atomicity and Durability – Serializability – Recoverability – Concurrency Control – Dead Lock Handling – Recovery System – Buffer Management.
UNIT V
Database – System Architecture – Client Server – Architectures – Parallel System – Network Types – Distributed Database – Homogeneous and Hetrogeneous Database – Directory System – Case Study – Oracle – MSSQL Server.
Text Books
(i) A. Silberschatz, H.F. Korth and S. Sudharshan, 2006, Database System Concepts, 5th Edition, Tata McGraw Hill, New Delhi.
Reference Books
(i) J. D. Ullman, 1988, Principles of Database Systems, Galgotia Publishers, New Delhi
(ii) C.J. Date, 1985, An Introduction to Database Systems, Third Edition, Narosa, New Delhi.
(iii) Elmasri and Navathe, 1999, Fundamentals of Database Systems, Third Edition, Pearson Education, Delhi.
(iv) C. Ritchie, 2004, Relational Database Principals, 2 nd Edition,Thomson, Singapore.
Website, E-learning resources
(i) http://www.cse.iitb.ac.in/dbms/Data/Papers-Local/DBConceptsBook/ slide-dir/
Introduction to Database Systems – Relational Model – Structure – Relational Algebra – Null Values – SQL – Set Operation – Views – Advanced SQL – Embedded SQL – Recursive Queries – The Tuple Relational Calculus – Domain Relational Calculus.
UNIT II
E-R Model – Constraints – E-R- Diagrams Weak Entity Sets – Reduction to Relational Schemes – Relational Database Design – Features of Relational Design – Automatic Domains and First Normal Form – Decomposition using Functional Dependencies – Multivalued Dependencies – More Normal Forms – Web Interface – Object – Based Databases – Structured Types and inheritance in SQL – Table inheritance – Persistent.
UNIT III
Storage and File Structure – RAID – File Organisation – Indexing and Hashing – B Tree – B Tree Index files - Static and Dynamic Hashing – Query Processing – Sorting & Join Operators – Query Optimization – Choice of Evaluation Plans.
UNIT IV
Transaction Management – Implementation of Atomicity and Durability – Serializability – Recoverability – Concurrency Control – Dead Lock Handling – Recovery System – Buffer Management.
UNIT V
Database – System Architecture – Client Server – Architectures – Parallel System – Network Types – Distributed Database – Homogeneous and Hetrogeneous Database – Directory System – Case Study – Oracle – MSSQL Server.
Text Books
(i) A. Silberschatz, H.F. Korth and S. Sudharshan, 2006, Database System Concepts, 5th Edition, Tata McGraw Hill, New Delhi.
Reference Books
(i) J. D. Ullman, 1988, Principles of Database Systems, Galgotia Publishers, New Delhi
(ii) C.J. Date, 1985, An Introduction to Database Systems, Third Edition, Narosa, New Delhi.
(iii) Elmasri and Navathe, 1999, Fundamentals of Database Systems, Third Edition, Pearson Education, Delhi.
(iv) C. Ritchie, 2004, Relational Database Principals, 2 nd Edition,Thomson, Singapore.
Website, E-learning resources
(i) http://www.cse.iitb.ac.in/dbms/Data/Papers-Local/DBConceptsBook/ slide-dir/
No comments:
Post a Comment