You have been given a file that contains fields relating to

You have been given a file that contains fields relating to CD information. Using the steps of normalization, create a logical data model that represents this file in third normal form. The fields include the following:

• Musical group name

• Musicians in group

• Date group was formed Group’s agent

• CD title 1

• CD title 2

• CD title 3

• CD 1 length

• CD 2 length

• CD 3 length

The assumptions are as follows:

• Musicians in group contains a list of the members of the people in the musical group.

• Musical groups can have more than one CD, so both group name and CD title are needed to uniquely identify a particular CD.

Solution