+ 3. Below is a relational table of a retail company. The customer details, order details & product details are given al

[answerhappygod]

3 Below Is A Relational Table Of A Retail Company The Customer Details Order Details Product Details Are Given Al 1 (168.1 KiB) Viewed 19 times

+ 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 & answer the following 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 O Date is dependent on OID) OID -> O Date CID -> C_Name PID -> P_Desc PID -> P Price OID -> CID CID -> C State PID and OID -> Qty OID 5006 O Date 10/24/21 CID 2 5007 10/25/21 6 C_Name C State Alex GA Aaron NY PID P_Price Qty 6,5,4 Table, Desk, 650,325,300 1,8,5 Chair Dresser, Chair 3,4 P Desc 450,300 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.