Question: (a) Create the table Rental with the above specication. Set Rental _pk and Rental_fkl as constraint names of the primary key and foreign key respectively.

(a) Create the table Rental with the above specication. Set Rental _pk and Rental_fkl as constraint names of the primary key and foreign key respectively. [10 marks] (b) In the table Rental, add a foreign key constraint named Rental_l'l{2 for the column LicenseNo which refers to Vehicle table. [4 marks] (c) In the table Rental, set a constraint named Rental_cc for the column NumDay to ensure the number of days rented must be in the range from 1 to 30 days, inclusive. [4 marks] (d) Create an index named Customerjdx on the column Mobile of the table Customer. [3 marks] (e) Add a new record into the Rental table as shown below. [3 marks] VD872 12 November 2020 (f) Write [W0 SQL statements in correct order to complete the following tasks: The customer with customer ID evalee has been blacklisted. Remove the customer together with all her rentals from the database. [6 marks]

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 Mathematics Questions!

create database AutoRentals go use AutoRentals go create table Customer (CID integer, CName varchar(20), Age integer, Resid_City varchar(20), BirthPlace varchar(20), Constraint PK_Customer Primary...

-- ************************************************************* -- This script creates the database -- for Labs 4-7 based on OM (Order Management) database -- **REVISED by PRP to remove some orders...

For this project, you are going to create the Intercollegiate Athletic Database. More specifically you will have to create the tables described in the Background file and populate the tables with the...

) Create the SQL statements for displaying the results for each of the following scenarios in the Academic Database. Save these statements in a script called M06_LastNameFirstName_ Queries (where...

Please Answer All The Questions Including the Bonus! USE [master] GO /****** Object: Database [AutoDealer3] Script Date: 2/21/2014 8:58:21 AM ******/ CREATE DATABASE [AutoDealer3] GO USE...

Task 1 (1) Create a logical backup of relational table APPLICANT. Save a logical backup in a file with the same name as a prefix of your University email account.bak. (2) Execute a script...

DROP TABLE IF EXISTS customers; DROP TABLE IF EXISTS orders; DROP TABLE IF EXISTS order_details; DROP TABLE IF EXISTS items; DROP TABLE IF EXISTS artists; DROP TABLE IF EXISTS employees; -- create...

Using SQL Developer execute the following queries with these statements. N eed help with the joining clauses in SQL. PLEASE help Write a query to display the title, publisher name, and author FROM...

For each question show me the query that you wrote and a screen shot of the results that you got. A few notes: It does no one any good to see just ids. So, if say it asks for a student then you need...

Value creation at the global levels begins when an organization transfers a core competence to an overseas market. Discuss this statement in details. The layout of your answers should be in paragraph...

Two charges originally separated by a certain distance are moved farther apart until the force between them has decreased by a factor of 10. (a) Is the new distance (1) less than 10, (2) equal to 10,...

What is a 2 - year stack ? EPS forecasted two years in the future Percentage change in an operating metric ( revenue , same store sales, etc ) compared to the same period two years ago Total return (...

Let S=$32, K=$33, r=4%, =25%, =0, T=0.5 year, and n=2. a.) Find u and d. b.) Use the risk neutral probability to find the price of a European put c.) Use the risk neutral probability to find the...

C When advertisements appear on a Web page, are you annoyed? What kind of Web ad would prompt you to click it?

A How many advertisements do you think you encounter in a day? How persuasive do you think they are?

Define the goals of persuasive speaking