Car Rental System

Topics: Renting, Given name, Family name Pages: 2 (442 words) Published: April 3, 2013
Car Rental System Analyze

I planned that my car rental system has the next variables: 1. For the car: Plate number, car name, car color, car speed, and rental status. 2. For the customer: Last name, first name, birthdate, telephone number, cellphone number and address. 3. For the employee’s: Last name, first name, address, position, telephone number, cellphone number and birthdate.

The rental database should have information’s:
1. When was the car rented (date)
2. When was the car returned (date)
3. How much days is the car rented
4. How big was the deposit (reservation)
5. The final payment for the customer
6. Discount value (0%,10%,20%)
7. Customers name and sure name.
8. Employee name and sure name.

The payment of the employer is going to depend on the number of cars he rents -Payment + bonus .
Bonus = 2% of payment for 0-5 cars.
Bonus = 4 % of payment for 5-10 cars.
Bonus = 8 % of payment for >10 cars.

THE FUNCTIONALITY OF THE PROGRAM
The main function of this program is make the job of a rental firm easier. For example it could help the employees to save time (fill the spaces and print). With this program the company will have the hole database on one place. The price of the renting is going to depend on the car quality , days of renting , and period in the year .

CAR RENTAL SYSTEM TABLES
cartable|
Car_Id| Plate_no| Brand| Color| Speed| Rental| Status| 1| J3M 9G0| AUDI| RED| 230 mph| 200| 1|
2| B3I 5H7| BMW| BLUE| 300 mph| 300| 1|
3| A3Z 1R3| HONDA | GREY| 300 mph| 300| 2|
4| A4C 4R5| TOYOTA| BLACK| 250mph| 500| 1|
5| Q3S 123| SMART| blue| 120mph| 100| 2|

customertable|
Cus_Id| Lastname| Firstname| Address| Cellphone_no| Telephone_no| Birthdate| 1| Gekic| Dino| Sarajevo Stup| 061-985464| 4545485| 12/25/2008| 2| Pandzo| Rijad| Sarajevo Dobrinja| 062-544894| 776| 10/6/2008| 3| Vural| Halit|...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • RENT a Car Business plan Essay
  • System Essay
  • CASE MEMO OLYMPIC RENT A CAR Essay
  • Gds-Global Distribution System Introduction Essay
  • Car Rental Companies and Enterprise Rent-a-car Essay
  • Global Car Rental Market
  • Global Car Rental Market Essay
  • Essay about Enterprise Rent-a-Car

Become a StudyMode Member

Sign Up - It's Free