Write 2 to 3 pages Description of IPL\'s Database. A) Description of the databas
ID: 3710835 • Letter: W
Question
Write 2 to 3 pages Description of IPL's Database.
A) Description of the database application on INDIAN PREMIER LEAGUE (IPL). Your description should be brief and relatively informal (TWO to THREE Pages). Write how the process works inside and if there are any unique or particularly difficult aspects of your proposed application, please point them out.
Descriotion must include:
- What is the purpose of the database?
-What type of reports will be generated?
- What information you want to store for each team, player, coach, franchise, sponsors, games etc
- Who is going to use this information (end users) e.g organizers , franchise owner , headcoach etc?
Feel free to add any additional information
Your description should not include any technical term like entities , attributes etc.
(b) An entity-relationship diagram using Chen's model for your proposed database. Clearly describe any assumptions that you are making.
Explanation / Answer
ANS:-
Given that,
The database application on INDIAN PREMIER LEAGUE (IPL).
IPL - Indian Professional Twenty20 (T20) Cricket League, established in the Indian Premier League (IPL) 2008 The league, which is based on the Round Robin Group and Petek format, has a team of major Indian cities.
The brainchild of Indian Cricket Control Board (BCCI), has become the most attractive and most popular outlet for IPL cricket's game. Matches typically start late in the afternoon or evening so that some of them are played in the floodlights at night to maximize the television audience to broadcast worldwide. Initially, all teams of league matches were played on home and away basis, but with the planned expansion of 10 clubs (divided into two out of five groups) in 2011, this format has changed so that some teams The matches between the two will be limited, the top four teams participate in three play-off matches for a single encounter, in which a losing team is being given a second chance to reach the final, which is likely to be Livijhn a wrinkle to maximize revenue. The play-off part of the tournament consists of four teams, which ended at the top of the table in a series of knockout games that a team loses their second chance to reach their first round game in the final match.
The eight prestigious franchises Mumbai Indians, Chennai Super Kings, Royal Challengers Bangalore, Deccan Chargers (located in Hyderabad), Delhi Daredevils, Punjab XI Kings (Mohali), Kolkata Knight Riders and Rajasthan Royals (Jaipur). In the end of 2010, two franchises, Rajasthan and Punjab were expelled from the league for the bungalow owned by the BCCI, but later they were restored on time for the 2011 tournament. Two new franchises, Pune Warriors India and Kochi Tuskers Kerala participated in the IPL for the 2011 tournament. The Kochi Club had terminated the contract of BCCI just a year ago. In 2013, Deccan Chargers were given place in the IPL by Sunrisers Hyderabad.
The tournament was organized in 44 days before the 44 days, Rajasthan Royals, one of the small franchises, which was the captaincy of Shane Warne, the great Australian bowler won. In view of the success of the IPL, other cricket nations have tried to raise some funds by making their domestic T20 league.
IPL database should contain all the previous winners of IPL:
Database should have information:
How many players being auctioned:
a total of 578 players will be prepared for sale, out of which 244 have been captured, 332 are unexpected and two players from allied countries. Of them, 62 are Indian captains and 34 are foreigners.
How the auction works:
The auction will be included in the Marquee list, in which the top players are included. They are divided into two batches of eight. In the first batch, R Ashwin, Chris Gayle, Kieron Pollard, Mitchell Starc and Ben Stokes are included, while the other list includes Dwayne Bravo, Shakib Al Hasan, Glenn Maxwell, Joe Root, Yuvraj Singh and Kane Wilmington. Will be.
How much each franchise spent:
Each franchise can spend a maximum of 80 crores on its salary. Apart from this, they have to spend 75% salary cap, which is equivalent to 60 crore rupees.
Money spend with each franchise :
Rajasthan Royals, Kings XI Punjab - Rs 67 crore.
Sunrisers Hyderabad , Kolkata Knight Riders – Rs 59 crore
Royal Challengers Bangalore - Rs 49 crore
Chennai Super Kings, Delhi Daredevils and Mumbai Indians – Rs 47 crore
Right To match Cards and how many do the franchises have ?
With an RTM card, a franchisee can catch an old player in collaboration with the highest bidder. CSK, Daredevils, Mumbai Indians and RCB have two RTM cards, while the remaining three RTSs are remaining. However, there are other rules that control the use of RTM cards and for example CSK and MI can not get Ashwin and Harbhajan Singh, Indian invasions, because they have increased their borders. Similarly, KKR can not use its rtm to be a capped foreign player, such as Chris Walk and Shakib Al Hasan.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.