Perform decompositions of the relations, such that the entire database is in 3 NF or BCNF. You need to analyze each relation, draw its dependency diagram, and describe which normal form it satisfies. If the form is not 3NF or BCNF, you need to apply the normalization steps and produce 3NF or BCNF tables. Deliverable: A PDF file including the normal form analysis of cache table.

 

Transcribed Image Text:

Customer Customer D EmployeeEmp, 10 ShipmentShip D Customer First Name 255) Customer Last Name Customer Phone Customer Address Integer 10) integer(10) integer(10) varchar(255) Integer (10) varchar(255) Coes to Employe Emp ID EmployeeEmp, 10 LecationLoc Job, briejob D it Employee First Name Employee Last Name Employer Phone is Employes, Address Coes to Integer(10) integer (10) integer(20) integer(10) varchar(255) varchar255) integer(10) varchar2551 Assigned Assigned Location Loc ID integer(10) Location Name varchar(255) Location Phone integer(10) Location Address c255) Assigned title Job ID LocationLoc ID Job Tam Integer (10) integer(10) varchar(255) Job Tide Discretion vaca255) Shipment Ship ID Product Supplier Product ID Product SupplierSupplier Sun, 10 Shipment Address Shipment, Date Integer(10) integer(10 integer vrch Inter(10) Stared at Orders Inventory Im ID LocationLoc D Product ID Inventory Soc Inventory Size itventory Qantity integer(10) integer(10) integer(10) integer(10) Integer(100 integer Stores Product Pro ID Product Name Product Quantity Integer (10) varchar(255) integer(10) Product Price integer) Product Suppler Preductre 10 integer(10) SupplierSup, ID integer(10) Suppler Sup 10 Suppler Name Supplier Phone integer(10) Supplier Address varchar(255) Integer(10) varchar(255) PBy Pain County 9 Customer Customer D EmployeeEmp, 10 ShipmentShip D Customer First Name 255) Customer Last Name Customer Phone Customer Address Integer 10) integer(10) integer(10) varchar(255) Integer (10) varchar(255) Coes to Employe Emp ID EmployeeEmp, 10 LecationLoc Job, briejob D it Employee First Name Employee Last Name Employer Phone is Employes, Address Coes to Integer(10) integer (10) integer(20) integer(10) varchar(255) varchar255) integer(10) varchar2551 Assigned Assigned Location Loc ID integer(10) Location Name varchar(255) Location Phone integer(10) Location Address c255) Assigned title Job ID LocationLoc ID Job Tam Integer (10) integer(10) varchar(255) Job Tide Discretion vaca255) Shipment Ship ID Product Supplier Product ID Product SupplierSupplier Sun, 10 Shipment Address Shipment, Date Integer(10) integer(10 integer vrch Inter(10) Stared at Orders Inventory Im ID LocationLoc D Product ID Inventory Soc Inventory Size itventory Qantity integer(10) integer(10) integer(10) integer(10) Integer(100 integer Stores Product Pro ID Product Name Product Quantity Integer (10) varchar(255) integer(10) Product Price integer) Product Suppler Preductre 10 integer(10) SupplierSup, ID integer(10) Suppler Sup 10 Suppler Name Supplier Phone integer(10) Supplier Address varchar(255) Integer(10) varchar(255) PBy Pain County 9