Question

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 Woman sports 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 order 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.”

Answer 1

Based on the given scenario, the entities are:

• Manager
• Staff
• Customer
• OrderWarehouse

Key points:
The stores are our customers. So that we are considering customer as entity.
The company maintaining warehouses in different regions to best fill the orders.
Each customer may give several orders. (Customer: Order - 1:N)
Each warehouse contains more than one staff. (Warehouse: Staff - 1:N)
Each warehouse contains one manager. (Warehouse: Manager - 1:1)
More than one staff workes under a manager. (Manager: Staff - 1:N)

The ERD is as follows: