University of Oklahoma Training Facility Database

1
University of OklahomaTraining Facility Database
Jon Amundson Jon Stephenson Kyle Schmitz
2
Background

• Care Prevention of athletic injuries
• Keep records on athletes
• Injuries and insurance
• Inventory of medical supplies and equipment
• Current System
• manual filing system

3
System Needs

• Will need to track
• Individual athletes past and present injuries
• Treatment given and supplies used
• Insurance information

4
Solutions

• Inventory Tracking
• Order Forms
• Track supplies used
• Inventory Reports
• Player Injury
• Treatment tracking and analysis
• Needed equipment
• Track spending

5
Sample Forms
6
Sample Inventory Report
7
ER Diagram
Assigned
INVENTORY
SUPPLIER
ATHLETE
d
EQUIPMENT
MEDICAL_SUPPLIES
Assigned
TREATMENT_TYPE