You have been given a file that contains the following fields relating to CD information. Using the steps of normalization, create a model that represents this file in third normal form. The fields include:

Assumptions:
• 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.
5 Jim Smith’s dealership sells Fords, Hondas, and Toyotas. The dealership keeps information about each car manufacturer with whom they deal so that they can get in touch with them easily. The dealership also keeps information about the models of cars that they carry from each manufacturer. They keep information like list price, the price the dealership paid to obtain the model, and the model name and series (e.g., Honda Civic LX). They also keep information about all sales that they have made (instance.g., they record a buyer’s name, the car bought, and the amount paid for the car). To contact the buyers in the future, contact information is also kept (e.g., address, phone number).
Create a class diagram for this situation. Apply the rules of normalization to the class diagram to check the diagram for processing efficiency.

Transcribed Image Text:

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