Assignment

1. Use the original Tennis database. Make sure to undo any changes you may have made.

2. This will change the database so use ReplaceAndPopulateTennisTables.txt to restore the database to its original content.

3. Under Preferences -> SQL Editor you may need to disable ‘Safe Update' mode.

4. Execute the following changes to the database. Save the command you created.

i. 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.

ii. Double the amount of all penalties.

iii. Delete the two lowest penalties.

iv. 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).

v. Delete all penalties and matches of player 104, regardless of whether the player appears in both tables.

5. 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 from #4.

1. SELECT * FROM PENALTIES;
2. SELECT * FROM MATCHES;
3. SELECT * FROM PLAYERS;