Each vehicle is identified by vehicle identification number

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?

User Account

All Pages