Answer Happy

1. Define Normalization & the purpose of Normalization 2. Explain the stages of Normalization (until 3 NF) 3. Below is a relational table of a retail company. The customer details, order details & product details are given along with their functional dependencies. Convert the table to normalized form (Until2 NF) & answer the questions. (25 Marks) OID Order ID, Q Date= Order Date, CID = Customer ID, C_Name Customer Name, C_State Customer's State, PID = Product id, P_Desc= ProductName, P.Price = Product Price, Qty = Quantity Purchased Note: 7, 5, 4 means three Product IDs. Similarly, 1,1, 5 means three Quantities etc. Functional Dependencies (OID -> Q Date means that Q Date is dependent on OID) OID -> O Date CID -> C Name PID -> P Desc PID -> P Price OID -> CID CID -> Ç State PID and OID -> Qty O Date 10/24/21 5007 10/25/21 6 OID 5006 CID 2 C. Name Alex Aaron C State GA NY (10 Marks) (10 Marks) PID P Desc P Price Qty 6,5,4 Table, Desk, 650,325,300 1,8,5 Chair Dresser, Chair 450,300 3,4 4,6
(a) What form is the table already in? (b) Describe and illustrate the process of normalizing the data shown in this table to third normal form (3NF). (c) Identify the primary and foreign keys in your 3NF relations. 4. Below is a table of a Construction Company with the Employees, Department, Projects & Budget Information. Convert the table to normalized form & answer the questions (25 Marks) Dep ID Dep Name Emp ID Functional Dependencies Emp ID and Proj ID -> Budget time Proj ID -> Proj Name Emp ID-> Emp Name Emp ID-> Dept ID Emp_Name Proi ID Proj Name Budget Time (a) What form is the table already in? (b) Describe and illustrate the process of normalizing the data shown in this table to third normal form (3NF). (c) Identify the primary and foreign keys in your 3NF relations.