Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 (from the menu, select File > Save Model As). Upload the mwb file to Homework folder/link Canvas. 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

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

Step: 3

blur-text-image

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

Spatial Databases A Tour

Authors: Shashi Shekhar, Sanjay Chawla

1st Edition

0130174807, 978-0130174802

More Books

Students also viewed these Databases questions

Question

6. Are my sources reliable?

Answered: 1 week ago

Question

5. Are my sources compelling?

Answered: 1 week ago