1.

Gina is a cricket player of their national team. She has played cricket for the domestic team for over4 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»

ANSWER:

what's the QUESTION

I don't UNDERSTAND this question⁉️



Discussion

No Comment Found