Create three tables a. Customer b. Rent C. Film . Define appropriate data type and data...

  

Transcribed Image Text:

Create three tables a. Customer b. Rent C. Film . Define appropriate data type and data size Define column constraints Specify Integrity/Domain/Primary Key/Referential Integrity constraints a. Primary key b. Foreign key CONSTRAINT rent fk c FOREIGN KEY cid REFERENCES customer ON DELETE CASCADE; c. The price of a film ranges from 0.50 to 19.99 d. A film can only have the type of Action, Horror, Comedy, Drama, and Education CUSTOMER CID CNAME CITY Smith London Jones Paris Clark London Adams Athens 1 (1 2 C2 3 C4 4 C5 RENT CID FID RDATE 1 (5 2 (5 3 (5 4 (1 5 (1 6 (1 7 (2 8 (4 F2 F3 F5 F5 F2 F3 F2 F2 02-OCT-14 04-SEP-14 16-APR-17 16-APR-17 02-OCT-14 04-SEP-14 01-APR-14 01-JAN-14 FILM FID 1 F2 2 F3 3 F4 4 F5 5 F7 FNAME The Others Senseless Dragon Heart 007 Sweetheart PRICE TYPE 1.44 HORROR 5.99 COMEDY 6 DRAMA SACTION 5 COMEDY Create three tables a. Customer b. Rent C. Film . Define appropriate data type and data size Define column constraints Specify Integrity/Domain/Primary Key/Referential Integrity constraints a. Primary key b. Foreign key CONSTRAINT rent fk c FOREIGN KEY cid REFERENCES customer ON DELETE CASCADE; c. The price of a film ranges from 0.50 to 19.99 d. A film can only have the type of Action, Horror, Comedy, Drama, and Education CUSTOMER CID CNAME CITY Smith London Jones Paris Clark London Adams Athens 1 (1 2 C2 3 C4 4 C5 RENT CID FID RDATE 1 (5 2 (5 3 (5 4 (1 5 (1 6 (1 7 (2 8 (4 F2 F3 F5 F5 F2 F3 F2 F2 02-OCT-14 04-SEP-14 16-APR-17 16-APR-17 02-OCT-14 04-SEP-14 01-APR-14 01-JAN-14 FILM FID 1 F2 2 F3 3 F4 4 F5 5 F7 FNAME The Others Senseless Dragon Heart 007 Sweetheart PRICE TYPE 1.44 HORROR 5.99 COMEDY 6 DRAMA SACTION 5 COMEDY

Answer rating: 100% (QA)

It looks like the task here is to create three tables for a database specifically for a rental system with tables named Customer Rent and Film Also it ... View the full answer