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