Database Project
As an analyst for What's AMatta U you are instructed to create a system that allows the coached to track the attendance of their athletes. This system should allow the coaches to see who has missed class during any given date. The information displayed should take the following form:
Sport: bbbbbbbbbbbbbbbbb
Coach: bbbbbbbbbbbbbbbbb
Student Id Name Class Id Description Date Time Instructor
999999999 bbbbbbbbbbbbbbb bb999 bbbbbbbbbbbbbbb 99/99/9999 99:99 bbbbbbbbbbbbbbb
The coaches should also be able to access information regarding the student that is missing the class:
Student Id Name Address Phone Advisor
999999999 bbbbbbbbbbbbbbb bbbbbbbbbbbbbbb (999)999-9999 bbbbbbbbbbbbbbb
The following information regarding the class instructor and advisor should also be available:
Name Office Phone
bbbbbbbbbbbbbb bb999 (999)999-9999
Step 1:
Complete a problem analysis that describes the problem being address, and the benefit this system will have for the coaches and administration of the college. When you make a claim in the opening section be sure to follow up or prove it in the body of the paper.
Step 2:
Design and normalize the tables creating models, displaying any relationships that exist between the different data elements.