Database Answers Stretched Limo

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
Limousine Services
Back to the Data Model.
User Requirements 
These Requirements for a Limousine Service were established by Ashraf from Khartoum in the Sudan on 16th. June, 2007 :-

My Database must deal with :-
  • Cars (accounts, renting, maintenance, ...)
  • Drivers(accounts, salaries, ...)
  • Customers(accounts, renting contracts, payments, ...)
  • Accounting Transactions for example:
  • and so on ...
  • If a customer rent a car for 3 days in 50 dollar/day , the accountant registers 50 dollar by the end of each day to guarantee that the customer had actually used the car, and this is because sometimes a customer rent a car and bring it back before completing the days in the renting contract.
  • A driver(an employee) has a percentage for each day he drive a car and must be submitted each day. The accountant uses a (double entry) approach to submit the accounting transactions.
  • Home Ask a Question Careers Contact us Data Models First Timers Search Site Map