Question: What can we say about this database table? CustomerID FirstName LastName Phone 1 Phone 2 1 Cherise Johnson 8 5 6 - 5 5 5

What can we say about this database table?
CustomerID
FirstName
LastName
Phone 1
Phone 2
1
Cherise
Johnson
856-555-1212
856-555-1313
2
Gwen
Leong
856-555-3131
3
Tarek
Faber
609-555-1414
609-555-1111
It is not in first normal form
It is in first normal form, but it is not in second normal form
It is in first and second normal forms, but it is not in third normal form
We should not store a second phone number for a customer
It has an acceptable design

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!