Create a logical data model

Assignment Help Computer Engineering

Reference no: EM131164354

Jim Smith's 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 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). Create a logical data model. (You may have done this already in Chapter 7.) Apply the rules of normalization to the model to check the model for processing efficiency.

Reference no: EM131164354

Questions Cloud

What types of files would be needed : Visit a commercial Web site (e.g., CDnow, Amazon. com). If files were being used to store the data supporting the application, what types of files would be needed? What data would they contain?

What toyota obtains from its production system : What other benefits do you think Toyota obtains from its production system? Think in broader terms than just production, and consider financial, marketing, and human resource management issues

In what companies has the dbms been implemented : In what companies has the database management system (DBMS) been implemented, and for what purposes? According to the information that you found, what are three strengths and weaknesses of the product?

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

Create a logical data model : Create a logical data model. (You may have done this already in Chapter 7.) Apply the rules of normalization to the model to check the model for processing efficiency.

Extent of the liabilities of partners : What is the extent of the liabilities of partners in a general partnership? How does the limited partnership differ from the general partnership? What actions, if any, should the partnership take during any "winding up" period?

How you would denormalize the model that you created : Describe how you would denormalize the model that you created in question E. Draw the new physical model on the basis of your suggested changes. How would performance be affected by your suggestions?

Examine the physical data model that you created : Examine the physical data model that you created in question F. Develop a clustering and indexing strategy for this model. Describe how your strategy will improve the performance of the database.

Analysis of strengths-weaknesses-opportunities : Conduct a SWOT (analysis of strengths, weaknesses, opportunities, threats) on the company's internal environment. Do not use a company generated SWOT, conduct your own.

User Account

All Pages