(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]