RelationalDBDesign 




Database Analysis   «Prev  Next»

Achieving 1NF - Exercise

Achieve first normal form: (project exercise 2)

Objective:Alter the given database table so that it is in first normal form.

Exercise scoring

This exercise is worth a total of 15 points. You will receive up to five points for correctly representing the original table in relational notation, up to five additional points for normalizing the table, and up to five additional points for representing the results in relational notation.

Background/overview

The ER diagram you developed in the first course in this series was the foundation for a database tracking Stories on CD customers and orders. The other side of the equation is where Stories on CD purchases the CDs it sells in the first place.
At first the company only purchased CDs from a single distributor. As their client base grew, Stories on CD expanded its offerings and began to buy CDs from more than one distributor.
In some cases, the same CD is available from multiple distributors.
The company's owners sketched a prototype table to store information about CDs and which distributors they were available from. The image is displayed below.
Achieving first normal form
Table consisting of columns where data redundancy has to be reduced


Your job is to take the information given to you and incorporate it into the database design.

Instructions

Represent the table from the previous graphic in relational notation, identify why the table is not in 1NF, normalize it to 1NF, and represent the resulting tables in relational notation.

Submitting your exercise

Type or paste the normalized relations into the text box below, then click Submit to submit the exercise and view the results page.