Normalization: A Comprehensive Analysis of Database Design Principles

ITC 556
Assessment item 3
Normalization
Student Name – Murali Krishna Palle
Student ID- 11593385
Table of Contents

First Normal Form...........................................................................................................................3
Second Normal Form.......................................................................................................................4
Third Normal Form..........................................................................................................................5
Relational Schema...........................................................................................................................6
Entity Relationship Diagram...........................................................................................................8
References........................................................................................................................................9
1

Task
2

Dependency diagram to show the functional dependencies in the relation
According to Coronel & Morris (2016), Functional dependencies are discussed in this report that
is fully functional, partial and transitive dependencies. The 1st NF, 2nd NF, 3rd NF, Relational
Schema and Entity Relationship Diagram for the above task have been presented in it.
First Normal Form
Figure 1: Dependency Diagram
The dependency diagram is presented in the figure 1 which shows the partial dependencies as
well as fully functional dependency. This is 1NF presentation as there is no redundant data and
the atomicity of the information is preserved (Thalheim, 2013).
3