ased on the information given below, draw the conceptual EERD where you should include the enhanced features

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

Based on the information given below, draw the conceptual EERD where you should include the enhanced features.

• A car dealership wishes to maintain data about the customers who purchase a
car. Each customer may purchase one or more vehicles and each vehicle can be
purchased by many different customers over time (for example, a customer may
purchase a new vehicle, trade that vehicle in and someone else can purchase
the vehicle traded in.) Data that the dealership wishes to keep regarding
customers includes customer identification number, name, address, home
phone, work phone, cell phone and e-mail address.
• Information about vehicle includes vehicle identification number, make, model,
year, transmission type, engine size and color. Vehicles can be a member of one
of the following categories: cars, trucks, minivans or SUVS. A vehicle can be a
member of only one category at a given time. Trucks, minivans and SUVS have
unique attributes – cars does not. Trucks have the following unique attributes:
Cab (example: regular, super or crew) and Driver (for example: 94X2 or (4X4);
Minivans have Accessory package and SUVS have SUV style.
• The dealership is interested in the date of Purchase, amount of sale and
Salesperson(s) completing each sale.
Transcribed Image Text:• A car dealership wishes to maintain data about the customers who purchase a car. Each customer may purchase one or more vehicles and each vehicle can be purchased by many different customers over time (for example, a customer may purchase a new vehicle, trade that vehicle in and someone else can purchase the vehicle traded in.) Data that the dealership wishes to keep regarding customers includes customer identification number, name, address, home phone, work phone, cell phone and e-mail address. • Information about vehicle includes vehicle identification number, make, model, year, transmission type, engine size and color. Vehicles can be a member of one of the following categories: cars, trucks, minivans or SUVS. A vehicle can be a member of only one category at a given time. Trucks, minivans and SUVS have unique attributes – cars does not. Trucks have the following unique attributes: Cab (example: regular, super or crew) and Driver (for example: 94X2 or (4X4); Minivans have Accessory package and SUVS have SUV style. • The dealership is interested in the date of Purchase, amount of sale and Salesperson(s) completing each sale.
Expert Solution
steps

Step by step

Solved in 5 steps with 2 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY