Consider the following relation and convert to the normal form
indicated. Make sure your Primary Key and its attribute(s) is/are
underlined for full credit. Also indicate foreign keys using (FK)
if any.
0NF:
ORDER[order_num, date, SSN, cust_name, phone,
email, (SKU, item_name, price)]
Notes:An order has only one
customer, but a customer can place many orders. Each order can have
multiple items.
1NF:
2NF:
3NF: