Reference no: EM133310318

Fred Jones dealership sells Fords, Hondas, and Toyotas. The dealership keeps information about each car manufacturer with whom it deals so that employees can get in touch with manufacturers easily. The dealership staff also keeps information about the models of cars that the dealership carries from each manufacturer. They also keep such information as 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. (For instance, they will record the buyer's name, the car he or she bought, and the amount he or she paid for the car). So that staff can contact the buyers in the future, contact information is also kept (e.g., address, phone number, email). Make a logical data model. Also write out a normalized set of relations from the model.