Question

Gina is a cricket player of their national team. She has played cricket for the domestic team for over
4 years in her teen days now she is ready to join the national team. Gina is a bowler in their team &
her form of bowling is spinning. There are other players in the team who has various form of playing
like batsman, midfielder, wicket keeper etc. Each player has some particular information stored
about her. Like Name, Age, Address(Present & Permanent),Nationality, Type, Contact Number & a
player Id against the team Id to identify them uniquely. Each team has multiple players opposite to
player to team assignment. Each team has their unique name with number of players, Coach Id,
Captain name etc. To join the national team Gina has to fill up a form & submit it to the authority for
further checking & the approval from the authority will arrange a test game & will decide which
players are going to join the national team. Joining players could be one or multiple. In the form a
player needs to fill up some info like Name, Id, form Number, specialization, former team name &
records. The authority has board number, board members & decision(Either approved or
not).Boards are assigned to a unique number. Approval form sent from the authority will have the
player name, player Id & verdict from the authority. Based on the verdict the test game will be
played. The test game will have time & date to identify uniquely & team name(both host & against) &
players to play the game & a result.
Now based on the scenario stated above draw the E_R Diagram. Identify each type of keys with the
other features of E-R.

Answer 1

Answer:

what's the question ❓

I don't understand this question⁉️