Programming Language: Python

Create a program that allows you to store the data for players of a game.

Console

----------------------------------------------------------------------------------------------------------------------------------------------------------

Player Manager

COMMAND MENU

view - View players

add - Add a player

del - Delete a player

exit - Exit program

Commd: view

Name Wins Losses Ties Games

-------------------------------------------------------------------------------------------------------------------------------

Mike 4 3 7 14

Joel 3 7 10 20

Command: add

Name: anne

Wins : 9

Losses: 5

Ties: 3

Anne was added to database

Command: view

Name Wins Losses Ties Games

---------------------------------------------------------------------------------------------------------------------------------------------------

Anne 9 5 3 17

Mike 4 3 7 14

Joel 3 7 10 20

Command: del

Name: anne

Anne was deleted from database.

Command: exit

Bye!

---------------------------------------------------------------------------------------------------------------------------------------------

Specifications

Create a database file (players Data.db) that contains a Player table that stores the data for each player.

Display the players in order by wins, starting with the player with the most wins.

Assume that the name for each player is unique.

Possible enhancement

* Add an "update" command. This command should prompt the user to enter the name of a player. Then, it should let the user update the wins, losses, and ties for the player.