Question: Design a database through the EER diagram to keep track of the teams and games of a sport league. You can submit a computer drawn

 Design a database through the EER diagram to keep track of

Design a database through the EER diagram to keep track of the teams and games of a sport league. You can submit a computer drawn EER diagram or hand-draws the diagram, take a picture by phone and submit the file. Assume that the following requirements are collected (the English description of cardinal ration and partial/complete participate is NOT required, but you still need to provide the total partial and cardino ration in your EER diagram): The database has a collection of TEAM. Each Team has a unique name, players, and owner. The database also keeps the records of PLAYERS. Each player has the attributes of SSN, player_name, and team to indicate which team they belong to PLAYERS are SPECIALIZED into other MAJOR LEAGUE O MINOR LEAGUE. Information captured about objects in the MAJOR LEAGUE includes Salary: Information captured about objects in the MINOR LEAGUE indudes level (such as 1 2 OF 3A) GAME stores the attributes of the following a unique game number, date time, filed and MAJOR LEAGUE players who participate the game. It is categorized into HOME and GUEST Home stores the TEAM which plays in the home game and GUEST stores the team which plays as the guest TEAM. Information captured about objects in the HOME includes ticket income, GAME also stores a calculated attribute called total player partic pate

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!