create a logical data model that represents this file in third normal form. The fields include the following:

Part 2: Module Practice:

You have been given a file that contains the following 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.