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