Create a Fantasy Cricket game in Python. The game should have all the features displayed in

the mock$-$up screens in the scenario. To calculate the points for each player, you can use

rules similar to the sample rules displayed below.

Sample of Rules

Batting

$1$ point for $2$ runs scored

$$ Additional $5$ points for half century

$$ Additional $10$ points for century

$2$ points for strike rate $($runs$/$balls faced$)$ of $80-100$

$$ Additional $4$ points for strike rate$>100$

$1$ point for hitting a boundary $($four$)$ and $2$ points for over boundary $($six$)$

Bowling

$10$ points for each wicket

$$ Additional $5$ points for three wickets per innings

$$ Additional $10$ points for $5$ wickets or more in innings

$4$ points for economy rate $($runs given per over$)$ between $3\mathrm{.}5$ and $4\mathrm{.}5$

$7$ points for economy rate between $2$ and $3\mathrm{.}5$

$10$ points for economy rate less than $2$

Fielding

$10$ points each for catch$/$stumping$/$run out

Database Design

For the database, you are required to use three tables $$ match, stats and teams.

match

Player Scored Faced Fours Sixes Bowle

d

Maide

n

Given Wkts Catche

s

Stumpin

g

RO$*$

$*$Run Out

teams

name players value

Programming with Python

Final Project

stats

player matches runs $100$s $50$s value ctg

Note: The teams table will be populated after score calculation. The data to enter in the remaining

two tables is given below:

Hint: If you are wondering where to start and how to plan your work, here are some

suggestions.

i$.$ First, create the database of players. Plan the required tables and add data to your

database.

ii$.$ Next, create the GUI. Generate the required Python code for the UI$.$

iii. Finally, populate the Python code generated in step ii with more attributes and method

definitions $($action listeners$).$