Q1: Identify one PK from each table and add the constraints using alter.

[ slide-15.png ] Q1.  Please write SQL codes to create below rental database table based on the previous slide (slide 15) Video E-R Modling Diagram           child table RENTAL   1. checkout_date and dvd_ID coulmns should be combined together as a composite primary key of the rental table, and rest columns are NOT NULL constraints except the checkin_date column (it might hold NULL values). 2. Rental table is a child table, and the member_id column is a foreign key column which references member table’s member_id primary key column. 3. Rental table is a child table, and the dvd_id column is a foreign key column which references dvd table’s dvd_id primary key column.   DESC rental Name Null? Type checkout_date NOT NULL DATE dvd_ID NOT NULL NUMBER(4, 0) member_ID NOT NULL NUMBER(4, 0) checkin_date   DATE expred_date NOT NULL DATE

Please no written by hand and no emage D As Question 3 A correlated nested query O uses tables from both the inner and the outer queries is executed once for every tuple in the outer query table O both 1 and 2 O neither 1 and 2

which constraint ensure the values in a column are all different? a) Foreign Key b) Restrict c) Unique d) Cascade