Question: Change this table to 1NF, 2NF and 3NF: OID = Order ID, O Date=Order Date, CID = Customer ID, C_Name = Customer Name, C_State Customer's

Change this table to 1NF, 2NF and 3NF:

Change this table to 1NF, 2NF and 3NF: OID = Order ID,

OID = Order ID, O Date=Order Date, CID = Customer ID, C_Name = Customer Name, C_State Customer's State, PID=project id, P_Desc=Project Name, P_Price = Product Price, Qty = Quantity Purchased Note: 7,5,4 means three Product IDs. Similarly, 1, 1, 5 means three Quantities. Functional Dependencies are: OID -> Date CID -> C_Name OID -> CID CID -> C State PID -> P Desc PID and OID -> Qty PID -> P_Price OID 1006 O Date CID 10/24/09 2 C Name C State PID P Desc P Price Qty Apex NC 7.5.4 Table, 800, 1, 1,5 Desk, 325, Chair 200 Acme GA 11,4 Dresser, 500, 4,6 Chair 200 1007 10/25/096

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!