AD3381 Database Design and Management Laboratory

AD3381 Database Design and Management Laboratory Study Materials

Anna University – AD3381 Database Design and Management Laboratory Regulation 2021 Syllabus, Notes, Lab Manual, viva Important Questions, Question Paper with Answers, Previous Year Question Paper

SUGGESTIVE EXPERIMENTS AD3381 Database Design and Management Laboratory

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 AD3381 Database Design and Management Laboratory

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

Syllabus	Click Here
Notes	Click Here
Lab Manual	Click Here
Important Questions	Click Here
Previous Year Question Paper	Click Here
Question Bank	Click Here

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 To understand the database development life cycle
 To learn database design using conceptual modeling, Normalization

Anna University Regulation 2021 Study Materials

Anna University Results

AU COE Portal

CGPA Calculator For Anna University

Download Padeepz App for Android