This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Order Table: Order_id Order_date Customer_id Item_id Item_qty Item_total_price Order_price Customer Table: Customer_id Customer_name Customer_address Customer_city Customer_state Item Table: Item_id Item_description Item_price 3NF Table: To reduce the table further into 3NF, we do the following decomposition: We split the order table into two. One table will hold the order summary while the other will hold the order details. Order Summary Table: Order_id Order_date Customer_id Order_price Order Details Table: Order_id Item_id Item_qty Item_total_price...
View Full Document
- Spring '11
- primary key, Database normalization, 2NF, Order_id Order_date Customer_id