Question

Design a database through the EER diagram to keep track of the teams and games of a sport league. 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.   

Answer 1

Let's first understand the concept of the EER diagram in the Database Management System:

• EER stands for Enhanced Entity Relationship which is a enhanced version of ER model in database management systems.
• Basically ER models are used to define the relation between the entities and also represents the how the data should be organized in the database.
• For designing high level database models, Enhanced Entity Relationship models are preferred instead of ER models to give the good understanding about the system.
• EER diagram provides us with all the elements of ER diagram with added attribute inheritance, relationship inheritance, union types, subclasses, super classes, generalization and specialization etc.,
• Generally, when dealing with complex systems having more data, we should go with EER (enhanced entity relationship) model instead of ER model so that complex systems can be understood easily.

Now we will look into the EER diagram for the given statement:

Explanation for above diagram:

• A team can have attributes like name(unique), owner and number_of_players.
• team has player that is indicated with has relationship and player can have SSN, name and team he belongs too.
• A player can play for either Major league or Minor league, so that it is categorized into 2 entities and each entity has their own attributes like salary, 1A, 2A and 3A.
• Team will be participating in game and game contains various attributes like number, date, time, filed, team_player_participated.
• Game contains Major_league players who may be from home or came from other place(guest player) and they can have their own attributes.
• Player is connected with game using play relationship that we can observe in the above diagram.

PLEASE GIVE A THUMBS UP, IF THIS ANSWER IS HELPFUL

THANK YOU!