Subject code AD3391 deals with semester III of B.Tech Artificial Intelligence and Data Science regarding affiliated institutions of Anna University Regulation 2021 Syllabus. In this article, you can gather certain information relevant to the Database Design And Management. We added the information by expertise.
We included the proper textbooks and references to assist in some way in your preparation. It will enhance your preparation and strategies to compete with the appropriate spirit with others in the examination. If you see, you can find the detailed syllabus of this subject unit-wise without leaving any topics from the unit. In this article AD3251 – Data Structures Design Syllabus, You can simply read the following syllabus. Hope you prepare well for the examinations. I hope this information is useful. Don’t forget to share with your friends.
If you want to know more about the syllabus of B.Tech Artificial Intelligence And Data Science connected to an affiliated institution’s four-year undergraduate degree program. We provide you with a detailed Year-wise, semester-wise, and Subject-wise syllabus in the following link B.Tech. Artificial Intelligence And Data Science Syllabus Anna University, Regulation 2021.
Aim of 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.
AD3391 – Database Design And Management Syllabus
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 – row types – 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.
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.
References:
- 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.
Related Posts On Semester – III:
You May Also Visit: