Question: construct SQL statement for each. only part 2 needed please scenario: EliteVideo is a startup company providing concierge DVD kiosk service in Kennesaw, GA. EliteVideo

scenario: EliteVideo is a startup company providing concierge DVD kiosk service in Kennesaw, GA. EliteVideo can own several copies (VIDEO) of each movie (MOVIE). For example, a kiosk may have 10 copies of the movie Twist in the Wind. In the database, Twist in the Wind would be one MOVIE, and each copy would be a VIDEO. A rental transaction (RENTAL) involves one or more videos being rented to a member (MEMBERSHIP). A video can be rented many times over its lifetime; therefore, there is an M:N relationship between RENTAL and VIDEO. DETAILRENTAL is the bridge table to resolve this relationship. 3. Add the constraint to Cascade drletions from PRICE to MOVIE. WNote Oracle does not support this function - if you 3. Add the constraint to Cascade deletions from PRICE to MOVIE. WNote Oracle does not support this function - if you need help here, see section 82b in the etextbook.] 4. Write a CREATE TABLE statement for DETAILRENTAL. Detall_DueDate may not be null. 5. Hrite a CREATE TABLE statement for RENTAL. 6. Write a CREATE TABLE statement for VIDEO. 7. Write a CREATE TABLE statement for PRICE. Price_RentFee may not be null. Keep your code - we will use it next week to implement these tables for use with SQL selecf statements. Part 2: DDL- Altering Tables 8. Write an ALTER statement to add the column Phone to MEMBERSHIP. 9. Write an ALTER statement to remove the column Phone from MEMBERSHIP. 10. Write an ALTER statement to add the column Price_Rentdays to PRICE. Price_Rentdays is an integer. This attribute should not accept null values and has a default value of 3. 11. Write an ALTER statement to change the date datarype for the Detail_ReturnDate in the DETAILRENTAL table to include a time component. 12. Write an ALTER statement to drop the constraint from question 2 that Mowie.Title be unique in MOVIE
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
