There are three relations used for this example – RENTAL_CUSTOMER, CAR, RENTAL.
Below are the SQL statements used to create the relations.
Data have been inserted to the relations:
List all cars rented by Smith since 1st of August 2017
List each make of the cars and the total number of cars rented of that make
A new car is bought and is updated to CAR, List the each make of the car and the number of that make
The new record of CAR:
Now count the number of cars of each make:
List the registration number and the make of the cars that have not been rented
Update Jones phone number to 988-2223
The change statement:
after the change: