Question: 1 6 . ( 1 pt ) Why is the table on the previous page considered to be unnormalized ? a ) There are multiple

16.(1 pt) Why is the table on the previous page considered to be unnormalized?
a) There are multiple items in a field.
b) Duplicate records exist.
c) There is no primary key field for the table.
d) Only a) and b) are correct answers.
e) Answers a), b) and c) are all correct.
The first step in normalizing the table on the previous page is to eliminate any duplicate fields and see that no empty cells exist. In addition, you want to identify any primary fields.
17.(2 pts) Enter the field names and data that would result when the table is normalized to 1NF. Be sure to enter your choice of Key Fields in the Yellow boxes below.

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!