Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
★★★★★
3.42 Rating (161 Votes )
There are 3 Steps involved in it
Step: 1
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 ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started