Assignment Paper

1. Use MYSQL workbench to create database in MYSQL server. Create EER diagram in MYSQL
Workbench. Use MSQL workbench to create ad EER diagram (tables, relationships, PK, FK, indexes)
based on your logical database design (5 Marks)
2. Create database tables and any appropriate database views, stored procedures, triggers. Then,
enter hypothetical data records with into your tables (minimum 5 records in each table) (10 Marks)
3. Create Form using LibreBase or MySQL Work Bench (5 marks)
3.1 Create a Form for Car4U Manager to enter the information about Car4U cars
3.2 Create a Form for Car4U Manager to enter information about the Staff
3.3 Create a Form for Staff to enter the car rental information
4. Create the following Queries (MySQL Work Bench or LibreBase): (10 Marks)
Query 1: Give last name of all customers who are now renting a car from our company.
Query 2: Give make and colour of all cars currently rented out.
Query 3: For each completed rental, give the rental price and rental id.
Query 4: List last name of all managers.
Query 5: List last and first names of all customers.
Query 6: Give a query that answers the question “Is any of our employee also our customer”?
Query 7: List customers sorted by their rental history (measured in Days) from high to low.
Query 8: Find rental id of all completed rentals.
Query9: Find the value of the cheapest (completed) rental. Utilise query 3 as the inner query.
3
Query 10: Give makes of the cars that have never been rented.