1
* Current balance
o Team they belong to
Database Design Project Solution
Oracle Baseball League Store Database
Project 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_5_4: Relationship Matrix
A relationship matrix shows if and how each row entity on the left side of the matrix is related to each column entity
shown across the top of the matrix.
• If a row entity is related to a column entity, the name of that relationship is shown in the intersection box.
• If a row entity is not related to a column entity, the intersection box is empty.
• Recursive relationships can be represented by placing the name of that relationship on the diagonal.
CUSTOMER
TEAM
SALES
REPRESENTATIVE
ORDER
INVENTORY
LIST
CUSTOMER
TEAM
Left to Right: Each CUSTOMER may ……………. a TEAM
Right to Left: Each TEAM must ………………… by a CUSTOMER