AD3381– EX6 | Database Normalization (Bottom-Up) Using PostgreSQL| DDM Lab EXECUTION Tamil|AU R-2021

Описание: 📘 AD3381 – Database Design and Management Lab
🎓 Department: B.Tech AI&DS – Regulation 2021
📍 Experiment 6: Database Design using Normalization – Bottom-Up Approach
🛠️ Tool Used: pgAdmin with PostgreSQL
🗣️ Language: Tamil Explanation

In this lab video, you will learn:
✅ Step-by-step Normalization process (1NF, 2NF, 3NF)
✅ Designing bottom-up database schema
✅ Implementing normalized tables in PostgreSQL via pgAdmin
✅ Complete execution for Anna University Lab Practical

💡 Ideal for: Slow learners, Arrear students, and Final Lab Practicals

🔔 Don’t forget to Like, Share & Subscribe to Cyber Codex for full lab manual, viva questions, and R-2021 Notes.

📺 Watch More:

EX5 – Stored Procedures, Triggers & Constraints → [   • AD3381 Ex 4 – SQL Data Manipulation Querie...  ]

EX4 – SQL Queries (DML & Joins) → [   • AD3381 Ex 4 – SQL Data Manipulation Querie...  ]

AD3381-DDM PLAYLIST→ [   • AD3381-Database Design and Management Lab  ]

00:00 – Intro to EX6 & Importance of Normalization
01:15 – What is Bottom-Up Database Design?
02:00 – Understanding 1NF with Example
03:10 – Moving to 2NF with Dependencies
04:40 – Applying 3NF and Final Schema
05:20 – Table Creation in pgAdmin (PostgreSQL)
06:30 – Insert and Query Normalized Tables
07:10 – Summary and Viva Q&A
08:00 – Final Tips for Lab Exams