title | subtitle | author | |||
---|---|---|---|---|---|
Data and Applications | Project Phase - 4 |
Team-40 'Life is a Schema' |
|
Dump.sql
contains all tables created and filled with data.
Main code is in cli.py
file.
Run using
$ python3 cli.py
Video can be found at https://drive.google.com/file/d/1f9o37Bsv3ASMqa3l4g9UcGOvblkc4dYE/view?usp=sharing
Instead of Eleven Players (PlayingEleven) for each team, we have taken 5 players for each Team (for demonstration purpose).
To insert Stadium into the database.
To update a Stadium's ID in the database.
To update the capacity of a particular Stadium.
Gets PlayerID and PlayerName of Goal Scorers among the Players.
Get average goals (sum of scores (from result table) for all matches divided by the number of matches).
Retrieves Team information for given TeamID.
Inserts Team into database (Assigns five(eleven) players to the team which are not associated with any other team). Similarly alots a manager and stadium to this team which are not associated with any other team.
To insert Match between two teams.
To remove Match for given MatchID.
Removes Team for given TeamID. Sets TeamID to NULL for the players associated with this team.
Gets Player information about the given PlayerID.
Displays the PlayingEleven members for the given TeamID.
Update Jersey Name for given Player (PlayerID).
Update Jersey Number for given Player (PlayerID).
Inserts Manager into the database.
Deletes Manager from the database. Will allot a new Manager to the team if this Manager is mapped to some team.