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
...