DBMS - Database Management System

📌 Topics

• ER Model
• Normalization
• Transactions
• SQL

📘 Normalization

Concept

Normalization is the process of organizing data to reduce redundancy.

Key Points

• 1NF → Atomic attributes
• 2NF → No partial dependency
• 3NF → No transitive dependency
• BCNF → Stronger than 3NF

PYQ

Which normal form removes transitive dependency?
Answer: 3NF

Quick Revision

1NF → Atomic
2NF → Full dependency
3NF → No transitive