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

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

Data Access Patterns Database Interactions In Object Oriented Applications

Authors: Clifton Nock

1st Edition

0321555627, 978-0321555625

More Books

Students also viewed these Databases questions