Back to the Data Model.
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.