- Use the original Tennis database. Make sure to undo any changes you may have made.
- This will change the database so use ReplaceAndPopulateTennisTables.txt to restore the database to its original content.
- Under Preferences -> SQL Editor you may need to disable ‘Safe Update’ mode.
- Execute the following changes to the database. Save the command you created.
- Add a new penalty to the PENALTIES table; the payment number is 11, this concerns player 44, the payment date was 1985-11-08, and the penalty amount is $100.
- Double the amount of all penalties.
- Delete the two lowest penalties.
- Delete all players who live in the same town as player 57 but keep the data about player 57 (you may need to alias the sub-query (example 17.15) on the town name for 57).
- Delete all penalties and matches of player 104, regardless of whether the player appears in both tables.
- Submit the following queries as a file using the below name or paste as a text submission. Make sure to include the commands you created.
- SELECT * FROM PENALTIES;
- SELECT * FROM MATCHES;
- SELECT * FROM PLAYERS;
- Each update is worth 20% of the homework grade.
YourLastName_hw4.txt