Question: Lab04 Given tables below, you will create tables. CUSTOMER RENT FILM Create three tables Customer Rent Film Define appropriate data type and data size Define

Lab04

Given tables below, you will create tables.

CUSTOMER

RENT

FILM

  1. Create three tables

    1. Customer

    2. Rent

    3. Film

  2. Define appropriate data type and data size

  3. Define column constraints

  1. 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;

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

  2. 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

Lab04 Given tables below, you will create tables. CUSTOMER RENT FILM Create three tables Customer Rent Film Define appropriate data type and data size Define column constraints Specify...

Q:

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....

Q:

Create three tables Customer Rent Film Define appropriate data type and data size Define column constraints Specify Integrity/Domain/Primary Key/Referential Integrity constraints Primary key Foreign...

Q:

Database Management 1.Open Access and create a database called, "Movie Favorites." Create the Film Favorites table in Design view using the structure shown below: Structure of Film Favorites table...

Q:

You are to design, develop and implement a database for The Aquatics Swim Club based on the concepts you have learned in CIT 170. All documents must be produced on a computer. You should carefully...

Q:

CIT 170 Database Project After reading through this entire document, please watch the video on Project Design Hints. The video has additional information to assist you with your design phase. You are...

Q:

Can someone please help/advice/any idea my term project! The term project for this course will be to design and construct a database that uses appropriate Transact SQL procedures and functions. The...

Q:

I would like assist for my assessment. The subject is Subsidiary Accounts and Ledgers and Foundation Skills. T-1.8.1 Details of Assessment Term and Year 1, 2017 Time allowed Week 2-7 Assessment No 1...

Q:

Requirements 1. Using Access or a similar relational database, create the tables needed to set up a database for contributors, contributions, and animals. 2. What data field did you use for the...

Q:

Please I need help with the Part 3 and 4 Questions of this exercise. Thank you. Exercise: Hotel Schema Overview Hotel Software Guild is a resort hotel on the West Arm of Lake Minnetonka. It is a...

Q:

There is an excess demand in a market for a product when rev: 05_07_2018 Multiple Choice quantity demanded is greater than quantity supplied. the current price is higher than the equilibrium price....

Q:

Hamilton Metal Fabricators, Inc., has a large job, No. 2734, that calls for producing various ore bins, chutes, and metal boxes for enlarging a copper concentrator. The following charges were made to...

Q:

Topic 2 : Chapters 2 Topic 2 : Chapters 2 Topic 2 : Chapters 2 Topic 2 : Chapters 2 6 What are Roxie's Bed & Breakfast's earnings per share? Note: Round your answer to 2 decimal places. 1 points...

Q:

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...