Database Normalization Explained

This assignment delves into the concept of database normalization, explaining its importance and various forms (1NF, 2NF, 3NF). It includes a dependency diagram illustrating relationships between tables and describes how rules are applied to achieve Third Normal Form. The document also explores the relational schema and provides references for further learning.

Normalisation
Student ID –
Student Name –
Subject Code -
Date -

Report
Dependency Diagram
Dependency diagram is showing below-
ProdName  ProdCode
ProdPrice  ProdCode
VendorID  ProdCode
VendorName  ProdCode
PurchaseDate  InvNo
InvDate  InvNo
VendorName  VendorID
QtySold  ProdCode
QtySold  InvNo
(Adrienne Watt n.d.)

3NF Relations
1 NF
2 NF

3 NF
Following rules of third normal form are applied on the tables to make the tables into
3 NF-
1. Every table contains the primary key.
2. All another fields depend upon the primary key field.
3. There is no transitive dependency in any table.

Relational Schema
(holowczak.com 2016)

ER Diagram
References
Adrienne Watt (n.d.), Chapter 11 Functional Dependencies, Retrieved from
http://opentextbc.ca/dbdesign/chapter/chapter-11-functional-dependencies/
holowczak.com (2016), Converting E-R Models to Relational Models, Retrieved from
http://holowczak.com/converting-e-r-models-to-relational-models/