Answered step by step
Verified Expert Solution
Link Copied!

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 CUSTOMER CID CNAME CITY Smith London Jones Paris Clark London Adams Athens 1 (1 2 C2 3 C4 4 C5 RENT CID FID 

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 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Concepts of Database Management

Authors: Philip J. Pratt, Mary Z. Last

8th edition

1285427106, 978-1285427102

More Books

Students also viewed these Databases questions

Question

What is the difference between capital goods and consumer goods?

Answered: 1 week ago

Question

What is denormalization?

Answered: 1 week ago

Question

How do you include a field in an Access query?

Answered: 1 week ago