Design a database for an automobile company

Assignment Help Basic Computer Science

Reference no: EM131058160

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.

Reference no: EM131058160

Questions Cloud

What is the dollar value of sales : The company has total fixed costs of $10,000.00. How many values must the company sell to breakeven? How many truck values, car values, and motor bike values need to be sold? What is the dollar value of sales that must be made for the company to b..

Arrange a tour for your self to learn about recycling : Arrange a tour for your self (and others if you can get a group together) to learn about recycling, sewage or water treatment, or any other type of industry related to this course.

National organization serving nurses : The American Society of PeriAnesthesia Nurses (ASPAN; www.aspan.org) is a national organization serving nurses practicing in ambulatory surgery, preanesthesia, and postanesthesia care. The organization's membership is listed below.

Design a database for an automobile company : 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.

Identify specific environmental stewardship activities : This can include the removal of exotic species, trail repair, etc. Also, there are environmental groups that identify specific environmental stewardship activities that need volunteers to help pick up trash, plant trees, etc.

Design a database for a world-wide package delivery company : The database must be able to keep track of customers (who ship items) and customers (who receive items); some customers may do both.

Conduct a critical literature review of your research topic : What have researchers said about your research topic? What types of studies have they done, and what have been the findings and what epistemological perspectives have served as the foundation for these studies?

List of the aliments and their cluster membership : Get the dataset "food.txt" from GauchoSpace and read it with R. Alternatively you can download this data set from the library cluster.datasets with the following code:

User Account

All Pages