Question: Prepare an entity-relationship (ER) diagram using MySQL Workbench for the user requirements described below. Be sure that your ER diagram has the following elements: entities;

Prepare an entity-relationship (ER) diagram using MySQL Workbench for the user requirements described below. Be sure that your ER diagram has the following elements: entities; relationships between entities; primary and foreign keys, and other necessary columns for each entity.

Global Trading (GT) is a wholesale business that sells a variety of products; its customers are other businesses. Also GT's vendors are other businesses. GT has the following business rules for the database that the company wants you to design:

-A product is supplied by one or more vendors and a vendor may supply one or more products.

-Each sales order is prepared by one sales rep (salesrep). Each salesrep can prepare many sales orders.

-A sales order is written for a single customer, though a customer can have many orders.

-A single sales order can be for one or more products ordered.

Besides primary and foreign key columns, the database must be able to store data about the following data items:

-Product name- Customer name, phone number, and balance due

-Date of order- For each sales order, products ordered along with the quantity ordered and price per unit

-Vendor name and phone number- Quantity on hand for each product; vendor who supplied the product

-Salesperson name and phone number

-Some salesreps supervise other salesreps the database should allow identifying who supervises who.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!