Question
Consider the following set of requirements for an Online Car Rental Management System Database. The OCRMS keeps the fundamental information of each customer such as
Consider the following set of requirements for an Online Car Rental Management System Database.
The OCRMS keeps the fundamental information of each customer such as name, email, password, national ID number, driver license number, expiry date of driver license number, customer ID number, nationality, detailed address, mobile number, date of birth and sex. National id number, customer ID number and driver license number are unique for each customer.
The OCRMS keeps all necessary information about the employees.
Each Car is described by type (e.g. sedan, pickup, truck etc.), brand name, class, model, color, fuel type, current odometer, rental fee per day, location, plate number, vehicle identification number VID and expiry date of vehicle registration. Both VID and plate number are unique for each car.
The customers can register, view available cars, their profiles and prices and book from them by identifying the location, pick-up and return date and time.
An invoice must be issued for each booking plus any additional days or odometers after returning the car.
Different types of payments can be accepted such as cash, cheque and credit cards.
Payment for credit cards should include the cardholder name, cardholder surname, card number, card type (visa, master card, etc.), card expiry date, card security code, total price paid after deducting the cash and cheque value.
The Cheque must have a Cheque-number, expiry date, and amount.
The customer can evaluate the car (out of 5 stars) and write a feedback after returning it.
SQL Queries:
1-List the name and email for all customers who are currently renting cars along with the details of
cars they have rented and renting date.
2-List the name and email for all customers who supposed to return the cars but they did not.
e Ea Rento Management Syctem (oc ens) Custome e s Name Aodhol addres one Mame Employee war Makes Booe Color uure 2.1 D Mame Mendt mint type e Ea Rento Management Syctem (oc ens) Custome e s Name Aodhol addres one Mame Employee war Makes Booe Color uure 2.1 D Mame Mendt mint typeStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started