Exercise 1

This exercise will test your knowledge of 2NF.

We'll cover the following

Problem Statement

First, determine whether the following table is in second normal form. If it is not in 2NF, then convert it into 2NF.

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
2 Bruce 62 Glasses Clothing
5 Veronica 84 Shirts Clothing

Take your time with this problem. Take a look at the second normal form lesson if you have trouble remembering the concept.

Hint: Start with identifying the primary key.

We will discuss the solution in the next lesson.

Get hands-on with 1200+ tech skills courses.