Third Normal Form
Explore how to apply the Third Normal Form in database normalization by identifying and removing transitive dependencies. Understand the importance of decomposing tables like the SCORE table into related tables to ensure efficient and logical database design, preparing you for advanced normalization concepts.
We'll cover the following...
We'll cover the following...
Third normal form (3NF)
For a table to be in the third normal form:
-
It should be in the second normal form.
-
It should not have transitive dependency.
Example
SCORE Table
| Std_Id | Subject_Id | Marks_obtained | Exam_Type | Total_Marks |
|---|---|---|---|---|
| 1 | CS-100 | 50 | Mid-term | 100 |
| 2 | CS-100 | 70 | Final | 100 |
| 3 | CS-100 | 85 |