Develop an appropriate schema to store data

Reference no: EM133024687

Question: Consider the following mini-world description:

A car dealership wants to store information on the types of cars it has. For each type of car it sells, it wants to store a unique identifier, its make and model, and its year. They also want to store its MSRP (i.e. suggested price). They also want to store a table that keeps track of the inventory. For each type of car, they need to keep how many of each color they have in stock.

Develop an appropriate schema to store this data. Be sure to identify any primary, candidate, and foreign keys in your design. Inclue (a few sentences per table) justifying your design.

Reference no: EM133024687

Questions Cloud

Identify the main privacy principals : Identify the main privacy principals (what legislation requires you to do when handling customer information)?

What is standard deviation of the probability distribution : What is the standard deviation of the probability distribution and Based on the store historical data, the probability of x is provided

Analyze state farm insurance company : Analyze state farm insurance company by using Value Chain & Resource-Based View Analysis?

What is meant by the term the social contract : Q. What is meant by the term, The Social Contract. Outline how the social contract is linked to the changes in the drivers of business over time.

Develop an appropriate schema to store data : Develop an appropriate schema to store this data. Be sure to identify any primary, candidate, and foreign keys in your design.

Evaluate the comparative branding strategy : On Aug 22, 2021 Dabur rolled out a front-page ad in The Telegraph newspaper claiming its 'Anmol Jasmine' hair oil brand "gives soft and shiny hair & 66% mor

What is one reason why certain organizations promote : What is one reason why certain organizations promote SDG reporting more than others according to Rosati and Faria (2019)?

Describe lemonade approach to providing insurance : Describe in detail Lemonade's approach to providing insurance and specifically identify at least two different ways that Lemonade's approach differs from the mo

How can managers deal with these problems : What are some examples in which this motivation is the driving force behind international expansion and How can managers deal with these problems

User Account

All Pages