Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Location Inventory Loc_ID integer(10) Inv_ID integer(10) Location_Name varchar(255) LocationLoc_ID integer(10) integer (10) 8 Location_Phone ProductPro_ID -/- Stored at integer(10) -1- Customer Location_Address varchar(255) Employee Inventory_Space
Location Inventory Loc_ID integer(10) Inv_ID integer(10) Location_Name varchar(255) LocationLoc_ID integer(10) integer (10) 8 Location_Phone ProductPro_ID -/- Stored at integer(10) -1- Customer Location_Address varchar(255) Employee Inventory_Space integer(10) Customer_ID integer(10) Emp_ID integer(10) Assigned -- Inventory_Size integer(10) EmployeeEmp_ID integer(10) EmployeeEmp_ID integer(10) Inventory Qantity integer(10) ShipmentShip_ID integer(10) Goes to _ LocationLoc_ID integer (10) Customer_First Name varchar(255) Job_titleJob_ID integer(10) Assigned Customer_Last Name varchar(255) Employee_First Name varchar(255) Customer_Phone integer(10) Employee_Last_Name varchar(255) Stores Assigned Job_title Customer_Address varchar(255) Employee_Phone integer(10) PO- Job_ID integer(10) Employee_Address varchar(255) LocationLoc_ID integer(10) Job_Title_Name varchar(255) Product Job_Title_Discreption varchar(255) Pro_ID integer(10) Product_Name varchar(255) Product_Quantity Integer (10) Product_Price integer(10) Shipment Ship_ID integer(10) Goes to Product_SupplierProductPro_ ID integer(10) Product_Supplier - Product_SupplierSuppliersup_ID integer(10) Orders go to ProductPro_ID integer(10) Shipment_Address varchar(255) SupplierSup_ID integer(10) Shipment_Date integer (10) Supplier Sup_ID integer(10) Supplier_Name varchar(255) Supplier_Phone integer(10) Supplier_Address varchar(255) Powered By Visual Paradigm Community Edition5- Normalization Perform decompositions of the relations, such that the entire database is in 3NF 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 each table
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started