Describe how you would denormalize the model that you created in exercise E. Draw the new class

Question:

Describe how you would denormalize the model that you created in exercise E. Draw the new class diagram based on your suggested changes. How would performance be affected by your suggestions?

Exercise E

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.

Step by Step Answer:

Related Book For  book-img-for-question

Systems Analysis And Design With UML 2.0

ISBN: 9781118037423

4th Edition

Authors: Alan Dennis, Barbara Haley Wixom, David Tegarden

Question Posted: