Normalization

Normalization is the process for converting complex data structures into simple, stable data structures.

It is necessary because it makes the database more efficient (performance-wise), reduce the amount of data, free design of update, insertion and deletion anomalies, follows the rules regarding relational databases, and shows pertinent relationship between entities.

Due to time constraints, the database design will go through only three phases in normalization. 1NF (Normalized Form), 2NF, and 3NF will be applied to the databases.

	UNF ProductID Description ClassID Class Description Unit UnitPrice UnitCost ExpDate Quantity
	1NF ProductID Description Unit UnitPrice UnitCost ExpDate Quantity	ProductID ClassID Class Description
	2NF & 3NF ProductID Description Unit UnitPrice UnitCost ExpDate Quantity	ProductID ClassID ClassID Class Description

	UNF TransactionID Date ProductID Product Description Quantity BillID Transaction Type
	1NF TransactionID Date BillID Transaction Type	TransactionID ProductID Product Description Quantity
	2NF & 3NF TransactionID Date BillID Transaction Type	TransactionID ProductID Quantity ProductID Product Description

UNF

Consolidated Rec No.
ProductID
Product Description
Quantity Sold
Quantity Disposed
Date

1NF

Consolidated Rec No.
Date

Consolidated Rec No.
ProductID
Product Description
Quantity Sold
Quantity Disposed

2NF & 3NF

Consolidated Rec No.
Date

Consolidated Rec No.
ProductID
Quantity Sold
Quantity Disposed

ProductID
Product Description

	UNF SupplierID Name Address Fax No. Tel No. ContactPer ProductID Product Description Last Bought Price
	1NF SupplierID Name Address Fax No. Tel No. ContactPer	SupplierID ProductID Product Description Last Bought Price
	2NF & 3NF SupplierID Name Address Fax No. Tel No. ContactPer	SupplierID ProductID Last Bought Price ProductID Product Description

	UNF OrderID Date Ordered Date Expected Supplier ID Supplier Name ProductID Product Description Quantity
	1NF OrderID Date Ordered Date Expected Supplier ID Supplier Name	OrderID ProductID Product Description Quantity
	2NF OrderID Date Ordered Date Expected Supplier ID Supplier Name	OrderID ProductID Quantity ProductID Product Description
	3NF OrderID Date Ordered Date Expected SupplierID Supplier Name	OrderID ProductID Quantity ProductID Product Description