Question
Prepare an entity-relationship (ER) diagram using MySQL Workbench for the business case described below. Your ER diagram should have entities and relationships between entities. Every
Prepare an entity-relationship (ER) diagram using MySQL Workbench for the business case described below. Your ER diagram should have entities and relationships between entities. Every entity in the diagram should have primary key. Also, entities should have foreign key columns as necessary along with other columns as described in the business requirements listed below. Please type your full name in a text box above the diagram. Save the diagram in MySQL Workbench as an .mwb file
Business Case
International Trading is a wholesale business organization that sells a variety of products to its retail business customers (which include retailers such as Target, Wal-Mart, etc.). International Trading has asked you to design a small database with the following business rules and requirements:
When an International Trading customer purchases products, an invoice is prepared for the customer. A single invoice can list one or more products that the customer has purchased including product information such as price per unit and quantity sold.
An International Trading customer may receive one or more invoices, though each invoice is associated with a single customer.
Besides the necessary primary and foreign key columns, please be sure that the following attributes are also included in your ER diagram:
Product name; customer name; customer phone number; customer credit limit; date of invoice; information about products being invoiced including product code, quantity sold (i.e., how many units of the product the customer bought), and product price per unit.
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