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: your answer should be in 2 pages.
- 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.