Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed

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 type

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Power Bi And Azure Integrating Cloud Analytics For Scalable Solutions

Authors: Kiet Huynh

1st Edition

B0CMHKB85L, 979-8868959943

More Books

Students also viewed these Databases questions

Question

Why did it enter into these partnerships?

Answered: 1 week ago

Question

7-16 Compare Web 2.0 and Web 3.0.

Answered: 1 week ago