Design a database for an automobile company to provide to its dealers to assistthem in maintaining customer records and dealer inventory and to assist salesstaff in ordering cars. Each vehicle is identified by a vehicle identification number (VIN). Each individualvehicle 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 modelcan be offered with a variety of options, but an individual car may have onlysome (or none) of the available options. The database needs to store informationabout models, brands, and options, as well as information about individualdealers, customers, and cars.Your design should include an E-R diagram, a set of relational schemas, anda list of constraints, including primary-key and foreign-key constraints.
Design a database for an automobile company to provide to its dealers to assistthem in maintaining customer records and dealer inventory and to assist salesstaff in ordering cars. Each vehicle is identified by a vehicle identification number (VIN). Each individualvehicle 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 modelcan be offered with a variety of options, but an individual car may have onlysome (or none) of the available options. The database needs to store informationabout models, brands, and options, as well as information about individualdealers, customers, and cars.Your design should include an E-R diagram, a set of relational schemas, anda list of constraints, including primary-key and foreign-key constraints.
Database Systems: Design, Implementation, & Management
11th Edition
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Chapter10: Transaction Management And Concurrency Control
Section: Chapter Questions
Problem 1P
Related questions
Question
Design a 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. |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning