SCHEMA:
Posted: Fri May 20, 2022 12:32 pm
SCHEMA:
Artist (ssn, name, age, rating) Theater (tno, tname, address) Perform (ssn, tno, date, duration, price)
Question 3 (5 points): Consider the schema in Question 2. Assume the date has the format of MM/DD/YYYY. 1. Write an update SQL statement to increase the prices of all the performances today by 10% 2. Write a delete SQL statement to delete all the performances today.
- Schema 1 (3.99 KiB) Viewed 26 times
- Schema 2 (9.33 KiB) Viewed 26 times
Question 3 (5 points): Consider the schema in Question 2. Assume the date has the format of MM/DD/YYYY. 1. Write an update SQL statement to increase the prices of all the performances today by 10% 2. Write a delete SQL statement to delete all the performances today.