Search⌘ K

Exercise 2

Understand how to determine whether a customer table complies with third normal form and practice converting it to 3NF. Explore the normalization process to ensure your database design promotes efficiency and eliminates redundant data, reinforcing key concepts from normalization theory.

We'll cover the following...

Problem statement

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

Customer table

Cust_Id Cust_Name DOB
...