construct SQL statements . Place SQL statembt below each question

scenario: EliteVidco is a startup company providing concicrge DVD kiosk service in Kennesaw, GA. EliteVideo can own several copies (VIDEO) of each movic (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. DETAIL.RENTAL is the bridge table to resolve this relationship. EliteVideo ER Diagram Part 1: DDL- Creating Tables 1. Write a CREATE TABLE statement for MEMEERSHIP The default value for state is G.A. 2. Write a CREATE TABLE statement for MOVIE. Movie_Cost must be greater than sera. Assume that Movie_Title is required and an aliermate key /must be uniquef-you must use the CONSTRAINT kigwond to do this. 3. Add the construint to Cascade deletions from PRICE to 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 8 - 2b in the elextbook.) 4. Write a CREATE TABLE statement for DETAIL.RENTAL. Detail_DueDate may not be null. 4. Write a CREATE TABLE statement for DETAILRENTAL. Detail_DueDate may not be null. 5. Write 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 saloat statements