Question: answer should be handwritten and the ER MODEL should be complete An Information system is to be designed for keeping the records of Universe cup

answer should be handwritten and the ER MODEL should be complete An Information system is to be designed for keeping the records of Universe cup cricket tournament. In all, there are teams from 10 countries participating in the tournament. Each country sends 15 players and 4 other members. For players, the runs he scores and the number of wickets taken (so far) are to be recorded. For the non-players, the role( manager, coach etc.) and the number of years of experience in that capacity are to be recorded. There are matches scheduled amongst the teams on several grounds on fixed dates. Each ground has a fixed seating capacity and a size. For 38 matches, 11 referees have been assigned duties. Every match will have 3 referees working for it. The performance of every player in every match is to be recorded in terms of the runs he scored and the wicket he took. Draw an E-R model of the system.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!