Sporting Goods Business Scenario Overview In this practice you will identify the ER components in a given simple business Scenario. The concepts will be taught in class by using other examples. Whatever task will be performed in class, you will apply on this business scenario. You are supposed to submit the complete ER model right after we complete this topic in class. Business Scenario: Im a manager of a sporting goods wholesale company that operates worldwide to fill orders of retail sporting goods stores. The stores are our customers (some of our people prefer to call them our clients). Right now we have fifteen customers worldwide, but were trying to expand our customer base by about 10% each year starting this year. Our two biggest customers are in the United States: Big Johns Sports Emporium in San Francisco, California, and Womens Sports in Seattle, Washington. For each customer, we must track an ID and a name. We may also track an address (including the city, state, zip code, and country) and a phone number. We maintain warehouses in different regions to fill our customer orders. For each order, we must track an ID. We may also track the date ordered, date shipped, and payment type if the information is available. Our order entry personnel are well versed in our product line. We hold frequent meetings with Marketing to learn about new products. The result is better customer satisfaction because we can answer customer questions. We deal with a few select customers and maintain a specialty product line. For each product, we must know the ID and name. Occasionally we must also know the description, suggested price, and unit of sale. When necessary we also want to be able to track very long descriptions of our products and pictures of our products. Tasks: 1. Identify Entities 2. Identify Attributes 3. Identify Relationship 4. Draw a complete ER diagram 5. Map ER into Relational ModelSporting Goods Business Scenario Overview In this practice you will identify the ER components in a given simple business Scenario. The concepts will be taught in class by using other examples. Whatever task will be performed in class, you will apply on this business scenario. You are supposed to submit the complete ER model right after we complete this topic in class. Business Scenario: I’m a manager of a sporting goods wholesale company that operates worldwide to fill orders of retail sporting goods stores. The stores are our customers (some of our people prefer to call them our clients). Right now we have fifteen customers worldwide, but we’re trying to expand our customer base by about 10% each year starting this year. Our two biggest customers are in the United States: Big John’s Sports Emporium in San Francisco, California, and Women’s Sports in Seattle, Washington. For each customer, we must track an ID and a name. We may also track an address (including the city, state, zip code, and country) and a phone number. We maintain warehouses in different regions to fill our customer orders. For each order, we must track an ID. We may also track the date ordered, date shipped, and payment type if the information is available. Our order entry personnel are well versed in our product line. We hold frequent meetings with Marketing to learn about new products. The result is better customer satisfaction because we can answer customer questions. We deal with a few select customers and maintain a specialty product line. For each product, we must know the ID and name. Occasionally we must also know the description, suggested price, and unit of sale. When necessary we also want to be able to track very long descriptions of our products and pictures of our products. Tasks: 1. Identify Entities 2. Identify Attributes 3. Identify Relationship 4. Draw a complete ER diagram 5. Map ER into Relational Model Show transcribed image text Sporting Goods Business Scenario Overview In this practice you will identify the ER components in a given simple business Scenario. The concepts will be taught in class by using other examples. Whatever task will be performed in class, you will apply on this business scenario. You are supposed to submit the complete ER model right after we complete this topic in class. Business Scenario: I’m a manager of a sporting goods wholesale company that operates worldwide to fill orders of retail sporting goods stores. The stores are our customers (some of our people prefer to call them our clients). Right now we have fifteen customers worldwide, but we’re trying to expand our customer base by about 10% each year starting this year. Our two biggest customers are in the United States: Big John’s Sports Emporium in San Francisco, California, and Women’s Sports in Seattle, Washington. For each customer, we must track an ID and a name. We may also track an address (including the city, state, zip code, and country) and a phone number. We maintain warehouses in different regions to fill our customer orders. For each order, we must track an ID. We may also track the date ordered, date shipped, and payment type if the information is available. Our order entry personnel are well versed in our product line. We hold frequent meetings with Marketing to learn about new products. The result is better customer satisfaction because we can answer customer questions. We deal with a few select customers and maintain a specialty product line. For each product, we must know the ID and name. Occasionally we must also know the description, suggested price, and unit of sale. When necessary we also want to be able to track very long descriptions of our products and pictures of our products. Tasks: 1. Identify Entities 2. Identify Attributes 3. Identify Relationship 4. Draw a complete ER diagram 5. Map ER into Relational Model