AD3381 Database Design and Management Laboratory Syllabus:
AD3381 Database Design and Management Laboratory Syllabus – Anna University Regulation 2021
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:
CO1:Understand the database development life cycle
CO2:Design relational database using conceptual-to-relational mapping, Normalization
CO3:Apply SQL for creation, manipulation and retrieval of data
CO4:Develop a database applications for real-time problems
CO5:Design and query object-relational databases
TOTAL : 45 PERIODS
HARDWARE:
• Standalone Desktops
SOFTWARE:
• PostgreSQL