Question: Try It / Solve It Create an ERD based on the following Summit Sporting Goods scenario. Be sure to follow drawing conventions for readability and

Try It / Solve It
Create an ERD based on the following Summit Sporting Goods scenario. Be sure to
follow drawing conventions for readability and clarity.
"I'm a manager of a sporting-goods wholesale company that operates worldwide to fill orders
from retail sporting-goods stores. The stores are our customers (some of our people prefer to
call them our clients). Right now we have 15 customers worldwide, but we're trying to
expand our customer base by about 10% each year starting this year. Our two biggest
customers are Big John's Sports Emporium in San Francisco and Womansports in Seattle.
For each customer, we must track an ID and a name.
We may track an address (including the city, state, zip code, and country) and phone number.
We maintain warehouses in different regions to best fill the orders of our customers. For each
order, we must track an ID. We may track the date ordered, date shipped, and payment type
when the information is available."
 Try It / Solve It Create an ERD based on the

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!