CAR RENTAL ONLINE SYSTEM FOR NORADLIRAZMAN CAR RENTAL SDN. BHD.
DAMANSARA
noradlirazman bin othman FEBRUARY 2011
TWINTECH INTERNATIONAL UNIVERSITY COLLEGE OF TECHNOLOGY
Declarations
“I hereby declare that I have read this project report and in my opinion this report is sufficient in terms of scope and quality for the award of the degree of the degree of Bachelor of Computer Science (Hons).”
Signature :
Name of Supervisor : MISS. NURHIDAYAH BTE ISHAK
Date : 16 February 2011
DAMANSARA
NORADLIRAZMAN BIN OTHMAN
A project submitted as a Partial Fulfilment of the Requirement for the Award
of Bachelor of Science (Honours) Degree in Computer Science
TWINTECH INTERNATIONAL UNIVERSITY COLLEGE OF TECHNOLOGY
2011
Declaration of plagiarism“I declare that the work which I am submitting for assessment contains no section copied in whole or part from any sources, unless it is explicitly identified by means of quotation and marks.
I declare that I have acknowledged such quotations by providing detailed references to the source materials, in approved format. I understand that failure to identify copied materials and to provide appropriate referencing both constitute plagiarism, which is a serious offence under the university’s codes of practice.”
... Name: Noradlirazman Bin Othman Date: 16 FEB 2011
Acknowledgement
I owe my most sincere gratitude to Allah the almighty and the most powerful for offering me such a strength, endurance, audacity, and capability to accomplish this project.
I would also like to express my deep and sincere gratitude to my supervisor, Miss Nurhidayah, his wide knowledge and his logical way of thinking have been of great value
for me. Her understanding, encouraging and personal guidance have provided a good basis for the present project.
During this work I have collaborated with many colleagues for whom I have great regard, and I wish to extend my warmest thanks to all those who have helped me with my work in the International University College Technology Twintech.
I owe my loving thanks to my mother, and all my family members.Without their encouragement and understanding it would have been impossible for me to finish this work. My special gratitude is due to my brother, my sisters and their families for their loving support.
Car rental online system started in late 90s in few special car rental companies that has now reached most of the car rental companies. It is yet to take off in Noradlirazman Car Rental Sdn. Bhd. owing to various problems. This project tries to identify the barriers, analyze the convenient steps in automating the car rental system and the technology available. The designer made a project on the car rental online system, which is an attempt to automate the existing rental system. The fundamental of this development is that it is essential to emphasize this aspect as the car rental system automation is yet to take off in majority of the Noradlirazman Car Rental Sdn. Bhd. The need for car rental automation is justified by the cost-effectiveness and the benefits derived by the car rental users that have become the major consideration. The Car Rental Online System follows a software development life cycle approach that includes initiation, planning, design, development, testing, implementation, and maintenance phases.This system enables its user to perform all the operations regarding a car rental with features that provides the user to make entry of user and admin registration, deleting and inserting the record from the database, issuing a an invoice to a customer and making entry of a new car rental form.
Acknowledgement………....v
Abstract………vi
Chapter 1 Introduction 1.1 Introduction...………....…..10
1.2 Background Studies………....…....11
1.2.1 History of Noradlirazman Car Rentals Sdn. Bhd.…...11
1.2.2 Description of Noradlirazman Car Rentals Sdn. Bhd.………...11
1.2.3 Current System………...……12 1.2.4 Proposed System………...…...12 1.2.5 Comparison………...………13 1.3 Aim………...………...………….14 1.4 Objectives………...……..…14 1.5 Problem Statement………...….14
1.6 Importance of the system……….……...……..15
1.7 Scope of Library Management System……….…………...…15
1.8 Conclusion………...17
Chapter 2 Literature Review 2.1 Project Domain………...…...18
2.2 Current System Approach……….……….………...18
2.3 Technology Used………...19
2.4 Case Studies………..………...20
Chapter 3 Project Methodology 3.1 Introduction………..………...….22
3.2 Waterfall System Development Life Cycle Model……..………...23
3.3 Project Management……….………...….25
3.4 Hardware and Software Specification……….………...26
3.5 Operation assumption………..………...…26
Chapter 4 Design 4.1 Introduction……….,………...28
4.2 System Design………..………...….29
4.3 Database Design………...………31
4.4 Interface Design………...….34
4.4.1 Input design………...35
4.4.2 User Design Interface………...………44
Chapter 5 Coding 5.1 Introduction……….,………...….50
5.2 Code for each function………..………...……52
Chapter 6 Testing and Implementation 6.1 Introduction……….,…………...…….57
6.2 Testing………..………...….58
6.3 Implement………...61
Chapter 7 Conclusion and recommendation 7.1 Introduction……….,………...63
7.2 Review of objectives………..………...63
7.3 Advantages and Disadvantages of the system………...63
7.4 The limitation of the system………...64
7.5 Conclusion of the project………...65
List of Table
Table 1 : Comparison Between current system and proposed system………...13
Table 2 : Cost and Benefit Analysis………...………...…25
Table 3 : Available Cars……….………...31
Table 4 : Unavailable cars………..………...31
Table 5 : User Registration………..………...32
Table 6 : Admin Registration………...32
Table 7 : Rental Information………...33
Table 8 : Technical………...….53
Table 9 : Registration Unit………...54
Table 10 : Test Case Login………...…59
Table 11 : Test Case Register New User………...…..59
Table 12 : Test Case Make Rental Order………...…..59
Table 13 : Test Case Send Form………...60
Table 14 : Test Case Inquiring User………...…….60
Table 15 : Test Case Inquiry User Rental Records………...60
Table 16 : Test Case Search for Cars………...……61
List of Diagrams Diagram 1 : Waterfall Model (SDLC)………...……….24
Diagram 2 : Sequence Diagram………..…...…….29
Diagram 3 : Use Case Diagram……….………...30
Diagram 4 : Class Diagram………...………...….30
List of Figures Figure 1 : Homepage………..………..…...35
Figure 2 : Admin Registration………...………...36
Figure 3 : User Registration ………...37
Figure 4 : Admin Login………...38
Figure 5 : User Login...………...38
Figure 6 : Mainfleet………...39
Figure 8 : Self-Drive Rates...41
Figure 9 : Reservation and Renting Locations………...42
Figure 10 : Available Cars………...….43
Figure 11 : Unavailable Cars………...…….43
Figure 12 : User Registration………...….44
Figure 13 : Admin Registration………...…….44
Figure 14 : Invoice………...…….45
Figure 15 : Rental Form………...…46-49 Figure 16 : Gant Chart………...…71
References……….………...67
List of Appendix Questionnaire for library staff……….………...69
Questionnaire for library members……….………...70
Gantt chart………...………...….….71
Coding………...…72
User Manual………...…155
CHAPTER 1 1.1 Introduction
Today, there are wide varieties of car rental systems in the market. These include from online or offline. Unfortunately, despite the availability of such systems, the need for renting a vehicle is still growing and the demands are increasing whether they are for general or private use. The car rental contract is designed in a specific form for the car leasing at which consists of
the leaser will offer the features of the car agreed, together with the tax payment, insurance, maintenance, and the accessories and including the realization value added of the valuation of the car.
At Noradlirazman Car Rental Sdn, Bhd. made a conscious decision to ask their clients what they need most. Document has long ago become an integrated part of resource management. Also, we collected relevant information on the Internet and integrated it into the development. They are building up subject specific electronic libraries of data for Car Rental Online System. They are developing a prototype of an Online Car Rental System with a lot of added value. They do this together with our customers who give us ideas and real life feedback. They are constantly thinking of ways to fulfill our customers’ information needs.
The Online Car Rental System is designed & developed for car rental information and invoice of the rental orders in the website along with the member’s registration details. The customer rentals order is received in the rental form and the new member is entered in the member registration form. When a member wants to get the desired car rental information the same is issued on the availability basis to the member. The issuance and due date for the returning of the book is also entered into the Book Issue form under third menu Book Issue. The customer will be informed via email for any successful order that is issued. The administrator will have the full information that is needed to check, search, edit, update and replace any new changes that occur in the systems database.
1.2 Background studies
Background studies aim to objectively and rationally uncover the strengths and weaknesses of the existing system and proposed system. As such, this section is well-designed to provide a historical background of the methods used before the Online Car Rental System was introduced to the company. This section also covers a description of the company.
1.2.1 History of Noradlirazman Car Rental Sdn. Bhd.:
Noradlirazman Car Rentals Sdn. Bhd., which was established in 2010 as an independent leasing company in Malaysia and has branch offices in major towns throughout the country.
They are presently a growing car rental company in Malaysia. Our Head Office is in Saujana Ria, Damansara and they have rental offices/counters located in the cities of Kuala Lumpur and Shah Alam, Kuala Lumpur International Airport, the city of Penang, Penang Airport, the city of Johor Bahru, Johor Bahru Airport, Kuantan and Kuantan Airport.
They provide a fleet of well-maintained cars, ranging from the latest locally assembled foreign makes and models to the most popular locally manufactured Proton cars. Their fleet of well-maintained cars, in terms of capacity, ranges from 1300cc to more than 2000cc.
1.2.2 Description of Noradlirazman Car Rental Sdn. Bhd:
At their head office, they have a fully equipped in-house workshop, which is managed by their team of experienced and well-trained mechanics. Coupled with their team of dynamic operations personnel, they provide an efficient and reliable backup service for our customers' needs and comforts. In addition to these services, they also have a team of dynamic and well-trained sales personnel to provide personalized services to the customers, particularly our corporate customers.
With these resources and their vast experience in fleet management, they have introduced fleet management services which are provided through our subsidiary, Noradlirazman Fleet Management Sdn. Bhd. These service which are extended to fleet owners enables them to enjoy administrative convenience such as monitoring and scheduling of vehicle servicing and to a certain extent, vehicle maintenance cost control.
1.2.3 Current System
Most of the car rental operations are still being done manually. Therefore, it really causes difficulties to user. Whereas using the manual way the user has to fill in the provided form and give a copy of identification card and license. Problems that had been identified in the current system are:
• Customers having difficulty making a registration because of the manual system the company was using. This made the costumers had to come in and out of the offices and counters just because they only need to fill in the details in the form that were needed for
• Mistakes in giving car to the correct customer due to data redundancies that occurred because of the manual way.
• Mistakes that occurred during the total rental payment calculation process. • Keeping track of cars is a bit difficult to be done since it is using manual way.
1.2.4 Proposed System
Proposed system is an Online Car Rental System. Through our website the user can add members, add cars, search members, search cars, update information, edit information and mail the invoices. All the manual difficulties in managing the online car rental system have been dealt with by implementing website automation.
User friendly interface is the primary way the systems interact with the user and allow him or her to interact with. With the help of such web authoring tools such as dream weaver, it is possible to achieve it.
Online data storage management websites for example www.statcounter.com and www.num-sum.com offer an alternative to such other methods of storing data such as MySQL and WAMP servers. The use of web mail such as Yahoo Mail has become an easier task on organizing information that has been collected via website and kept as for record purposes.
This will reduce the work-load and paper work will reduce the manual work. Automated data acquisition, data location management and inventory and item verification will reduce work load of the car rental staff , this way more secure, time saving, reliable and less error prone system will be implemented for accelerate the work flow of the car rental company. The online system will maintain all the record at each level. It will help the user to retrieve the valuable information whenever needed. Every data will be stored in the computer memory to reduce the space being used whereas now it is stored in registers and files which are then stored in bookshelves, file cabinets, racks or shelf and they need a large space.
The Online Car Rental system offers users easy-to-use search facility that can be performed on various combinations of elements from the record. There is no limit on the number of data that can be inserted.
The new system will take less time in entering the data, processing it and getting its output. Fewer resources will be used as no large registers, files, Ledgers, pens; correctors will be needed or used. Therefore, less time will be taken to process the data that will help to do more jobs in less time.
1.2.5 Comparison
Current System Proposed System
Information about registration of the customers is not properly maintained.
Reduce the workload of employee.
Tracing customers, available cars for rent and user and admin password is very difficult.
Faster retrieval of information about the desired information.
No central database can be created as information is not available in database.
Provide facility for proper monitoring reduces paper work and provide data security.
Fast report generation is not possible All details will be available on a click.
Comparison between current system and proposed system table 1.3 Aim:
The aim of this project is to develop a Car Rental Online System for Noradlirazman Sdn. Bhd. at Damansara main office.
1.4 Objective:
Below are the main research objectives of this project:
• To get, store and manage information from lessees/renters
• To develop a web based system (online) to help manage the car rental business
1.5 Problem Statement • Data Growth
As we know, data increase by day. So, it is very difficult to store and maintain all the data manually. Therefore, proper and systematic database must be used to afford these data growth and to allow user to update or maintain data efficiently.
• No Computerized System
This system is developed to 'upgrade' the manual system into computerized system. Currently, there are car rental is still using manual system in recording some data. If the data are not managed carefully and efficiently, it will cause problems to that company where the loss of data and data redundancies may occur.
• Data security is not assured
This is due to the manual way of recording the data. As we know, in manual way, data are being stored by recording it on paper. Therefore, it may easily get damage or misplace that will lead to data loss.
1.5 Importance of Car Rental Online System
This research is significant due to the fact that in these challenging business environments, many car rental firms have been unable to properly implement corrective methods in order to improve their services and provide superior quality and security to their customer. Working with our system organization can benefit from many things like:
• Online booking engine • Fleet management solution • Vehicle scheduling solutions
In essence, some of the firms do not even know where to start when it comes to securing their properties where in our case are the cars. Hence this project is meant to serve as a guide to firms like these in terms emphasizing the importance of effective security, and the strategies that can be employed in order to improve and perfect security so that businesses can be run without any losses.
1.7 Scope of Library Management System
These are the sequence of events in the development of the Car Rental Online System, which requires mutual effort on the part of user and technical staff. Project scope will contain the following activities. The designer starts with the requirement stage of the project to understand the requirements. This is a very critical stage for developing this project to communication with user as much as possible and documents all requirements.
After completing the requirement study and documentation, it is time to design the system based on the requirements. The first step is identifying all the features the designer is going to implement in the software. The requirements document is a used as a guide in identifying the features according to the requirements specification.
System testing is the stage of implementation, which aims at ensuring that the system works accurately and efficiently before actual operation commences. It is a utility as a user oriented vehicle before implementation to meet user needs. Thus the system should be tested to see whether it meets the user requirements.
The implementation phase involves installing approved applications into production environments. Primary tasks include announcing the implementation schedule, training end users, and installing the product. Additionally, organizations should input and verify data, configure and test system and security parameters, and conduct post-implementation reviews. Management should circulate implementation schedules to all affected parties and should notify users of any implementation responsibilities.
From information requirements to final implementation, the system development cycle is an ongoing process. As Noradlirazman Car Rental Sdn. Bhd. changes, information requirements change, and the cycle continue.
Car Rental Online System comprises a relational database, to interact with the online database, and two graphical user interfaces (one for administrator, one for user). It separates the functions into discrete programs called modules, each of them integrated with a unified interface.
1) The administration module enables administrator to manage the user management with efficiency and with ease. With the possibility the user will increase from day to day, the system will be used to them manage the user.
2) Technical module enables the user to manage the information with more convenience. With the possibility there are more than hundreds of individual data at Noradlirazman Car Rental Sdn. Bhd, the information can be managed faster and easily to track.
3) Circulation module enables the user to manage the activity with more speed and accuracy. With the rate of hundred users per day come to web site and use the Car Rental Online System.
1.6 Conclusion
To sum up, developing a computer based information system for Noradlirazman Car Rental Sdn. Bhd. was a matter of essence. It will be a medium for the Car Rental Online System for the proper management of the company user information in an organized way. It is now essence for the organization to transmit the company record on to the system, without crawling in various departments. The Computer Based Information System made to ease the flow of information from one department to other. Since the data are organized in a database, and are secure in computer system, the complaint of loss of information will not be heard again. The personnel will be satisfied with the system and willing to adopt it. The information overload problems on certain departments will get minimized.
CHAPTER 2
LITERARTURE REVIEW 2.1 Project Domain
Car Rental Online System uses front end as PHP designed web page and backend as www.num-sum.com internal database. The system stores information about the company and to whoever has made the car rental process. All these details are stored in the database by entering into www.num-sum.com internal database and the details can be displayed from the database by writing the query in www.num-sum.com internal database. This project involves several modules to carry out each action.
The system creates database for storing the details in tables. It enables to create table for member details, a table for storing company details and another table for storing the details to whom have taken the rented the cars namely customers details.
either store in a database and see the details when required or see the details at run time by selecting the option display.
Hence in the existing system for library management system, the performance evaluation system and the maintenance are done manually. The proposed system will maintain all the information in a standard database and will be able to generate reports as and when necessary. Accessing and the user has the right to search based on the above mentioned criteria’s.
2.2 Current System Approach
Most of the car rental operations are still being done manually. Therefore, it really causes difficulties to user. Whereas using the manual way the user has to fill in the provided form and give a copy of identification card and license. Problems that had been identified in the current system are:
• Difficulties in checking car status whether the car is being used, being repaired or available for rental.
• Customer does not know the detailed information about the car that they had rental.
• Mistakes in giving car to the correct customer due to data redundancies that occurred because of the manual way.
• Mistakes that occurred during the total rental payment calculation process. • Keeping track of cars is a bit difficult to be done since it is using manual way.
2.3 Technology Used
Car Rental Online System is a web based application system. The system is an online system. There are some hardware and software requirements that are needed in developing the system.
Microsoft Project
It is a project management software program developed and sold by
Microsoft which is designed to assist project managers in developing plans, assigning resources to tasks, tracking progress, managing budget and analyzing workloads.
Microsoft Visio is diagramming software for Microsoft Windows. It uses vector graphics to create diagrams. The 2007 Standard and Professional versions share the same interface, but the latter has additional templates for more advanced diagrams and layouts as well as unique functionality that make it easy) for users to connect their diagrams to a number of data sources and display the information graphically.
Hypertext Preprocessor (PHP)
Hypertext Preprocessor is also known before as Personal Home Page Tools (PHP). PHP is an open source technology that is supported by a large community of users and developers. Open source software provides developers with access to the software’s source code and free distribution rights. PHP is platform independent; implementation exists for all major Windows, UNIX and Linux operating system. PHP also provides support for a large number of databases, including MySQL. PHP code is embedded directly into XHTML documents. This allows the document author to write XHTML in a clear manner, without having to use multiple 'print' statements.
Database system
Online database storage www.nun-sum.com
Keeps track of the registration data, cars, login details and the car renting schedule.
Operating system/server Apache sever
The Apache HTTP server, commonly referred to simply as Apache, is a web server notable for playing a key role in the initial growth of the World Wide Web.
Hardware and Software Spec
The hardware requirements for Car Rental Online System are as listed below: RAM -512MG
Hard disk - 60GB CPU - 1.7MHZ Printer
2.4 Case Studies Perot Systems
Perot Systems has proven experience and expertise helping organizations worldwide develop, enhance, and manage their applications and IT infrastructure to maximize returns on their IT investments. And we can help your business achieve and increase competitive advantage through the creation of flexible, customer-focused, enterprise wide global information systems. (Perot Systems, 2005)
The Transition to web-based reservation systems and IP-based call centers with multilingual support Migrate mission-critical applications from legacy mainframe systems to open platforms using contemporary technologies seamlessly in titrate business partners and suppliers to successfully deliver services. (Perot Systems, 2005)
Integrate databases at various points of sale and field locations to maintain continuity of service delivery in real time, Perot Systems has helped leading car rental companies achieve higher levels of operational excellence and increase their customer base while consolidating and enhancing legacy IT systems to maximize return on technology investments. (Perot Systems, 2005)
A vehicle management system and method using wireless terminals is provided. In the method, a server on a network stores accumulated travel distance-based vehicle maintenance/consumable item replacement time information in a specific recording medium. The server transmits an accumulated travel distance information request message to a wireless terminal of a subscriber. The wireless terminal of the subscriber transmits accumulated travel distance information to the server. The server checks whether or not any vehicle maintenance/consumable item, which is required to be replaced according to the accumulated travel distance information transmitted from the wireless terminal, is present, based on the accumulated travel distance-based vehicle maintenance/consumable item replacement time information stored in the recording medium. If a vehicle maintenance/consumable item required to be replaced is present, the server notifies the wireless terminal of information of the vehicle maintenance/consumable item to be replaced. Thus, the appropriate time to replace maintenance/consumable items (for example, engine oil, brake linings/pads, and a generator) and prices of the items at the moment when they are replaced can be easily calculated according to
the accumulated travel distance information provided through the wireless terminal. (Jeon, 2006) (Name, 2009)
This study will determine the review of World Wide Web (WWW), testing a website, website requirements, Unified Modeling Language (UML) and provide some information related to the market development of the Go-Kart through online reservation system.
CHAPTER 3
PROJECT MEHTHODOLOGY 3.1 Introduction
In this Analysis phase the designer have analyze the requirements what the designer want to do for the project. The designer have to collect the requirements needed to develop the project. For that the designer have employed on-site observations method, used questionnaires for both staff and users of the library for gathering the requirements. The designer made an appointment to see the functioning of company. So the designer have visited the company for two days and observed staff issuing and collecting imformation and record keeping. The designer have also inspected the place where the records are stored and from that it was seen that it was a real mess. The designer also saw the records for cars, users, and accounts. From site visit the designer had a good understanding of the functioning of the system.
In this analysis phase, the designer have to design the project in mind how it has to be and what are all the operations that has to carry in the project and how it has to be interactive with the
this details has to store in the database for this type. The designer have to analyze the problem and develop the project. In this analysis phase the designer have to collect the details about the project such as what are all operations that will make interactive and what are all the fields that has to be present n the database and the database must store the details of all the userss and the car details and the users who rented the cars.
In this analysis phase only the designer will collect the information about the project. This is the first stage of the project. After this only the designer will start doing project that is the design of the project will carry after this stage. After that the designer will write the project coding and the designer will test the project. This phase will take the duration up to 1 to 2 weeks for completion of this analysis stage that is for collecting the requirements and it has to contain all the details about the project. In some projects it will take more time for completion of the analysis stage because it has to collect more requirements, it has to be depend upon the project it will take duration, hence for small type of projects the designer can easily complete the project within the short duration, for large projects it will take more duration for analysis stage and also for completion of the project. But for this project the designer can complete the project within the short duration because it is like a mini project and also the designer can complete the stage of analysis. If the designer has completed the stage of analysis then it appears like the designer completed the 25% of the project within the given duration.
3.2 Waterfall Systems Development Life Cycle model
In the project, the designer have used waterfall model. This model is used when requirements are well defined and reasonably stable, and in the project ‘Online Car Rental System’ all the requirements are well defined. The waterfall model, sometimes called the classic life cycle, suggests a systematic, sequential approach to software development that begins with customer specification of requirements and progresses through planning, modeling, construction and deployment, culminating in on-going support of the complete software.
The designer have defined activities and represented them into seperated process phases. All the stages overlap and fed information to each other. It is not a simple linear model but involves a sequence of iterations of development activities. This model is appropriate for the project as the designer had ample of time for designing it, so the time constraints were not there. This model
generally takes more time to complete the software life cycle as when a stage completes it is signed off and development goes onto the next stage.
The Waterfall SDLC steps are:
1. Analyse is the study the current system; determine if there is really a problem; determine if the problem can be fixed; determine if the problem is worth fixing; determine what the new or changed system should be able to achieve. Finish with a logical design. Details.
2. Design can be consider as alternative ways of solving the problem; plan what hardware, software, procedures and data need to be created, purchased or assembled. Design other key features such as documentation, training, testing, implementation and evaluation requirements. Finish with a physical design.
3. Develop refers to the writing of software, build the hardware, buy equipment, assemble components, formalise procedures of how the product should be used, perform ongoing informal component testing and integration testing. Write the documentation and training procedures. Finish with format testing, including acceptance testing.
4. Implement roll out the solution to its users using strategies such as direct, phased, parallel and/or pilot.
5. Evaluate is the review of the development process and the finished product to learn from mistakes and identify good practices. Ensure the finished product is performing as specified during the design phase.
3.3 Project Management
A cost benefit analysis is necessary to determine economic feasibility of the proposed system. The primary objective of cost benefit analysis is to find out whether it is economically worthwhile to invest in the project. If the return is good, then the project is considered economically worthwhile. Cost benefit analysis should be done before preparing the proposed system.
Cost benefit analysis is done for all the cost associated with the project. Conceptually, the cost of the project represents all the items of layout associated with the project which are associated with long term funds as well. It is sum of layout of the following:
Cost Cost per unit Quantity Total Cost Software Adobe Dreamweaver CS3 281.04 1 281.04 NuSphere PhpED 1249.20 1 1249.20 Windows Server 2003 452.83 1 452.83 Windows XP professional 218.61 4 874.44 Hardware Central Computer 780.75 1 780.75 Client Machine 452.83 4 1811.32 Development Analyst 1000 1 1000.00 Developer 400 2 400.00 Total Cost 6849.58
Cost benefit analysis table
3.4 Hardware and software specification
Before you install Adobe Dreamweaver CS3 and NuSphere PhpED, make sure that your computer meets the minimum requirements. To run both aplications, you must have certain hardware and software installed on your computer. The system requirements including
1. Operating System - Microsoft Windows 95 or later, or Microsoft Windows NT Workstation 4.0 (Service Pack 3 recommended) or later.
2. CPU - 486DX/66 MHz or higher processor (Pentium or higher processor recommended), or any Alpha processor running Microsoft Windows NT Workstation.
3. Disk Drives - A CD-ROM disc drive.
4. Monitor - VGA or higher-resolution screen supported by Microsoft Windows.
3.5 Operation assumptions
The Online Car Rental System automates the basic database functions to aid in the day-to-day operations of a system. It supports functions such as issue, return, the very basic functions of searching for a particular records, etc. It also maintains data about rentals, user records that are required during various library operations. The system aims to make the tasks user friendly and efficient.
The functions that the online car rental system provides are as follows:
• INSERT: This operation is performed when new data needs to be added to the system,
• DELETE: This operation clears the existing records in the various databases.
• UPDATE: This function updates data in the various records.
• SEARCH: This function is used to search particular data from the database.
• DISPLAY: This is used to display each and every record, i.e. record of every order in The Car rental system.
CHAPTER 4 DESIGN 4.1 Introduction
In this design stage the development team will design the project according to user satisfaction. In this design phase the user must understand the whole project by seeing the design of the project. After the completion of the analysis stage the user must design the project according to the collected requirements in the analysis stage. After the completion of the analysis stage the user must continue with the design stage.
In this project the user must create the database to store the details of users, available cars, and orders tables based upon collection of table requirements collected in the design stage. In these tables, one field has been given as primary key in the design of tables because it won’t allow the duplicate values of members or it won’t accept the same id number for different members.
that has been carried out, in that database it doesn’t have any keys in that because it can contain the details many users can take the book with same account number.
After creation of tables the user must design the project that is it can also represent the design in the form of Data Flow Diagrams. In the Data Flow diagrams it contains the levels that is it has to be represented in Level 0 DFD, Level 1 DFD, Level 2 DFD so that I can represent the Data flow diagrams in that format up to number of DFD’s required in the project.
The user must design or draw the DFD diagrams based upon the project what it will do, what are the operations that was carrying in the project it will represent the DFD diagrams in the one by one operation that was carrying in the project.
The user must understand the project what are all the operations in the project that was going to do or carrying out by seeing the DFD Diagrams. In that format the user must draw the DFD diagram. The DFD diagram must contain all the details of the project.
Library Management System User Library Inventory Item Account Info 1.Register() 2.Login() 3.Verifyuser() 15.Logout() 4.Search() 5.Retrieveiteminfo() 6.ShowDetailInfo() 7.Reserve() 8.Givefeedback() 9.Checkaccount() 10.Displayduedate 11.Calculatefine() 12.Renew() 13.Cancelhold() 14.Paybill() Book Sequence Diagram
Use Case Diagram
4.3 Database Design
The general theme behind a database is to handle information as an integrated whole. A database is a collection of interrelated data stored with minimum redundancy to serve many users quickly and effectively. After designing input and output, the analyst must concentrate on database design or how data should be organized around user requirements. The general objective is to make information access, easy quick, inexpensive and flexible for other users.
Field Name Data Type Size
ID AutoNumber Long Integer
Car model Text 50
Date Rented Date 50
Date Returned Date 50
Available cars table
Field Name Data Type Size
ID AutoNumber Long Integer
Car model Text 50
Date Rented Date 50
Date Returned Date 50
Unavailable cars table
Name Text Long Integer
Email Text Long Integer
Password Text Long Integer Information Text Long Integer
User Registration Table
Field Name Data Type Size
Id Autonumber Long Integer
Name Text Long Integer
Email Text Long Integer
Password Text Long Integer Information Text Long Integer
Admin Registration Table
Field Name Data Type Size
Id Autonumber Long Integer
Name Text Long Integer
Company Text Long Integer
Email Text Long Integer
Fax Number Long Integer Country of Origin Text
Pick Up Location Text Another Location Text Return Location Text Rental Dates: DD/MM/YYYY Date Pick-up time: HH:MM Date Return Date: DD/MM/YYYY Date Return time: HH:MM Date Vehicle Model: Text
Inquiry: Text
Rental Information table
4.4 Interface Design
User interface design is the design of Online Car Rental System with the focus on the user's experience and interaction. The goal of user interface design is to make the user's interaction as simple and efficient as possible, in terms of accomplishing user-centered design. Good user interface design facilitates finishing the task at hand without drawing unnecessary attention to itself.. Graphic design is utilized to support its usability. The design process is balanced technical functionality and visual elements to create the system that is not only operational but also usable and adaptable to changing user needs.
collection of input data is the most expensive part of the system. Three main objectives of the input design is to produce cost effective method of input, to achieve highest possible level of accuracy, and ensure that the input is acceptable to and understood by the staff.
The goal of designing input data is to make enter easy, logical and free from errors as possible. The entering data entry operators need to know the allocated space for each field; field sequence and which must match with that in the source document. The format in which the data fields are entered should be given in the input form .Here data entry is online; it makes use of processor that accepts commands and data from the operator through a key board. The input required is analyzed by the processor. It is then accepted or rejected.
Outputs from computer systems are required primarily to communicate the results of processing to users. They are also used to provide a permanent copy of these result for latter consultation .Computer output is the most important and direct source of information to the users. Designing computer output should proceed in an organized well throughout the manner. The right output must be available for the people who find the system easy to use. The outputs have been defined during the logical design stage. If not, they should defined at the beginning of the output designing terms of types of output connect, format, response etc., Various types of outputs are external outputs, Internal outputs, Operational outputs, Interactive outputs and turn around outputs. All screens are informative and interactive in such a way that the user can full fill his requirements through asking queries.
Homepage
In this page, the user will be given the instructions on how to navigate the website. Under the title “Please do the following first”, there are steps (step1-step6) that the user must follow in order to make the navigation easier. Words which are associated with the car rental procedures are hyperlinked and when clicked, the user will be redirected to the designated page. When the user is done with the corresponding page, the user will notice the “Home” button at the top of the page. There are other options available for the user such as Terms and Condition, Chat, Forums and etc.
Admin Registration Page
To register and set up as an admin, fill in the prefered username and password, complete the information within the form.
User Registration Page
To register and set up a user, fill in the prefered username and password, complete the information within the form.
Logging as administrator
A user must be an administrator in order to access the admin unit. Upon successful login, a login successful message is displayed and the user will be redirected to the main page.
Logging as user
A user must be a registered member in order to access the certain types of the feature that are in the web sites such as car availability, unavailability and invoice. Upon successful login, a login successful message is displayed and the user will be redirected to the main page.
Mainland Fleet Cars for Rent Page
Langkawi Fleet Cars For Rent Page
Self-Drive Rates Page
Renting and Reservation Locations Page List of renting and reservation locations.
Available Cars Details Page
This feature allows the user and the admin to access the database where the source of all the car availability information is displayed. The database will instantly provide a complete list of user with their details. This feature enables the admin to add/edit/delete car details in the database to be updated.
Un available Car Details Page
This feature allows the user and the admin to access the database where the source of all the unavailable car information is displayed. The database will instantly provide a complete list of unavailable car with their details. This feature enables the admin to add/edit/delete car details in the database to be updated.
User registration Details Page
This feature allows the user and the admin to access the database where the source of all the user registration information is displayed. The database will instantly provide a complete list of user registration with their details. This feature enables the admin to add/edit/delete user details in the database to be updated.
Admi n Registration Details Page
This feature allows the admin to access the database where the source of all the admin registration information is displayed. The database will instantly provide a complete list of admin registration with their details. This feature enables the admin to add/edit/delete admin details in the database to be updated.
Invoice Details Page
This feature allows the admin to access the database where the source of all the issued invoice information is displayed. The database will instantly provide a complete list of invoices with their details. This feature enables the admin to add/edit/delete invoice details in the database to be updated.
Rental form
Add your details, including an email address and other contact details. You must also agree to the site’s terms and conditions of use and our data protection policy – both of which are available from the registration page.
After the “submit” button is press upon the completion of filling the rental form, the copy of the rental form will be sent to the companies email ([email protected]).
5.1 Introduction
PHP: Hypertext Preprocessor is a widely used, general-purpose scripting language that was originally designed for web development to produce dynamic web pages. For this purpose, PHP code is embedded into the HTML source document and interpreted by a web server with a PHP processor module, which generates the web page document. As a general-purpose programming language, PHP code is processed by an interpreter application in command-line mode performing desired operating system operations and producing program output on its standard output channel. It may also function as a graphical application. PHP is available as a processor for most modern web servers and as a standalone interpreter on most operating systems and computing platforms.
JavaScript is an implementation of the ECMAScript language standard and is primarily used in the form of client-side JavaScript, implemented as part of a web browser in order to provide enhanced user interfaces and dynamic websites. This enables programmatic access to computational objects within a host environment. It can be characterized as a prototype-based object-oriented scripting language that is dynamic, weakly typed and has first-class functions. It is also considered a functional programming language like Scheme and OCaml because it has closures and supports higher-order functions.
JavaScript's use in applications outside web pages for example in PDF-documents, site-specific browsers and desktop widgets is also significant.JavaScript uses syntax influenced by that of C. JavaScript copies many names and naming conventions from Java, but the two languages are otherwise unrelated and have very different semantics. The key design principles within JavaScript are taken from the Self and Scheme programming languages.
HTML, which stands for HyperText Markup Language, is the predominant markup language for web pages. HTML is the basic building-blocks of webpages. A markup language is a set of markup tags, and HTML uses markup tags to describe web pages.HTML is written in the form of HTML elements consisting of tags, enclosed in angle brackets (like <html>), within the web page content. HTML tags normally come in pairs like <h1> and </h1>. The first tag in a pair is the start tag, the second tag is the end tag (they are also called opening tags and closing tags).
The purpose of a web browser is to read HTML documents and compose them into visual or audible web pages. The browser does not display the HTML tags, but uses the tags to interpret the content of the page. HTML elements form the building blocks of all websites. HTML allows images and objects to be embedded and can be used to create interactive forms. It provides a means to create structured documents by denoting structural semantics for text such as headings, paragraphs, lists, links, quotes and other items. It can embed scripts in languages such as JavaScript which affect the behavior of HTML webpages.
Web browsers can also refer to Cascading Style Sheets (CSS) to define the appearance and layout of text and other material. The W3C, maintainer of both the HTML and the CSS standards, encourages the use of CSS over explicitly presentational HTML markup.
XHTML (eXtensible HyperText Markup Language) is a family of XML markup languages that mirror or extend versions of the widely used Hypertext Markup Language (HTML), the language in which web pages are written. While HTML (prior to HTML5) was defined as an application of Standard Generalized Markup Language (SGML), a very flexible markup language framework, XHTML is an application of XML, a more restrictive subset of SGML. Because XHTML documents need to be well-formed, they can be parsed using standard XML parsers—unlike HTML, which requires a lenient HTML-specific parser. XHTML 1.0 became a World Wide Web Consortium (W3C) Recommendation on January 26, 2000. XHTML 1.1 became a W3C Recommendation on May 31, 2001. XHTML5 is undergoing development as of September 2009, as part of the HTML5 specification.
5.2 Code for each function
For the purpose of this project only three units are included in the Library management software. They are - Administration, Circulation and Technical unit. The top down design breaks down the whole project into tasks, which are also broken into subtasks. This results into hierarchy of tasks. The main can therefore be presented in a multilevel form:
Functi on
Coding PSEUDOCODE
User
login $myusername=$_POST['myusername']; $mypassword=$_POST['mypassword']; // To protect MySQL injection
$myusername = stripslashes($myusername); $mypassword = stripslashes($mypassword); $myusername = mysql_real_escape_string($myusername); $mypassword = mysql_real_escape_string($mypassword); $sql="SELECT * FROM $tbl_name WHERE username='$myusername' and
password='$mypassword'"; $result=mysql_query($sql);
View total number of users
Obtain all records in tblUsers
Set count = 0 WHERE not EOF recordset Count = count + 1 Loop Admin login $myusername=$_POST['myusernam e']; $mypassword=$_POST['mypassword '];
// To protect MySQL injection $myusername = stripslashes($myusername); $mypassword = stripslashes($mypassword); $myusername = mysql_real_escape_string($myusern ame); $mypassword =
View total number of admin
Obtain all records in tblUsers
Set count = 0 WHERE not EOF recordset
Count = count + 1 Loop
mysql_real_escape_string($mypassw ord);
$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'"; $result=mysql_query($sql); Technical Functi on Coding PSEUDOCODE Send Input To databas e <script type="text/javascript"> var _yts = _yts || []; _yts.push(["_siteId", "8a4986cb2def55e5012df0c297b01719"]); _yts.push(["_trackPageview"]); (function() { var yts = document.createElement("script"); yts.type = "text/javascript"; yts.async = true; yts.src = "http://analytics.yola.net/tracking.js"; (document.getElementsByTagName(" head")[0] || document.getElementsByTagName("body") [0]).appendChild(yts); })();
</script><!-- Start Quantcast tag --> <script type="text/javascript" src="http://edge.quantserve.com/quant.js"></s cript> <script type="text/javascript">_qacct="p-b8x17GqsQ_656";quantserve();</script> <noscript> <a SEND dataINTO tracking.js Send to database INSERT register INTO tracking.js
b8x17GqsQ_656.gif" style="display: none;" border="0" height="1" width="1"
alt="Quantcast"/></a> </noscript> Registration Unit Functi on Coding PSEUDOCODE Registe r user <script type="text/javascript"> var _yts = _yts || [];
_yts.push(["_siteId", "8a4986cb2def55e5012df0c297b01 719"]); _yts.push(["_trackPageview"]); (function() { var yts = document.createElement("script"); yts.type = "text/javascript"; yts.async = true; yts.src = "http://analytics.yola.net/tracking.js" ; (document.getElementsByTa gName("head")[0] || document.getElementsByTagName( Register Users Obtain User information-name, address, email, phone, next of kin etc,
AddNew user INSERT tblUser
"body")[0]).appendChild(yts); })();
</script><!-- Start Quantcast tag --> <script type="text/javascript" src="get-a-quote.php_files/quant.js"></script> <script type="text/javascript">_qacct="p-b8x17GqsQ_656";quantserve();</scr ipt> <noscript> <a href="http://www.quantcast.com/p-b8x17GqsQ_656" target="_blank"><img src="http://pixel.quantserve.com/pix el/p-b8x17GqsQ_656.gif"
style="display: none;" border="0" height="1" width="1" alt="Quantcast"/></a> </noscript> Select and display <select id="yola_form_widget_I28_10" name="10<list>"> Display Inforfation Get the id of record to return
value="Penang Head Office (Bayan Lepas)">Penang Head Office (Bayan Lepas)</option>
<o ption value="Penang Batu Ferringhi Office">Penang Batu Ferringhi Office</option>
<o ption value="Penang Georgetown Rental Counter">Penang
Georgetown Rental Counter</option>
<o ption value="Penang International Airport">Penang International Airport</option>
<o ption value="KLIA - Arrival Hall Main Terminal Building">KLIA - Arrival Hall Main Terminal
Building</option>
<o ption value="KLIA - Covered Car Park">KLIA - Covered Car
Park</option>
<o
If record id = id then SELECT returned
ption value="LCCT - Meet Confirmed Reservations">LCCT - Meet
Confirmed Reservations</option>
<o ption value="Langkawi Branch Office">Langkawi Branch Office</option>
<o ption value="Langkawi Airport - Meet Confirmed
Reservations">Langkawi Airport - Meet Confirmed
Reservations</option>
<o ption value="Langkawi Jetty - Meet Confirmed Reservations">Langkawi Jetty - Meet Confirmed
Reservations</option>
<o ption value="The Datai,
Langkawi">The Datai, Langkawi</option>
<o ption value="The Andaman,
<o ption value="Four Seasons,
Langkawi">Four Seasons, Langkawi</option>
</select >
CHAPTER 6
TESTING AND IMPLEMENTATION
6.1 Introduction
The Testing and implementation is actually concerned with the development of software. It includes operations such as programming, testing and integration of modules into a more progressively complete system. Acceptance generation test generates a set of test data, which can be used to test the new system before accepting information technology. Acceptance testing requires, as its input, acceptance test data generated in acceptance test generation and an integrated system produced by implementation.
The code is tested at various levels in software testing. Unit, system and user acceptance testing are often performed. This is a grey area as many different opinions exist as to what the stages of testing are and how much if any iteration occurs. Iteration is not generally part of the waterfall model, but usually some occur at this stage. In the testing the whole system is test one by one
Modular and subsystem programming code will be accomplished during the implementation stage. Unit testing is done in this stage by the developers. This stage is intermingled with the next in that individual modules will need testing before integration to the main project.
6.2 Testing
Testing is a process of executing a program with the intent of finding an error. A good test case is one that has a high probability of finding an as-yet-undiscovered error. A successful test is one that uncovers an as-yet-undiscovered error.
Once source code has been generated, software must be tested to uncover (and correct) as many errors as possible before delivery to customer. Our goal is to design a series of test cases that have a high likelihood of finding errors. To uncover the errors software techniques are used. These techniques provide systematic guidance for designing test that exercise the internal logic of software components, and exercise the input and output domains of the program to uncover errors in program function, behavior and performance.
A strategy for system testing must accommodate low-level tests that are necessary to verify that a small source code segment has been correctly implemented as well as high-level tests that validate major system functions against customer requirements. The steps of the test strategy occur at a time when deadline pressure begins to rise, progress must be measurable and problems must surface as early as possible. Unit testing techniques are the strategy adopted during this project testing.
Unit testing focuses verification effort on the smallest unit of software design- the software component or module. The unit test is white-box oriented. The module interface is tested to ensure that information properly flows into and of the program unit under test the local
module operated properly at boundaries established to limit or restrict processing. All independent paths through the control structure are exercised to ensure that all statements in a module haven executed at least once.
Test Case ID Login
Test Case
Description
To interact with the system, CRS will validate its registration with this system. It also defines the actions a user can perform in CRS
Input Data Enter user name and password
Expected Result System transfer control to user main screen to proceed further actions
Actual Result Actual Results match Expected Results
Pass/Fail pass
Remarks no
Test case login table Test Case ID Register new user
Test Case
Description
To register applicants system will issue new user
Input Data User enters applicant code to register Expected Result Application will become register user Actual Result Actual Results match Expected Results
Pass/Fail pass
Remarks no
Test Case ID Make rental order
Test Case
Description
When the registered user is issued the rental, then the process from the category can be entered into its record.
Input Data Additional login from the user is required Expected Result System will mark this segment as rental Actual Result Actual Results match Expected Results
Pass/Fail Pass
Remarks No
Test case make rental order table
Test Case ID Send Form
Test Case
Description
When a user is presses the submit button from the rental form
Input Data Press the submit button at the bottom of the form
Expected Result System will Send to the users email account Actual Result Actual Results match Expected Results
Pass/Fail Pass
Remarks No
Test case send form table Test Case ID Inquiry user
Test Case
Description
Inquire any users exist in CRS; Administrator can view information about the user.
Pass/Fail Pass
Remarks No
Test case Inquiry user table
Test Case ID Inquiry Rental records
Test Case
Description
Get the rental records from the database
Input Data Admin ID: kifliman
Expected Result User will get all the information of records in CRS.
Actual Result Actual Results match Expected Results
Pass/Fail Pass
Remarks No
Test case inquiry rental records table
Test Case ID Search cars
Test Case
Description
Search makes it easy to search for cars on CRS. With this search companion, user can specify several search criteria.
Input Data User enter required information by Id, User Name and password
Expected Result User can view his desire results
Actual Result Actual Results match Expected Results
Pass/Fail Pass
Remarks No
6.3 Implement
Implementation is the stage in the project where the theoretical design is turned into a working system. The implementation phase constructs, installs and operates the new system. The most crucial stage in achieving a new successful system is that it will work efficiently and effectively. There are several activities involved while implementing a new project they are
End user Training:
The successful implementation of the new system will purely upon the involvement of the officers working in that department. The officers will be imparted the necessary training on the new technology.
End User Education:
The education of the end user start after the implementation and testing is over. When the system is found to be more difficult to understand and complex, more effort is put to educate the end used to make them aware of the system, giving them lectures about the new system and providing them necessary documents and materials about how the system can do this.
Training of system:
After providing the necessary basic training on the computer awareness, the users will have to be trained upon the new system such as the screen flows and screen design type of help on the screen, type of errors while entering the data, the corresponding validation check at each entry and the way to correct the data entered. It should then cover information needed by the specific user or group to use the system.
The department is planning a method to know the states of the past implementation process. For that regular meeting will be arranged by the concerned officers about the implementation problem and success
CHAPTER 7
CONCLUSION AND RECOMMENDATION
7.1 Introduction
Review of objectives ensures that everything is in place and that if the developer does not reach the goals they cannot consider being achievable and reasonable. A developer may not be able to achieve it for various reasons, including a lack of skill, not having enough resources (computers, tools, etc.), not having access to key people and not having management support.
As the use of computers and other technologies continue to be used to enhance services provided by a variety of industries, information providers, like car rentals, are also automating resources. There are many benefits to automating the information available in car rental, both for the staff and users alike. The limitations are needed to be concerned in order to avoid using resource in the Online Car Rental System for future enhancement.
7.2 Review of Objectives
The software will be able to perform the following task such as get, store and manage information from lessees/renters. This system allows adding members in the system. The user are able to store at least the basic information attributes including Name, Address, Email, Sex, and email can be an generated.
7.3 Advantages and disadvantages of Online Car Rental System
The only area where substantial manpower can be saved is the registration. The data entered at the time of ordering can be used for cataloguing with some updating would eliminate multiple card preparation and subsequent filing. Therefore it conserves space and saves stationary.
When developing the Online Car Rental System, the developer emphasizes an easy-to-use User Interface which is the key to sustain the system. With a simple UI, the administrator or user don't have to rely on IT help to navigate and operate the functions found in the system.
The users can have simultaneous access to the same database containing the rental orders and car availability. Automatically build and maintain fast access files for each database in order to maximize retrieval speed.
With the implementation of the system, more capacity storage enables to quickly process, store, send and retrieve information is causing the current information delivery services to flourish.
7.4 Limitations of Online Car Rental System
This project made me go through various ups and downs in the making of a project. I got an idea about the problems encountered in the analysis, coding, debugging and testing. They have tried to restrict these problems to a certain limit and have tried to make the project more users friendly and easily accessible.
The developer of project try their best to make a powerful and effective package, sometimes it get full success on its aim but mostly there is a possibility to left some limitation in the package. This package is developed for managing a Online Car Rental System and it has successfully runs on including points.
Only few points are not covered by this package due to the less time of working and such points are out of knowledge of its developer, but the every parts are included in this project is enough to efficiently use on the system.
Nevertheless, the user should benefit enormously from the automating management processes of Online Car Rental System. Also, the probability of error should reduce significantly. The time thus saved and instant access to key management information should help the user allocates resources better and exercise better management of Library. The project makes a small beginning with a small venture into the field of library. It will be our endeavors to pursue the project further and develop newer application from it, offering an enhanced product.
7.5 Conclusion of the project
After we have completed the project we are sure the problems in the existing system would overcome. The “Online Car Rental System” process made computerized to reduce human errors and to increase the efficiency. The main focus of this project is to lessen human efforts. The maintenance of the records is made efficient, as all the records are stored in the database,
