AD3391 Database Design and Management Syllabus:
AD3391 Database Design and Management Syllabus – Anna University Regulation 2021
COURSE OBJECTIVES:
• To introduce database development life cycle and conceptual modeling
• To learn SQL for data definition, manipulation and querying a database
• To learn relational database design using conceptual mapping and normalization
• To learn transaction concepts and serializability of schedules
• To learn data model and querying in object-relational and No-SQL databases
UNIT I CONCEPTUAL DATA MODELING
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
Relational model concepts — Integrity constraints — SQL Data manipulation – SQL Data definition – Views — SQL programming.
UNIT III RELATIONAL DATABASE DESIGN AND NORMALIZATION
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
Transaction concepts – properties – Schedules – Serializability – Concurrency Control – Two-phase locking techniques.
UNIT V OBJECT RELATIONAL AND NO-SQL DATABASES
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.
TOTAL : 45 PERIODS
COURSE OUTCOMES
After the completion of this course, students will be able to:
CO1:Understand the database development life cycle and apply conceptual modeling
CO2:Apply SQL and programming in SQL to create, manipulate and query the database
CO3:Apply the conceptual-to-relational mapping and normalization to design relational database
CO4:Determine the serializability of any non-serial schedule using concurrency techniques
CO5:Apply the data model and querying in Object-relational and No-SQL databases.
TEXT BOOKS:
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:
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.