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, or 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_participate