Question
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
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started