Homework Help is Here – Start Your Trial Now!
Engineering
Data Structures and Algorithms
1. Create three tables a. Customer b. Rent c. Film 2. Define appropriate data type and data size 3. Define column constraints 4. Specify Integrity/Domain/Primary Key/Referential Integrity constraints a. Primary key b. Foreign key E.g.) CONSTRAINT rent_fk_c FOREIGN KEY cid REFERENCES customer ON DELETE CASCADE The price of a film ranges from 0 F0 to 10.00

1. Create three tables a. Customer b. Rent c. Film 2. Define appropriate data type and data size 3. Define column constraints 4. Specify Integrity/Domain/Primary Key/Referential Integrity constraints a. Primary key b. Foreign key E.g.) CONSTRAINT rent_fk_c FOREIGN KEY cid REFERENCES customer ON DELETE CASCADE The price of a film ranges from 0 F0 to 10.00

icon
Related questions
Question
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
Transcribed Image Text: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
CUSTOMER CID CNAME CITY Smith London Jones Paris Clark London Adams Athens 1. 1 C1 2 C2 3 C4 4 C5 RENT RDATE 1 C5 F2 02-OCT-14 2 C5 F3 04-SEP-14 3 C5 F5 16-APR-17 4 C1 F5 16-APR-17 5 C1 F2 02-OCT-14 6 C1 F3 04-SEP-14 7 C2 F2 01-APR-14 8 C4 F2 01-JAN-14 CID FID Create three tables a. Customer b. Rent c. Film 2. Define appropriate data type and data size 3. Define column constraints 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 5 ACTION 5 COMEDY 4. Specify Integrity/Domain/Primary Key/Referential Integrity constraints a. Primary key b. Foreign key E.g.) 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
Transcribed Image Text:CUSTOMER CID CNAME CITY Smith London Jones Paris Clark London Adams Athens 1. 1 C1 2 C2 3 C4 4 C5 RENT RDATE 1 C5 F2 02-OCT-14 2 C5 F3 04-SEP-14 3 C5 F5 16-APR-17 4 C1 F5 16-APR-17 5 C1 F2 02-OCT-14 6 C1 F3 04-SEP-14 7 C2 F2 01-APR-14 8 C4 F2 01-JAN-14 CID FID Create three tables a. Customer b. Rent c. Film 2. Define appropriate data type and data size 3. Define column constraints 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 5 ACTION 5 COMEDY 4. Specify Integrity/Domain/Primary Key/Referential Integrity constraints a. Primary key b. Foreign key E.g.) 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
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer