Solution to Exercise 1
In this lesson we will discuss the solution to exercise 1.
We'll cover the following...
Solution
The second normal form states that it should meet all the rules for 1NF and there must be no partial dependencies between any of the columns with the primary key.
Customer-order table
Cust_Id | Cust_Name | Order_Id | Order_Detail | Order_Category |
---|---|---|---|---|
1 | Jack | 34 | Shampoo | Hygiene |
2 | Bruce | 22 | TV | Electronics |
3 | Amanda | 84 | Shirts | Clothing |
4 | James | 12 | Shoes | Clothing |