1. Create three tables

   1. Customer

   2. Rent

   3. Film

2. Define appropriate data type and data size

3. Define column constraints

4. Specify Integrity/Domain/Primary Key/Referential Integrity constraints

   1. Primary key

   2. Foreign key

CONSTRAINT rent_fk_c FOREIGN KEY cid REFERENCES customer ON DELETE CASCADE;

3. The price of a film ranges from 0.50 to 19.99

4. A film can only have the type of Action, Horror, Comedy, Drama, and Education

For the submission

1. Include your table creation SQL statements - You can copy and paste your code here.

2. Include the screenshots - Take a screenshot of your tables in your DB

Given tables below, you will create tables. CUSTOMER RENT CID CNAME CITY CID FID RDATE 1 C1 Smith London 1 C5 F202-OCT-14 2 C2 Jones Paris 2 C5 F304-SEP-14 3 C4 Clark London 3 C5 F5 16-APR-17 4 C5 Adams Athens 4 01 F5 16-APR-17 5 01 F2 02-OCT-14 6 01 F304-SEP-14 7 02 F2 01-APR-14 8 C4 F2 01-JAN-14 FILM FID FNAME 1 F2 The Others 2 F3 Senseless 3 F4 Dragon Heart 4 F5007 5 F7 Sweetheart PRICE TYPE 1.44 HORROR 5.99 COMEDY 6 DRAMA 5 ACTION 5 COMEDY 4