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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started