Oracle Baseball League Store Database
Entities and Attributes
Scenario:
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.
DFo_2_3_1_Project: Identifying Entities
Using text analysis on the given scenario identify any potential entities that will have to be represented in a
relational database system. Entities are usually the nouns in the scenario description however not every noun
becomes an entity so think carefully but remember you are identifying potential entities not creating a definitive
list.
