database project part 2 for RELIABLE PAPERS
Albt20
abdulla_ahmaid_design_report.docxProject Overview
Car Rental
Statement of Purpose
To keep track of business operation specifics. For example: who the clients are, payment amounts, payment types, cars being rented, whether clients are individual or large companies, etc.
Reports
1. The most popular cars rented.
2. The average rental length.
3. The most popular season for rentals.
4. The frequency for types of cars rented.
5. How customers usually pay.
6. What percentage of income comes from large company rentals.
7. The average cost for clients to rent moving trucks.
8. The average age of individual rentals.
9. The percentages of client occupations that are employed. (vs self-employed or student).
10. The average annual repair costs.
Business Processes
1. Rental length
(daily, weekend, weekly, monthly)
2. Maintenance costs
(monthly)
3. Client payment amounts and types of payment
(Mastercard, Cash, VISA)
4. Post-rental car check-up
(charges for customer if damage is found and maintenance information (over mileage charges etc.)).
5. Client information and frequency
6. Employee wages
7. Requested rental car class and mileage allowance
8. Promotions
(based on popular season/customer loyalty/large companies)
Data model
Primary entities
· Car rented
· Payment
· Clients
· Promotion
Car rented relates with payment made by clients and depending the car rented, clients get promotions.Therefore,car rented relate to payment and promotion, payment relate to clients and car rented, clients relate to promotions and car rented while promotion relate to clients and car rented.
ERD
Promotion
Clients
Payment
Car rented
Table Map
|
Car rented |
|
Car type |
|
length rented |
|
maintenance cost |
|
post-rental check |
|
Car class requested |
|
Payment |
|
Payment type |
|
Payment amount |
|
MasterCard |
|
Cash |
|
Visa |
|
Categories |
|
Client payment |
|
Employee wage |
|
daily |
|
weekend |
|
weekly |
|
monthly |
|
Name |
|
Date of birth |
|
Location |
|
email address |
|
Occupation |
|
clients |
|
clients information |
|
type of clients |
|
Categories |
|
small cars |
|
Trucks |
|
Promotions |
|
popular seasons |
|
customer loyalty |
|
large companies |
|
Categories |
|
Companies |
|
individuals |
Data dictionary
|
Car rented |
|
|
|
|
Field name |
Field Type |
Size |
Properties |
|
Car type |
Text |
15 |
small car/trucks |
|
Length |
Text |
15 |
daily/weekly/monthly |
|
Maintenance cost |
Autonumber |
15 |
Amount in dollars,it containes both signs and numeric. e.g $100 |
|
Post-rental check |
Text |
15 |
charges and information |
|
Car class requested |
Text |
15 |
Name of car class |
|
Payment |
|
|
|
|
Field name |
Field Type |
Size |
Properties |
|
Type |
Text |
15 |
MasterCard/Visa/Cash |
|
Amount |
Autonumber |
15 |
in dollars,it contain both signs and numbers. E.g$100 |
|
Category |
Text |
15 |
client payment/wages |
|
Clients |
|
|
|
|
Field name |
Field Type |
Size |
Properties |
|
Name |
Text |
15 |
Last name,Mask |
|
Date of Birth |
Autonumber |
15 |
It contains several elements.e.g 12/5/1990 |
|
Location |
Text |
15 |
Continent,state |
|
|
General |
15 |
It contain several elements.e.g [email protected] |
|
Occupation |
Text |
15 |
student /self-employed |
|
Client type |
Text |
15 |
company name,individual |
|
Promotions |
|
|
|
|
Field name |
Field Type |
Size |
Properties |
|
Popular season |
Text |
15 |
name of the season |
|
Customer Loyalty |
Text |
15 |
loyal /not loyal |
|
Large companies |
Text |
15 |
Name of the company |
