Database Design and Management detailed syllabus for Artificial Intelligence & Machine Learning (AI&ML) for 2021 regulation curriculum has been taken from the Anna University official website and presented for the AI&ML students. For course code, course name, number of credits for a course and other scheme related information, do visit full semester subjects post given below.
For Artificial Intelligence & Machine Learning 4th Sem scheme and its subjects, do visit AI&ML 4th Sem 2021 regulation scheme. The detailed syllabus of database design and management is as follows.
Course Objectives:
Download the iStudy App for all syllabus and other updates.
Unit I
CONCEPTUAL DATA MODELING 8 Database environment – Database system development lifecycle – Requirements collection – Database design — Entity-Relationship model – Enhanced-ER model – UML class diagrams.
Unit II
Download the iStudy App for all syllabus and other updates.
Unit III
RELATIONAL DATABASE DESIGN AND NORMALIZATION 10 ER and EER-to-Relational mapping – Update anomalies – Functional dependencies – Inference rules – Minimal cover – Properties of relational decomposition – Normalization (upto BCNF).
Unit IV
Download the iStudy App for all syllabus and other updates.
Unit V
OBJECT RELATIONAL AND NO-SQL DATABASES 9 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.
Course Outcomes:
Download the iStudy App for all syllabus and other updates.
Text Books:
- Thomas M. Connolly, Carolyn E. Begg, Database Systems – A Practical Approach to Design, Implementation, and Management, Sixth Edition, Global Edition, Pearson Education, 2015.
- Ramez Elmasri, Shamkant B. Navathe, Fundamentals of Database Systems, 7th Edition, Pearson, 2017.
Reference Books:
- Toby Teorey, Sam Lightstone, Tom Nadeau, H. V. Jagadish, DATABASE MODELING AND DESIGN – Logical Design, Fifth Edition, Morgan Kaufmann Publishers, 2011.
- Carlos Coronel, Steven Morris, and Peter Rob, Database Systems: Design, Implementation, and Management, Ninth Edition, Cengage learning, 2012
- Abraham Silberschatz, Henry F Korth, S Sudharshan, Database System Concepts”, 6th Edition, Tata Mc Graw Hill, 2011.
- Hector Garcia-Molina, Jeffrey D Ullman, Jennifer Widom, “Database Systems:The Complete Book”, 2nd edition, Pearson.
- Raghu Ramakrishnan, Database Management Systems”, 4th Edition, Tata Mc Graw Hill, 2010.
For detailed syllabus of all other subjects of Artificial Intelligence & Machine Learning, 2021 regulation curriculum do visit AI&ML 4th Sem subject syllabuses for 2021 regulation.
For all Artificial Intelligence & Machine Learning results, visit Anna University AI&ML all semester results direct link.