Question: HW 3: Question 2 Create a program that allows you to store the data for players of a game. Create the code in Console Python
HW 3: Question 2 Create a program that allows you to store the data for players of a game. Create the code in Console Python Player Manager COMMAND MENO view - View players add - Add a player del - Delete a playe:r exit - Exit program Command: view Name kins Losses Ties Games 14 20 Joel 10 Command: add Name: anne Wins: 9 Losses: 5 Ties: 3 Anne was added to database Command: view Name ins Losses Ties Games Anne 17 14 20 Joel 10 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. ? CREATE TABLE if not exists Player playerIID name wins losses ties INTEGER TEXT INTEGER INTEGER INTEGER NOT NULL PRIMARY KEY NOT NULL, NOT NULL, NOT NULL NOT NULL 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 play er Note: Games field shown in the view command is the sum of "Wins, Losses, and Ties Games = Wins-Losses +Ties
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
