AD3381: Database Design and Management Laboratory syllabus for AI&ML 2021 regulation

Database Design and Management Laboratory 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 laboratory is as follows.

Course Objectives:

• To understand the database development life cycle
• To learn database design using conceptual modeling, Normalization
• To implement database using Data definition, Querying using SQL manipulation and SQL programming
• To implement database applications using IDE/RAD tools
• To learn querying Object-relational databases

Suggestive Experiments

1. Database Development Life cycle:Problem definition and Requirement analysis Scope and Constraints
2. Database design using Conceptual modeling (ER-EER) – top-down approach Mapping conceptual to relational database and validate using Normalization
3. Implement the database using SQL Data definition with constraints, Views
4. Query the database using SQL Manipulation
5. Querying/Managing the database using SQL Programming- Stored Procedures/Functions – Constraints and security using Triggers
6. Database design using Normalization – bottom-up approach
7. Develop database applications using IDE/RAD tools (Eg., NetBeans,VisualStudio)
8. Database design using EER-to-ODB mapping / UML class diagrams
9. Object features of SQL-UDTs and sub-types, Tables using UDTs, Inheritance, Method definition
10. Querying the Object-relational database using Objet Query language

Course Outcomes:

After the completion of this course, students will be able to:

• Understand the database development life cycle
• Design relational database using conceptual-to-relational mapping, Normalization
• Apply SQL for creation, manipulation and retrieval of data
• Develop a database applications for real-time problems
• Design and query object-relational databases

HARDWARE:

• Standalone Desktops

SOFTWARE:

• PostgreSQL

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.