Database Normalization: A Practical Guide to 1NF, 2NF, and 3NF

ITC556 – Database System
Assessment Item3 – Normalisation
Student Name: Saketh Chava
Student ID: 11613481

Saketh Chava 11613481
Table of contents
TASK1....................................................................................................................................................2
Task 2.....................................................................................................................................................4
1NF....................................................................................................................................................4
2NF....................................................................................................................................................5
3NF....................................................................................................................................................6
TASK 3....................................................................................................................................................7
References.............................................................................................................................................8
List of figures
Figure 1: dependency diagram..............................................................................................................3
Figure 2: 1NF.........................................................................................................................................4
Figure 3: 2NF dependency.....................................................................................................................5
Figure 4: 3NF dependency.....................................................................................................................6
Figure 5: Referential Integrity................................................................................................................7
1

Saketh Chava 11613481
TASK1
The table is decomposed in 3NF; all the transitive dependency and partial dependencies
have been removed from the table. There will be in total 5 tables after decomposition
(Costa, 2017)
2 NF functional dependencies
 firstName & lastName is completely dependent to ISBN
 Lastname has complete dependency on firstName
 Editor & date is co is fully dependent on the ISBNmpletely
dependent on Title & ISBN
 Publisher & media has completely dependent to Title
2