Calculate the size of the database that you created in exercise F. Provide size estimates for the initial size of the database as well as for the database in one year’s time. Assume that the dealership sells ten models of cars from each manufacturer to approximately 20,000 customers a year. The system will be set up initially with one year’s worth of data.

Exercise F

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?