Jalopy Rentals Specialise Business Renting Cars Director Requested Creation Database Syste Q43778716
a) Jalopy Rentals specialise in the business of renting cars.The Director has requested the creation of a database system toassist in effective and efficient running of its business. Developa relational schema for the Jalopy Rentals Database, based on thefollowing requirements:
The business has many outlets for which it needs to trackinformation such as: outlet number, address, phone number and emailaddress.
Each outlet employs staff members. Information stored on staffinclude: staff number, name, address, phone number, date of birth(DOB), gender, job title, and salary.
Each outlet contains various vehicles for hire (Audi A7, Ford Ka,Fiat 500, VW Up, Toyota Aygo, Citroen C1, BMW3) and the business isconscious of recording information on each vehicle such as:registration number, model, make, engine size and currentmileage.
Clients can potentially rent multiple vehicles. For each rentalit is crucial that a hire agreement is generated for the client.Details of this hire agreement are also stored and include hirenumber, hire start date, hire finish date.
Once the hire agreement has been signed the following clientdetails are recorded. client number, name, DOB and driving licencenumber.
The Company has two types of clients only: personal and business.Additional information stored on personal clients include homeaddress, home phone number. Further data stored on business clientsinclude name of business, type of business, business address, andbusiness telephone number.
Expert Answer
Answer to a) Jalopy Rentals specialise in the business of renting cars. The Director has requested the creation of a database syst…
OR