Database Normalization: A Practical Example

ITC556 – Database System
Assessment Item3 – Normalisation
Student Name: Manpreet Singh
Student ID: 11662075

Manpreet Singh 11662075
Table of contents
TASK1....................................................................................................................................................2
TASK 2....................................................................................................................................................3
1NF....................................................................................................................................................3
2NF....................................................................................................................................................4
3NF....................................................................................................................................................5
Task 3.....................................................................................................................................................6
References.............................................................................................................................................7
List of figures
Figure 1: dependency............................................................................................................................2
Figure 2: 1NF.........................................................................................................................................3
Figure 3: 2NF.........................................................................................................................................4
Figure 4: 3NF.........................................................................................................................................5
1

Manpreet Singh 11662075
TASK1
Figure 1: dependency
This table consists of 3 functional dependency that is a partial, full and transitive dependency.
The table consists of two primary keys (Psarris, 2004)
 ISBN
 TITLE
Edition shows only full dependency with both ISBN and Title.
Autor_FirstName, Author_lastName, and date is partially dependent on ISBN
Publisher and media is partially dependent on Title
Media is dependent on a nonprime attribute Publisher which depicts transitive dependency
2