You are a small consulting company specializing in database development. You have just been awarded the contract to develop a data model for a database application system for a small retail store called Oracle Baseball League (OBL). The Oracle Baseball League store serves the entire surrounding community selling baseball kit. The OBL has two types of customer, there are individuals who purchase items like balls, cleats, gloves, shirts, screen printed t-shirts, and shorts. Additionally customers can represent a team when they purchase uniforms and equipment on behalf of the team. Teams and individual customers are free to purchase any item from the inventory list, but teams get a discount on the list price depending on the number of players. When a customer places an order we record the order items for that order in our database. OBL has a team of three sales representatives that officially only call on teams but have been known to handle individual customer complaints.

Section 1 Lesson 4 Exercise : Business Requirements: Using the text provided in the scenario above identify the business requirements that will allow you to understand the business processes involved in running this type of organization. Use the following categories to help you with this: Business rule: It is used to understand business processes and the nature, role, and scope of the data. Assumption: It can be defined as a fact or a statement that has been taken for granted. Problem: It can be defined as a situation or scenario that requires attention and a possible solution to alleviate the situation. Build a list of business needs, rules and assumptions based on your scenario, research, and objectives. (Answers may vary)