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

Musical group name CD title 2 Musicians in group CD title 3 Date group was formed CD 1 length Group’s agent CD 2 length CD title 1 CD 3 length Assumptions:

• 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.