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.
