Why is this table not in first normal form 1nf


1. What is normalization? Why is it important?

2. What is functional dependency?

3. Why is this table NOT in First Normal Form (1NF) normalization? What can you do to put it in 1NF?

ORDERS

OrderNum OrderDate PartNum NumOrdered
21608 10/20/2007 AT94 11
21617 10/23/2007 BV06 2
CD52 4
21619 10/25/2007 DR93 1

Solution Preview :

Prepared by a verified Expert
Database Management System: Why is this table not in first normal form 1nf
Reference No:- TGS01258759

Now Priced at $20 (50% Discount)

Recommended (97%)

Rated (4.9/5)