AD3381 DATABASE DESIGN AND MANAGEMENT LABORATORY Anna University Syllabus R2021

 

 

 AD3381 DATABASE DESIGN AND MANAGEMENT LABORATORY Anna University Syllabus R2021

AD3381 DATABASE DESIGN AND MANAGEMENT LABORATORY L T P C
0 0 3 1.5

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

TOTAL : 45 PERIODS
HARDWARE:

•  Standalone Desktops

SOFTWARE:

•  PostgreSQL