Normalization of Bank, Manager, Branch, Customer, Employees, Deliveries and Products

Normalize the given tables in 1NF, 2NF, and 3NF.

3 Pages574 Words54 Views

Added on 2023-05-29

About This Document

This article explains the normalization process of Bank, Manager, Branch, Customer, Employees, Deliveries and Products tables in 1NF, 2NF and 3NF with no repeating groups, partial dependencies and transitive dependencies.

Normalization of Bank, Manager, Branch, Customer, Employees, Deliveries and Products

Normalize the given tables in 1NF, 2NF, and 3NF.

Added on 2023-05-29

Related Documents

Bottom-up Approach: Normalization
Normalization of the Bank
UN 1NF 2NF 3NF
Bank_ID (PK)
Bank_Name
Bank_TelNo
Bank_Lodation
Bank_AC
Bank_Sort-code
Bank_ID
Bank_Name
Bank_TelNo
Bank_Lodation
Bank_AC
Bank_Sort-code
Bank_ID
Bank_Name
Bank_TelNo
Bank_Lodation
Bank_AC
Bank_Sort-code
Bank_ID
Bank_Name
Bank_TelNo
Bank_Lodation
Bank_AC
Bank_Sort-code
This relation is already in 3NF since no repeating groups, no partial
dependencies and no transitive dependencies exist in the relation.
Normalization of the Manager
UN 1NF 2NF 3NF
Manager_No
(PK)
Manager_Name
Manager_TelNo
Manager_Addres
s
Manager_JobTitl
e
Bank_ID (FK)
Manager_No
Manager_Name
Manager_TelNo
Manager_Addres
s
Manager_JobTitl
e
Bank_ID
Manager_No
Manager_Name
Manager_TelNo
Manager_Addres
s
Manager_JobTitl
e
Bank_ID
Manager_No
Manager_Name
Manager_TelNo
Manager_Addres
s
Manager_JobTitl
e
Bank_ID
This relation is already in 3NF since no repeating groups, no partial
dependencies and no transitive dependencies exist in the relation.
Normalization of the Branch
UN 1NF 2NF 3NF
BranchNo (PK)
Branch_Street
Branch_City
Branch_Telepho
ne
Branch_Email_ID
Manager_No
((FK)
BranchNo
Branch_Street
Branch_City
Branch_Telepho
ne
Branch_Email_ID
Manager_No
BranchNo
Branch_Street
Branch_City
Branch_Telepho
ne
Branch_Email_ID
Manager_No
BranchNo
Branch_Street
Branch_City
Branch_Telepho
ne
Branch_Email_ID
Manager_No
This relation is already in 3NF since no repeating groups, no partial
dependencies and no transitive dependencies exist in the relation.

Normalization of Bank, Manager, Branch, Customer, Employees, Deliveries and Products_1

End of preview

Want to access all the pages? Upload your documents or become a member.