Leslie’s Auto Sales has a relational database with which it maintains data on its salespersons,its customers, and the automobiles it sells. Each of these three entity types has a uniqueattribute identifier. The attributes that it stores are as follows:Salesperson Number (unique), Salesperson Name, Salesperson Telephone, Years withCompanyCustomer Number (unique), Customer Name, Customer Address, Value of LastPurchase From UsVehicle Identification Number (unique), Manufacturer, Model, Year, Sticker Price Leslie’s also wants to keep track of which salesperson sold which car to which customer, including the date of the sale and the negotiated price. Construct an ERD for Leslie’s Auto Sales. Crow’s Foot Database Notation is required.

Introduction: An ER diagram (Entity-Relationship diagram) is a graphical representation of entities…

Answered: Leslie’s Auto Sales has a relational…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Leslie’s Auto Sales has a relational database with which it maintains data on its salespersons,

its customers, and the automobiles it sells. Each of these three entity types has a unique

attribute identifier. The attributes that it stores are as follows:

Salesperson Number (unique), Salesperson Name, Salesperson Telephone, Years with

Company

Customer Number (unique), Customer Name, Customer Address, Value of Last

Purchase From Us

Vehicle Identification Number (unique), Manufacturer, Model, Year, Sticker Price

Leslie’s also wants to keep track of which salesperson sold which car to which customer, including the date of the sale and the negotiated price. Construct an ERD for Leslie’s Auto Sales. Crow’s Foot Database Notation is required.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

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.

Similar questions