Warning: Trying to access array offset on value of type bool in /home/topgsnkq/timelyhomework.com/wp-content/themes/enfold/framework/php/function-set-avia-frontend.php on line 570
Part 2: Module Practice: You have been given a file that contains the following fields relating to CD information. Using the…
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 lengthThe 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.