Database Creation Car Rental Essay

2672 words - 11 pages

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 ...view middle of the document...

Some of the specific objectives the company would like to achieve are as follows:
The system will be able to handle all types of data efficiently and without much consumption of time.
The system will be able arrange data in an orderly manner in which data can be read easily.
The system will be user friendly and can be used by any knowledgeable person.
The system will be producing far more accurate results and in a well presented manner.
The new solution plan is to change the manual system to a computerized one by use of computer and its peripherals. The new solution will involve storing the data in databases by using Microsoft access. The new system will be cost effective and efficient, increasing the reliability of the system. It will be user friendly and will calculate the amount to be paid and the salaries automatically.
Another possible solution would be using by using another software application package Microsoft excel. The data would be entered in different cells according to their specific labels. Formulae would be used to calculate the amount needed for the customers to pay and the salary of the staff. At the end of the month the total amount of money would be calculated by using a formula to know the financial status of the business. This solution is simple and there is no need of creating databases. This solution would also be cost effective and doesn’t require extra parts to be fitted or upgraded but also has its disadvantages.
Microsoft access has a lot of advantages and some disadvantages. Both the advantages and disadvantages are compared and mentioned below:

It is fast, consistent and reliable. It is easy to search sort, hire and renew items in the system
The system can be infected by a virus and may lead to loss or change of data
The system can be protected by using a password and disallows any unauthorized personnel to access the system
Apart from viruses the system is also threatened by hackers who can cause fraud and access your system and make changes without your awareness
The data in your system is organized and can be used on networks with simultaneous users
If data is not saved after editing or making changes and the power goes off it could lead to loss of information
If any mistakes are made in operating the system, it can be easily corrected

Time will be needed to train the staff without any knowledge of operating the system.
Microsoft access allows you to create tables, forms, queries, reports.

Microsoft access gives you the freedom of setting validation rules so as to avoid errors

Microsoft excel has a lot of advantage but also some disadvantages. Below is a table displaying the advantages and disadvantages of using excel:

The program is cost effective and efficient
The staff will need some knowledge on how to operate the software
Unlimited amount of data can be recorded
It can be accessed and by hackers
The data can be...

Other Essays Like Database Creation - Car Rental

Advertising Final Paper

2270 words - 10 pages considered an intrusion. And elder people are not familiar and willing to accept the new technology like Internet, so they would prefer to keep the old way using Yellow Pages. Chapter 14 Explain how companies use database marketing. Name some of the companies that may have your information in their database. Explain how this information is used to reach you. The database is a tool for database marketing- the use of specific information about

Information System Controls for Systems Reliability

5139 words - 21 pages doors? The advantages of biometric security devices include: * Providing security advantages over traditional methods because physical traits are almost impossible to duplicate. * Ease of use. * Cannot be forgotten like passwords and user id’s. * Cannot be left at home, in a rental car, or in a taxi. * Cannot be

The Dream

5696 words - 23 pages at the home studio by their primary material type: cameo, crystal, pearl, metal, feather. • Creation of each product will begin with product illustrations. These sketches will be done in pencil by owner, Miss Archibald and stored in a notebook on site. Completed designs will be scanned and stored in an online database as a running inventory of all products ever constructed. • Construction of individual pieces will take place in the studio

Research Assignment 1

874 words - 4 pages Research Assignment 1 Windows Server 2008 comes in different versions to accommodate features useful to different types of users. It is similar to buying a car with different features. The more features or the better, the more money it will cost. Since Microsoft created multiple versions, they were able to maximize their profits by capturing both types of customers (Large business, and smaller ones). The significance of each of the Windows

Pestle C of Planters Bank

1055 words - 5 pages and pursuit of social development projects. Now, Plantersbank defines its framework for a triple bottom line approach by combining profit, social returns, and environmental management and fair practices on equal and equivocal terms. STRATEGIES: 1. Plantersbank chairman Ambassador Jesus P. Tambunting declared Small and Medium Entrepreneurs key contributors to wealth creation, employment generation and social mobility in the

Document 1

5479 words - 22 pages , pillows or blankets from the cabin staff. They will get their capabilities from a special database installed in the airplane cabins. AA has the opportunity to provide passengers with individual entertainment not offered by any other airline. They will be the first airline to offer this to their passengers. Threats The technology used by the AirPad product lines may interfere with the flight technology if not properly programmed. If service is


2031 words - 9 pages , opportunities and threats were analyzed as part of an external environmental analysis; over which no control. Internal Analysis: Strengths As one of their biggest strength, not only benefits from having a first mover advantage, diversifies itself through six different products. Current travel products include airline tickets, hotel rooms, and vehicle rental. It also sells non-travel related goods such

Team Legal

5829 words - 24 pages John offers to pay Sally to drive his car to California. Once Sally drives the car to the California the performance is complete, but John has not paid making this transaction partially executed. Once John has paid Sally, the contract is wholly executed because both Sally and John have performed their responsibilities under unilateral contract. (Jennings, 2006, p.505). The contractual agreement between Pat and the tailor, once the tailor has

Ford Motor Company Case Analysis

5581 words - 23 pages begins crash testing vehicles. 1956: Ford becomes a publicly traded company. 1957: Ford introduces the Edsel. 1959: Ford credit is founded which offers loans and leases to car buyers. 1970: Ford introduces three points, self-adjusting, and retracting front outboard lap and should belts. 1980: Phillip Caldrell succeeds Henry Ford II. 1990: Ford introduces Explorer. 2001: Ford Board of Directors name Bill Ford to replace Jacques

Resistance to Change

3325 words - 14 pages organizational problems must be of mutual creation, a joint project by management and labor to solve an organizational dilemma. Leading change, with the full commitment of the workforce, depends on empowerment (Quinn, 1996). Axelrod (2002) described this in terms of building communities and connecting people to each other. This is where the spark of creative solutions are formed, and no doubt solutions that are mutually acceptable and solve the problem at

Employment Law

1154 words - 5 pages and is a very real problem that still exists and in some cases is getting worse. The Civil Rights Act included the prohibition of job discrimination and the creation of the Equal Employment Opportunities Commission. This act was to improve the quality of life for African Americans and other minority groups. When it comes to workplace discrimination this would fall under the EEOC, where a report have to be filled with the EEOC. Then the

Related Papers

Car Rental Ghana Essay

1213 words - 5 pages TOPIC: ONLINE CAR RENTAL SYSTEM * CHAPTER -1 INTRODUCTION TO ONLINE CAR RENTAL SYSTEM 1.1 Introduction This project is an online car rental system. It is a web based system specially designed for car reservation management. Through the system, customers can view the rental car company’s available cars and their features. The customers can register and make reservation for the cars online. Through the same system the

Mobile Technology Essay

1644 words - 7 pages Mobile Technology & Applications Effect on Rental Car Companies By Aubrey A Maloney IS535 –Managerial Applications of Information Technology DeVry University OCT 8, 2010 Abstract Mobile technology and applications are the future of business. With this technology it will make it easier to automate a business such as a rental company and help cut costs. With almost every phone created theses days being Smartphone/PDA and

Car Reservation System Essay

5438 words - 22 pages updated database IV. What’s the clients response towards the current manual system Ans: most of them complain of the inconviniences the current manual system and incases of customers missing flights and getting late for the flights brings a lot of complains V. What is the procedure in returning a car Ans: after the client has been offered the service by the driver assigned, the car must be checked on its condition and any expense

Policy Issues Geographic Information Essay

870 words - 4 pages Policy issues and availability of Geographic Information Geographical Information is a computer-based tool for mapping and analyzing things that exist and events that happen on earth. The major components of a GI are: a user interface; system/database management capabilities; database creation/data entry capacity; spatial data manipulation and analysis packages; and display/product generation functions. GIS technology integrates, via the