Database Creation - Car Rental

Database Creation - Car Rental

P Criterion G: Identifying the problem within a social context
The Richmond car hire system has a total of 100 cars, 50 drivers and 15 other workers among who are the two directors, a site manger, secretary and financial manager. Its head office is located in Dar-es-salaam. The Richmond Car Rentals offers services of hiring of all types of cars all over Dar-es-salaam. So far the car hire services are done manually by keeping written records of the cars, drivers, workers and customers. All the records were stored in books. It has resulted to several problems which include:
This has created the consumption of so much time of finding details of a particular record.
It creates a major problem of knowing who has taken what car and what time the car was taken and returned.
Sometimes it has created problems in knowing which car was free and whether it is in a condition ready for hire.
The payments were done manually hence making it difficult to calculate therefore which resulted in greater chances of errors in the calculations.
Another problem was that if a record was missing or was destroyed by mistake there would be no backup to retrieve information from that record if needed. A single loss of record could cause a disaster.
It also gave the feeling of insecurity because unauthorized personnel could simply change or destroy the records easily without anyone knowing.
The presentation of records was usually untidy as it was handwritten and not typed.
Therefore the board of directors has come to a conclusion of changing their manual system to an automated one using current technology. My client, Shahzmin Mitha is one of the directors and I have approached her to help her company out with this problem.
Criterion H Analysis and feasibility study
The company has therefore decided to automate the system by the use of computers and their peripherals. In order to automate our system we will have to design the system in such a way that it can be used by a...

Similar Essays