Make sure to undo any changes you may have made

Assignment Help Database Management System

Reference no: EM131912603

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;

Reference no: EM131912603

Questions Cloud

The ratio of the firm book value to market value : Fama and French claim that after controlling for firm size and the ratio of the firm's book value to market value, beta

Write a program that upon a mouse click moves the turtle : Write a program that upon a mouse click moves the turtle to a randomly chosen position with coordinates between -300 and +300 and stamps the current shape.

Ph at the equivalence point in the titration : What is the pH at the equivalence point in the titration of a 18.7 mL sample of a 0.478 M aqueous acetic acid solution with a 0.370 M aqueous barium hydroxide

What is janet income tax liability : Janet, who is 22 years of age, is single and lives with her parents, who are in the 35% tax bracket. What is Janet income tax liability

Make sure to undo any changes you may have made : Use the original Tennis database. Make sure to undo any changes you may have made. Under Preferences -> SQL Editor you may need to disable ‘Safe Update' mode.

Define business cycles : Define business cycles and Identify the FOUR phases in the diagram above by means of their numbers excluding the turning points

What is expected return for each of these investment options : what is the expected return for each of these investment options (you will need to calculate the betas for the mutual fund and First Global)?

How e-technologies have changed modern social life : How e-technologies have changed modern social life and how suppliers of such technologies have sought to overcome the threats and risks associated?

What is the income from discontinued operations : Ignoring taxes, what is the income (loss) from discontinued operations and what is the gain (loss) from discontinued operations

User Account

All Pages