- 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.Execute the following changes to the database. Save the command you created. HINT: Many of these changes can be done through MySQLWorkbench by clicking on the wrench symbol in the schema window for the table. MySQLWorkbench will then display the SQL code it generates for the changes you have selected using the table editor.
- Add a new column called Date of type date to the MATCHES table.
- Add a new column called Paid of type char (1) to the PENALTIES table.
- Add a new column called Founded of type date to the TEAMS table after the TEAMNO.
- In the PENALTIES table, change the column name AMOUNT to PENALTY_AMOUNT.
- In the MATCHES table, change the column name MATCHNO to MATCH. MATCH is a keyword but this can be done.
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 TEAMS;
- Each change is worth 20% of the homework grade.
YourLastName_hw5.txt