Database Normalization Concepts

This assignment delves into the concept of database normalization, explaining its importance and various forms. It outlines First, Second, and Third Normal Forms (1NF, 2NF, 3NF) through examples and demonstrates how to achieve each form by removing transitive dependencies and redundancy in data models.

Normalisation
Student ID –
Student Name –
Subject Code -

Report
Dependency Diagram
Partial Dependency
FlProductName  FlProductCode
FlProductPrice  FlProductCode
FlVendorID  FlProductCode
FlVendorName  FlProductCode
FlPurchaseDate  FlInvoiceNumber
FlInvoiceDate  FlInvoiceNumber
FlQuantitySold  FlProductCode
FlQuantitySold  FlInvoiceNumber
Transitive Dependency
FlVendorName  FlVendorID

Normal Form Relations
First Normalised Entities
Second Normalised Entities
All entities are separate having primary key and all the fields are depending upon the
primary keys or composite keys only. Now the entities are in second normalization
form.

Third Normalised Entities
The transitive dependency has been removed from the tables and now all tables are in
third normal form.
(Guru99 2016)
(W3schools.in n.d)

Relational Schema

ER Diagram
References
Guru99 2016, Learn Database Normalization with the help of a case study, Viewed on
25th May 2017<http://www.guru99.com/database-normalization.html>
W3schools.in (n.d.), Database Normalization, Retrieved from
https://www.w3schools.in/dbms/database-normalization/