Database Management Systems(310241)

Unit: I Introduction to DBMS:

Basic concepts, Advantages of a DBMS over fileprocessing Systems, Data abstraction, Database Languages, Data Models:Introduction to Hierarchical, Network, ER, and Object Relational Model, Data Independence, Components of a DBMS and overall structure of a DBMS, Multi-User DBMS Architecture, System Catalogs Data Modeling: Basic Concepts, entity, attributes, relationships, constraints, keys, E-R and EER diagrams: Components of E-R Model, conventions, converting E-R diagram into tables, EER Model components, converting EER diagram into tables. Relational Model: Basic concepts, Attributes and Domains, Codd's Rules,

Relational Integrity: Domain, Entity, Referential Integrities, Enterprise Constraints, Views, Schema diagram

Read more..

Text Books:

1. Silberschatz A., Korth H., Sudarshan S., "Database System Concepts", 4th Edition, McGraw Hill Publishers, 2002, ISBN 0-07-120413-X

2. Elmasri R., Navathe S., "Fundamentals of Database Systems", 4th Edition, Pearson Education, 2003, ISBN 8129702282

Reference Books:

1. Rab P. Coronel C. "Database Systems Design, Implementation and Management", 5th Edition, Thomson Course Technology, 2002, ISBN 981-243-135-7

2. Connally T., Begg C., "Database Systems", 3rd Edition, Pearson Education, 2002, ISBN 81-7808-861-4

3. Date C., "An Introduction to Database Systems", 7th Edition, Pearson Education, 2002, ISBN 81 -7808-231- 4

4. Ramkrishna R., Gehrke J., "Database Management Systems", 3rd Edition, McGraw-Hill, 2003, ISBN 0-07- 123151 –X

5. Atul Kahate, “Introduction to Database Management System”, 3rd Edition, Pearson Education 2009, ISBN 978-81-317-0078-5.