AD3391 Database Design and Management Study Materials
Anna University – AD3391 Database Design and Management Regulation 2021 Syllabus, Notes, Important Questions, Question Paper with Answers, Previous Year Question Paper.
UNIT I CONCEPTUAL DATA MODELING 8 AD3391 Database Design and Management Syllabus
Database environment – Database system development lifecycle – Requirements collection –
Database design — Entity-Relationship model – Enhanced-ER model – UML class diagrams.
UNIT II RELATIONAL MODEL AND SQL 10 AD3391 Database Design and Management Notes
Relational model concepts — Integrity constraints — SQL Data manipulation – SQL Data definition –
Views — SQL programming.
UNIT III RELATIONAL DATABASE DESIGN AND NORMALIZATION AD3391 Database Design and Management Important Questions
ER and EER-to-Relational mapping – Update anomalies – Functional dependencies – Inference
rules – Minimal cover – Properties of relational decomposition – Normalization (upto BCNF).
UNIT IV TRANSACTION MANAGEMENT AD3391 Database Design and Management Question Bank
Transaction concepts – properties – Schedules – Serializability – Concurrency Control – Two-phase
locking techniques.
UNIT V OBJECT RELATIONAL AND NO-SQL DATABASES AD3391 Database Design and Management Question paper
Mapping EER to ODB schema – Object identifier – reference types – rowtypes – UDTs – Subtypes
and supertypes – user-defined routines – Collection types – Object Query Language; No-SQL: CAP
theorem – Document-based: MongoDB data model and CRUD operations; Column-based: Hbase data model and CRUD operations.
| Syllabus | Click Here |
| Notes | Click Here |
| Important Questions | Click Here |
| Previous Year Question Paper | Click Here |
| Question Bank | Click Here |
TEXT BOOKS: AD3391 Database Design and Management PDF
1. Thomas M. Connolly, Carolyn E. Begg, Database Systems – A Practical Approach to Design,
Implementation, and Management, Sixth Edition, Global Edition, Pearson Education, 2015.
2. Ramez Elmasri, Shamkant B. Navathe, Fundamentals of Database Systems, 7th Edition,
Pearson, 2017.
REFERENCES: AD3391 Database Design and Management IQ
1. Toby Teorey, Sam Lightstone, Tom Nadeau, H. V. Jagadish, “DATABASE MODELING AND
DESIGN – Logical Design”, Fifth Edition, Morgan Kaufmann Publishers, 2011.
2. Carlos Coronel, Steven Morris, and Peter Rob, Database Systems: Design, Implementation,
and Management, Ninth Edition, Cengage learning, 2012
3. Abraham Silberschatz, Henry F Korth, S Sudharshan, “Database System Concepts”, 6th
Edition, Tata Mc Graw Hill, 2011.
4. Hector Garcia-Molina, Jeffrey D Ullman, Jennifer Widom, “Database Systems:The Complete
Book”, 2nd edition, Pearson.
5. Raghu Ramakrishnan, “Database Management Systems”, 4th Edition, Tata Mc Graw Hill,
2010.
Related Links
Anna University Syllabus Regulation 2021
Anna University Regulation 2021 Study Materials
CGPA Calculator For Anna University
Download Padeepz App for Android