Each vehicle is identified by vehicle identification number

Assignment Help Other Subject
Reference no: EM13207903

Design a database for an automobile company to provide to its dealers to assist them in maintaining customer records and dealer inventory and to assist sales staff in ordering cars.

Each vehicle is identified by a vehicle identification number (VIN). Each individual vehicle is a particular model of a particular brand offered by the company (e.g., the XF is a model of the car brand Jaguar of Tata Motors). Each model can be offered with a variety of options, but an individual car may have only some (or none) of the available options. The database needs to store information about models, brands, and options, as well as information about individual dealers, customers, and cars.

Your design should include an E-R diagram, a set of relational schemas, and a list of constraints, including primary-key and foreign-key constraints.
(it wont be mentioned in software, the database design will be expressed in terms of a relational database design, it will consist only diagram, mentioned schemas in the question and constraints.)

Reference no: EM13207903

Questions Cloud

Analyze the debate surrounding capital punishment : Describe the fundamental philosophies surrounding the purpose of sentencing. Describe the factors that go into the determination of each specific sentence. Analyze the debate surrounding capital punishment.
Discuss difference between microcontroler and microprocessor : Discuss the differences between microcontrollers and microprocessors.
Explain what alkene would be produced by the dehydration : What alkene (including cis and trans isomers) would be produced by the dehydration of the following alcohols? Where possible, predict the relative amounts of each product according to Zaitsev's rule.
Calculate marginal cost of capital : Calculate the Net Present Value and Internal Rate of Return and calculate Marginal cost of capital in the interval between each of the breaking points and graph the MCC schedule in its step function form.
Each vehicle is identified by vehicle identification number : Design a database for an automobile company to provide to its dealers to assist them in maintaining customer records and dealer inventory and to assist sales staff in ordering cars.
Compute the thermal energy evolved : When butane gas, C4H10, burns in oxygen gas, O2, to form carbon dioxide gas, CO2, and gaseous water, 2845 kJ of thermal energy is evolved per mole of butane burned.
What is the probability that a random sample have average : Starting salaries of economics majors have a mean of $47,000/year with a standard deviation of $8,000. What is the probability that a random sample of 100 majors will have an average salary of more than $50,000 year
What are the pro and con of digital rights managment : What are the pro's and con's of Digital Rights Managment?
Describe operation and its different components or stages : Describe your operation, its different components or stages, the materials used and the type of wastes generated. What is your waste management plan and approach for protecting the environment and human health?

Reviews

Write a Review

 

Other Subject Questions & Answers

  Animal farming affect the environment on different scale

How do sustainable animal farming and industrial-style animal farming affect the environment on different scale?

  Information about benefits of globalization

This solution discusses what the supporters of globalization celebrate. With regard to consumerism, immigration, and nutrition, it also offers examples.

  Etiology-s of addiction family model and disease model

Write down 750-1,000 word paper explaining similarities and differences between following etiology's of addiction: Family Model and Disease Model.

  Plato and aristotle

How did Plato and Aristotle differ in their ideas about the virtue of temperance? Plato and Aristotles ideas about temperance seem to be very similar.

  Suppose that mike cannot afford to pay the premium

Suppose that Mike cannot afford to pay the premium and lets his auto insurance policy lapse. At the time of the accident, he is uninsured. If the liability judgment against Donna $100 000, how much, if any, will Donna's insurer pay.

  Demographic transition

Most developed nations are in what phase of the demographic transition?

  What is the role of govenor in the budgetary process

What is the role of govenor in the budgetary process?

  Clinical psychology on cultural diversity

Why does clinical psychology focus on cultural diversity so much in today's society?What issues might a clinical psychologist encounter that relate to cultural diversity?

  Different schools of thought in sociology

In studying sociology there're two different schools of thought. The first is that the sociologist should study facts only, without the interference of personal interests or values.

  Hormones-nutrition-cells-tissue and inflammation

What do hormones have to do with Nutrition? How does the nervous system interact with Nutrition?

  Explain phenomenon being described in terms of concept

Stimulation may be subliminal, may produce sensory adaptation or may be less than optimal. Below, explain phenomenon being described in terms of concept listed after it.

  Future of nursing recommendations

In a reflection of 450-600 words, describe how you see yourself fitting into the given IOM Future of Nursing recommendations:

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd