Subject code AD3381 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 Laboratory. 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 AD3381 – Database Design And Management Laboratory 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 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:
- Database Development Life Cycle:
- Problem definition and Requirement analysis
- Scope and Constraints
- Database design using Conceptual modeling (ER-EER) – top-down approach
- Mapping conceptual to relational database and validate using Normalization.
- Implement the database using SQL Data definition with constraints, Views.
- Query the database using SQL Manipulation.
- Querying/Managing the database using SQL Programming
- Stored Procedures/Functions.
- Constraints and security using Triggers.
- Database design using Normalization – bottom-up approach.
- Develop database applications using IDE/RAD tools (Eg., NetBeans, VisualStudio)
- Database design using EER-to-ODB mapping / UML class diagrams.
- Object features of SQL-UDTs and sub-types, Tables using UDTs, Inheritance, Method definition.
- Querying the Object-relational database using Object Query language.
Related Posts On Semester – III:
You May Also Visit: