QUESTION 4 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 either MAJOR LEAGUE or MINOR LEAGUE. Information captured about objects in the MAJOR LEAGUE includes salary: Information captured about objects in the MINOR LEAGUE includes level (such as 1A, 2A, 3A) GAME stores the attributes of the following a unique game number, date, time, hled 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 participate