Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create the ERD for the following scenario: Trek Sports wants to keep track of customer purchases. For each product there is a product number (which

Create the ERD for the following scenario:

Trek Sports wants to keep track of customer purchases. For each product there is a product number (which is unique), product name, description, and price. Each invoice has a number (which is unique), and date. An invoice can include many products, and a product can appear in multiple invoices. An invoice must have at least one product, but a product may never be sold (so may not appear in any invoices). When a product is sold, the database should keep track of the quantity sold.

An invoice is written by a sales rep. A sales rep is identified by a unique number. The database should also capture the name and phone number of each sales rep. Each sales rep can write many invoices, but each invoice is written by a single sales rep. While an invoice must have a sales rep, a sales rep can be new and may not have written any invoices.

An invoice is written for a single customer. However, each customer can have many invoices. In order to be in the database, each customer must have at least one invoice. Also, each invoice must have a customer. For each customer, the database should record an ID (which is unique), name, address, and phone number.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Repairing And Querying Databases Under Aggregate Constraints

Authors: Sergio Flesca ,Filippo Furfaro ,Francesco Parisi

2011th Edition

146141640X, 978-1461416401

More Books

Students also viewed these Databases questions

Question

LO2 Identify components of workflow analysis.

Answered: 1 week ago