ISM 4212 Database Administration - Youth Soccer League Database Geniuses (DBG) - GRADED A+

Youth Soccer League Database Geniuses (DBG) Bringing Technology to you! Table of Contents Table of Contents.........................................................................................................................................2 Purpose.......................................................................................................................................................4 Narrative......................................................................................................................................................4 Actors and Roles..........................................................................................................................................6 Team........................................................................................................................................................6 Player.......................................................................................................................................................6 Coach.......................................................................................................................................................6 Match......................................................................................................................................................6 Field.........................................................................................................................................................6 Vendor.....................................................................................................................................................7 Referee....................................................................................................................................................7 Sponsor....................................................................................................................................................7 Entities.........................................................................................................................................................8 Team........................................................................................................................................................8 Player.......................................................................................................................................................8 Coach.......................................................................................................................................................8 Match......................................................................................................................................................8 Field.........................................................................................................................................................8 Vendor.....................................................................................................................................................8 Referee....................................................................................................................................................8 Sponsor....................................................................................................................................................8 Entities with nested Attributes....................................................................................................................9 TEAM.......................................................................................................................................................9 PLAYER.....................................................................................................................................................9 COACH.....................................................................................................................................................9 MATCH.....................................................................................................................................................9 FIELD........................................................................................................................................................9 VENDOR.................................................................................................................................................10 REFEREE.................................................................................................................................................10 SPONSOR...............................................................................................................................................10 ERD............................................................................................................................................................11 EERD..........................................................................................................................................................12 Relational Schema.....................................................................................................................................13 pg. 2 pg. 3 Purpose The soccer league consists of many teams and associated players. There are coaches assigned to each team. The matches are held at different fields. Matches are assigned with referees. Sponsors give sponsorship to teams. Fields are supported by sponsors by placing banners and have vendors, who sell different items. The soccer league administrator wants to track all the above entities and their relationships with the help of a database. For the database desig