web based booking a car taxi5
TRANSCRIPT
1. INTRODUCTION
1.1 PROBLEM DESCRIPTION
This project provides the management to maintain the details like the driver,
vehicle, bill in the booking system. At present all the details are carried out manually. This
project is developed to computerize those details. This system includes number of activities
and admin has to maintain and update all the details such as vehicle details, driver, and the
details. It is easy to maintain and update all the information by making the process
systematically.
Admin also manages the driver details and salary for particular driver
according to their type of work. In vehicle details, it includes the information such as vehicle
id, vehicle name, register number, number of seats available in the vehicle, vehicle type and
insurance number of the vehicle. The driver details includes driver id, driver name, license
number, address, date of joining, phone number to contact them and salary. These details are
periodically updates in the system.
The project consists of following modules,
Admin
Customer
Reports
Admin
This module maintains the details of the Vehicle, Driver and Bills which reduces the
complexity in maintaining and human work in driver allocation and vehicle allocation for
booking. It maintains bills of the customers.
ONLINE TAXI BOOKING Page 1
Vehicle details
Driver details
Vehicle tariff
Bills
Customer
In this module, it maintains the details about the registration and booking of the
customer. It maintains customer name, address, contact number and email id.
Customer Registration
Customer Booking
Reports
This group of functionality causes queries to be invoked on the CAR Database in order
to generate various Reports such as
Vehicle Detail Report
Driver Detail Report
Customer Details Report
Booking Report
Bill Report
ONLINE TAXI BOOKING Page 2
1.2 SYSTEM ENVIRONMENT
1.2.1HARDWARE SPECIFICATION
This section gives the details and specification of the hardware on which system is
expected to work.
Processor : AMD A4-330 MX APU
Main memory : 512 MB
Hard disk capacity : 160GB
Keyboard : 101keys
Monitor : VGA with resolution
Printer : Dot Matrix Printer
1.2.2 SOFTWARE SPECIFICATION
This section gives the details and specification of the software on which system is
expected to work.
Operating system : windows 7
Coding language : visual basic
Web technology : Asp.Net
Front End : Microsoft Visual Studio.Net2005
Back End : Microsoft sql server2005
ONLINE TAXI BOOKING Page 3
1.3 SOFTWARE DESCRIPTION
.NET
The .NET Framework is a new computing platform that simplifies application development
in the highly distributed environment of the Internet. The .NET Framework is designed to fulfill the
following objectives:
To provide a consistent object-oriented programming environment whether object code is
stored and executed locally, executed locally but Internet-distributed, or executed remotely.
.NET SERVICES
The .NET Framework has two main components: the common language runtime and
the .NET Framework class library. The common language runtime is the foundation of the .NET
Framework. You can think of the runtime as an agent that manages code at execution time,
providing core services such as memory management, thread management, and Removing, while
also enforcing strict type safety and other forms of code accuracy that ensure security and
robustness. In fact, the concept of code management is a fundamental principle of the runtime. Code
that targets the runtime is known as managed code, while code that does not target the runtime is
known as unmanaged code. The class library, the other main component of the .NET Framework, is
a comprehensive, object-oriented collection of reusable types that you can use to develop
applications ranging from traditional command-line or graphical user interface (GUI) applications to
applications based on the latest innovations provided by ASP.NET, such as Web Forms and XML
Web services.
Internet Explorer is an example of an unmanaged application that hosts the runtime (in
the form of a MIME type extension). Using Internet Explorer to host the runtime enables you to
embed managed components or Windows Forms controls in HTML documents. Hosting the runtime
in this way makes managed mobile code (similar to Microsoft® ActiveX® controls) possible, but
with significant
ONLINE TAXI BOOKING Page 4
FEATURES OF THE COMMON LANGUAGE RUNTIME
The common language runtime manages memory, thread execution, code execution, code
safety verification, compilation, and other system services. These features are intrinsic to the
managed code that runs on the common language runtime.
With regards to security, managed components are awarded varying degrees of trust,
depending on a number of factors that include their origin (such as the Internet, enterprise network,
or local computer). This means that a managed component might or might not be able to perform
file-access operations, registry-access operations, or other sensitive functions, even if it is being used
in the same active application.
The runtime enforces code access security. For example, users can trust that an executable
embedded in a Web page can play an animation on screen or sing a song, but cannot access their
personal data, file system, or network. The security features of the runtime thus enable legitimate
Internet-deployed software to be exceptionally featuring rich.
The runtime also enforces code robustness by implementing a strict type- and code-
verification infrastructure called the common type system (CTS). The CTS ensures that all managed
code is self-describing. The various Microsoft and third-party language compilers
Generate managed code that conforms to the CTS. This means that managed code can
consume other managed types and instances, while strictly enforcing type fidelity and type safety.
ASP.NET
Server Application Development
Server-side applications in the managed world are implemented through runtime hosts.
Unmanaged applications host the common language runtime, which allows your custom managed
code to control the behaviour of the server. This model provides you with all the features of the
common language runtime and class library while gaining the performance and scalability of the
host server.
ONLINE TAXI BOOKING Page 5
The following illustration shows a basic network schema with managed code running in
different server environments. Servers such as IIS and SQL Server can perform standard operations
while your application logic executes through the managed code.
SERVER-SIDE MANAGED CODE
ASP.NET is the hosting environment that enables developers to use the .NET Framework to
target Web-based applications. However, ASP.NET is more than just a runtime host; it is a complete
architecture for developing Web sites and Internet-distributed objects using managed code. Both
Web Forms and XML Web services use IIS and ASP.NET as the publishing mechanism for
applications, and both have a collection of supporting classes in the .NET Framework.
ACTIVE SERVER PAGES.NET
ASP.NET is a programming framework built on the common language runtime that can be
used on a server to build powerful Web applications. ASP.NET offers several important advantages
over previous Web development models:
Enhanced Performance. ASP.NET is compiled common language runtime code running on
the server. Unlike its interpreted predecessors, ASP.NET can take advantage of early binding, just-
in-time compilation, native optimization, and caching services right out of the box. This amounts to
dramatically better performance before you ever write a line of code.
INTRODUCTION TO ASP.NET SERVER CONTROLS
In addition to (or instead of) using <% %> code blocks to program dynamic content,
ASP.NET page developers can use ASP.NET server controls to program Web pages. Server controls
are declared within an .aspx file using custom tags or intrinsic HTML tags that contain a
runat="server" attributes value. Intrinsic HTML tags are handled by one of the controls in the
System.Web.UI.HtmlControls namespace. Any tag that doesn't explicitly map to one of the controls
is assigned the type of System.Web.UI.HtmlControls.HtmlGenericControl.
ONLINE TAXI BOOKING Page 6
Server controls automatically maintain any client-entered values between round trips to the
server. This control state is not stored on the server (it is instead stored within an <input
type="hidden"> form field that is round-tripped between requests). Note also that no client-side
script is required.
SQL SERVER
A database management, or DBMS, gives the user access to their data and helps them
transform the data into information. Such database management systems include dBase, paradox,
IMS, SQL Server and SQL Server. These systems allow users to create, update and extract
information from their database.
A database is a structured collection of data. Data refers to the characteristics of people,
things and events. SQL Server stores each data item in its own fields. In SQL Server, the fields
relating to a particular person, thing or event are bundled together to form a single complete unit of
data, called a record (it can also be referred to as raw or an occurrence). Each record is made up of a
number of fields. No two fields in a record can have the same field name.
During an SQL Server Database design project, the analysis of your business needs identifies
all the fields or attributes of interest. If your business needs change over time, you define any
additional fields or change the definition of existing fields.
SQL SERVER TABLES
SQL Server stores records relating to each other in a table. Different tables are created for
the various groups of information. Related tables are grouped together to form a database.
PRIMARY KEY
Every table in SQL Server has a field or a combination of fields that uniquely identifies each
record in the table. The Unique identifier is called the Primary Key, or simply the Key. The primary
key provides the means to distinguish one record from all other in a table. It allows the user and the
database system to identify, locate and refer to one particular record in the database.
ONLINE TAXI BOOKING Page 7
RELATIONAL DATABASE
Sometimes all the information of interest to a business operation can be stored in one table.
SQL Server makes it very easy to link the data in multiple tables. Matching an employee to the
department in which they work is one example. This is what makes SQL Server a relational
database management system, or RDBMS. It stores data in two or more tables and enables you to
define relationships between the table and enables you to define relationships between the tables.
FOREIGN KEY
When a field is one table matches the primary key of another field is referred to as a foreign
key. A foreign key is a field or a group of fields in one table whose values match those of the
primary key of another table.
REFERENTIAL INTEGRITY
Not only does SQL Server allow you to link multiple tables, it also maintains consistency
between them. Ensuring that the data among related tables is correctly matched is referred to as
maintaining referential integrity.
FEATURES OF SQL SERVER
SQL SERVER is one of the leading database management systems (DBMS) because it is the
only Database that meets the uncompromising requirements of today’s most demanding information
systems. From complex decision support systems (DSS) to the most rigorous online transaction
processing (OLTP) application, Even application that require simultaneous DSS and OLTP access to
the same critical data, SQL Server leads the industry in both performance and capability
SQL SERVER is a truly portable, distributed, and open DBMS that delivers unmatched
performance, continuous operation and support for every database.
SQL SERVER RDBMS is high performance fault tolerant DBMS which is specially
designed for online transactions processing and for handling large database application.
ONLINE TAXI BOOKING Page 8
2. SYSTEM ANALYSIS
2.1 EXISTING SYSTEM
In the existing system, all the details of the customers , drivers and vehicles are maintained
manually. Sometimes there may be chance to loss the data maintained by the admin. It is not easy to
maintain and update the details periodically.
DRAWBACK OF THE EXISTING SYSTEM
Online booking is not possible.
Time delay.
There is a chance to loss the data.
2.2NEED FOR PROPOSED SYSTEM It will save the time of customer, and gives the satisfaction to them.
Employee will enter information to the database so that they can retrieve the detail
easily.
This car taxi system completely based on online & atomized.
Data is completely is secured by data integrity.
It also minimizes the errors in the data entry by using validation control.
2.3 PROPOSED SYSTEM
This proposed system overcomes the disadvantages of the existing system and implements
the efficiency of the car booking services which contains the facility of customer detail, car booking
ONLINE TAXI BOOKING Page 9
automation, driver details, vehicle details and bills. Other advantage of the system is that the vehicle
tariff is possible in this system.
ADVANTAGES OF THE PROPOSED SYSTEM
Online booking facilitates the user to reduce time consumption in booking the car.
Contracted Customer Facility reduces the operational cost for the organizations that are
sending bulk couriers weekly or monthly or daily.
Analytical reports generated are useful in making business decisions to reduce the
operation cost for car booking company.
ONLINE TAXI BOOKING Page 10
3. SYSTEM DESGIN
3.1 DATA FLOW DIAGRAM
Level 0:
customer
ONLINE TAXI BOOKING Page 11
Level 1:
Report
3.2 DATABASE DESIGN
TABLE NAME : Register
ONLINE TAXI BOOKING Page 12
PRIMARY KEY : cid
DESCRIPTION : customer fills this form for registration
FIELDNAME DATATYPE DESCRIPTION
Cid Varchar(50) Customer id
Cname Varchar(50) Customer nameAddress Varchar(50) Customer address
Con. no Varchar(50) Contact number
Gender Varchar(50) Gender of the customerEmail Varchar(50) Customer email id
pwd Varchar(50) Password
TABLE NAME : Booking
FOREGIN KEY : Cid
DESCRIPTION : Customer fills this form for booking
FIELDNAME DATATYPE DESCRIPTION
Cid Varchar(50) Customer id
Cname Varchar(50) Customer name
Vehicle Varchar(50) Vehicle
date Varchar(50) Date of booking
time Varchar(50) Time of resversation
TABLE NAME: Billing
PRIMARY KEY: Cid
DESCRIPTION: This table provides the information about route and cost
ONLINE TAXI BOOKING Page 13
FIELDNAME DATATYPE DESCRIPTION
Cid Varchar(50) Customer idCname Varchar(50) Customer namecon.no Int Contact numberW time Int Waiting timeEkm’s Varchar(50) Extra km’sVehicle Varchar(50) Vehicle name Vid Varchar(50) Vehicle idDname Int Driver nameAmt Varchar(50) amount
TABLE NAME: Driver
PRIMARY KEY: Did
DESCRIPTION: This table provides the information about driver
FIELDNAME DATATYPE DESCRIPTION
Did Varchar(50) Driver idDname Varchar(50) Driver nameDlno Varchar(50) Driver License NumberDaddress Varchar(50) Driver AddressJoiningdate Varchar(50) Date of Joiningcon.no Int contact NumberDsalary Varchar(50) Driver salary
TABLE NAME: Vehicle
PRIMARY KEY: Vid
DESCRIPTION: This table provides the information about vehicle
ONLINE TAXI BOOKING Page 14
FIELDNAME DATATYPE DESCRIPTIONVid Varchar(50) Vehicle idVname Varchar(50) Vehicle name
Vregno Varchar(50) Vehicle Registration NumberTseats Varchar(50) Total number of seatsVtype Varchar(50) Vehicle TypeInno Varchar(50) Insurance Number
3.3 INPUT DESIGN
Input design is one of the most important phases of the system design. Input design
is the process where the input received in the system are planned and designed, so as to get
ONLINE TAXI BOOKING Page 15
necessary information from the user, eliminating the information that is not required. The
goal of the input design is to make the data entry logical & free from errors. Errors in the
input database controlled by input design. This application is being developed in a user-
friendly manner.
In car booking system the forms are being designed in such a way that during the
processing the cursor is placed in the position where the data must be entered. An option of
selecting an appropriate input from the values of validation is made for each of every data
entered.
This project consists of the following forms,
Customer details
This form is used to enter the customer details such as customer id, customer name,
age, sex, contact no, address, email id and password are enter the corresponding text box
control and stored in the table of the database. (Refer Fig A.3).
Booking details
This form is used to enter the booking details such as customer id, customer name,
vehicle, date, and time are enter the corresponding text box control and stored in the table of
the database. (Refer Fig A.4).
Driver details
This form is used to enter the driver details such as driver id, driver name, contact no,
address, license no, date of joining are enter the corresponding text box control and stored in
the table of the database. (Refer Fig A.8).
ONLINE TAXI BOOKING Page 16
Vehicle details
This form is used to enter the vehicle details such as vehicle id, vehicle type, vehicle
register no, vehicle license no, no of seating, a/c, insurances no are enter the corresponding
text box control and stored in the table of the database. (Refer Fig A.9).
Billing detail
This form is used to enter the billing details such as customer id, customer name,
contact no, driver name, total meter, waiting hours, vehicle type, vehicle no and amount are
enter the corresponding text box control and stored in the table of the database. (Refer Fig
A.10).
3.4 OUTPUT DESIGN
Computer output is the most important direct source of information to the user. Output computer or required primarily to communicate the results of the processing to the users. They also used to provide permanent copy of these results for rate references. Thus it is designed in a user-friendly way to avoid user burden.
ONLINE TAXI BOOKING Page 17
The output design refers to the result and information that it’s generated by the system forms many end users. To produce the output which are displayed in a screen, efficient and intelligent output design improves the system relationship with the users and help indecision making. The output of the delivery is in the form grid view report.
Vehicle Details Report
Vehicle Details provides the details like Vehicle ID, Vehicle Type, Registration Number, Vehicle License Number, Number of seating, A/C, Insurance Number. (Refer Fig A.12)
Driver Details Report
Driver Details provides the details like Driver id, Driver License Number, Driver Address, Joining of seats, and contact number. (Refer Fig A.13)
Customer Details Report
Customer Detail provides the details like customer id, customer name, age, sex, contact number, address, email id and password. (Refer Fig A.14)
Booking Details Report
Booking Detail provides the details like customer id, customer name, vehicle, date, and time. (Refer Fig A.15)
Bill Report
Bill provides the details like customer id, customer name, contact no, driver name, total meter, waiting hours, vehicle type, vehicle number and amount. (Refer Fig A.16)
4. SYSTEM TESTING AND IMPLIMENTATION
4.1 SYSTEM TESTING
ONLINE TAXI BOOKING Page 18
The purpose testing is to discover errors. Testing is the process of trying to discover every
conceivable fault or components, subassemblies, assemblies and/or a finished product.
It is the process of executing software with the ensuring that the software system meets its
requirements and user expectation and does not fail in an unacceptable manner. There are various
types of tests. Each test type address a specific testing requirement.
TYPES OF TESTING
Unit testing
Unit testing verification efforts on the smallest unit of software design module. This is
known as “Module Testing”. The modules are tested separately. This testing is carried out during
programming stage itself. In these testing steps, each module is found to be working satisfactorily as
regard to the expected output from the module.
In this project, all modules are testing individually like given all the fields and can be
updated for all criteria.
Integration Testing
Integration testing is designed to test all the modules which are integrated using software
components to determine if they actually run as one program. Testing is event driven and is more
concerned with the basic outcome of screens or fields.
Integration tests demonstrate that although the components were individually satisfaction, as
shown by successfully unit testing, the combination of components is correct and consistent.
Integration testing is specifically aimed at exposing the problem that arises from the combination of
components. In the project, after integration the all modules like user registration, LLR, renewal are
tested with their integration and that could integrated and manipulated
Validation Testing
ONLINE TAXI BOOKING Page 19
It is said that validation is successful when the software function in a systematic manner
that can be reasonably accepted by the customer. This type of testing is very important because it is
the only way to check whether the requirements given by user have been completely fulfilled.
The input given to various forms are validated effectively. The input is given by the user.
Each module is tested independently. User enters the appropriate data and results was checked and
validated.
Features to be tested
Verify that the entries are of the correct format
No duplication entries should be allowed
All links should take the user to the correct page
4.2 SYSTEM IMPLEMENTATION
The purpose of System Implementation can be summarized as follows:
It makes the new system available to a prepared set of users and positioning on-going support
and maintenance of the system within the performing organization. At a finer level of detail,
deploying the system consists of executing all steps necessary to educate the Consumers on the use
of the new system, placing the newly developed system into production, confirming that all data
required at the start of operation is available and accurate, and validating that business function that
interact with the system are functioning properly.
Transitioning the system support responsibility involves changing from a system
development to a system support and maintenance mode of operation, with ownership of the new
system moving from the project team to the performing organization.
System implementation is the important stage of project when the theoretical design is tuned
into practical system. The main stages in the implementation are as follow:
Planning
Training
ONLINE TAXI BOOKING Page 20
System testing and
Changeover Planning
Planning is the first task in the system implementation. Planning means deciding on the
method and the time scale to be adopted. At the time of implementation of any system people from
different departments and system analysis involve. They are confirmed to practical problem of
controlling various activities of people outside their own data processing departments. The line
managers controlled through an implementation coordinating committee. The committee considers
ideas, problems and complaints of user department, it must also consider:
The implementation of system environment
Self selection and allocation from implementation tasks
Consultation with unions and resources available
Standby facilities and channels of communication
Because of these and other impacts, the communication of planned deployment activities to
all parties involved in the project is critical. A smooth deployment requires strong leadership,
planning and communications. By this point in the project lifecycle, the team will have spent
countless hours devising and refining the steps to be followed. During this preparation process the
Project Manager must verify that all conditions that must be met prior to initiating deployment
activities have been met, and that the final ’green light’ is on for the team to proceed. The final
process within the System Development Lifecycle is to transition ownership of the system support
responsibilities to the Performing Organization. In order for there to be an efficient and effective
transition, the Project Manager should make sure that all involved parties are aware of the transition
plan, the timing of the various transition activities, and their role in its execution.
CONCLUSION
The present System can be made easier and simpler by developing in Visual basic and with Date
Reports for Web Based Booking A Car Taxi. It reduces date redundancy and improving data consistency and
it also establishes the data integration, developing a speedy, error free and flexible system.
ONLINE TAXI BOOKING Page 21
It concluded that the web based booking a car taxi works well. This application is tested very well
and errors are properly debugged. This project is simultaneously accessed by different users. The users access
the car through login and edit details in the database.
The main aim of computerization is achievement perfection in every operation. Now the new
coming language and packages make program writing much easier and the programmers are enjoying with
writing the application programs.
The computerization becomes essential to attain perfection and to save the time. This system is very
friendly not have expertise in using computers and package already to run this system.
The report generation involves no manual calculation. Thus the application reduce the difficulties in
web based booking a car taxi.
ONLINE TAXI BOOKING Page 22
SCOPE FOR FUTURE ENHANCEMENTS
Every system should allow scope for further development or enhancement. The system is
developed to incorporate all the current requirements in future, the system can be enhanced to
provide more functionality.
In Online Taxi Booking details are maintained manually, instead entire application are
carried out as software. The application is designed such that those enhancements can be integrated
with current modules easily with integrated work.
Now Payments for bills are paid manually. In future payments for bills are paid through
internet also.
ONLINE TAXI BOOKING Page 23
BIBLIOGRAPHY
BOOK REFERENCES
1. Jittery R.Shapiro, “ The complete Reference Visual Basic .NET”, Edition 2002, Tata
McGraw-Hill, Publising Company Limited, New Delhi
2. Matti J.Couch, “ASP.NET and VB.NET Programming”,Pearson Education.
3. Robert D.Schneider, Jetty R.Garbus,”Optimiztion SQL Server”, Second Edition,
Perasons Education Asia, ISBN: 981-4035-29-3
4. Vikas Kupta, “.Net Programming”, Dreamtech press.
WEB REFERENCES
1. http://1000projects.com
2. http://www.vbdotnetheavan.com
3. http://dotnettips.com
4. http://www.codeproject.com
5. http://www.programmersheaven.com
ONLINE TAXI BOOKING Page 24
APPENDIX
HOME PAGE
Fig A.1
ONLINE TAXI BOOKING Page 25
CUSTOMER LOGIN
Fig A.2
ONLINE TAXI BOOKING Page 26
CUSTOMER REGISTRATION
Fig A.3
ONLINE TAXI BOOKING Page 27
CUSTOMER BOOKING
Fig A.4
ONLINE TAXI BOOKING Page 28
BOOKING CONFIRMATION
Fig A.5
ONLINE TAXI BOOKING Page 29
ADMINISTRATION LOGIN
Fig A.6
ONLINE TAXI BOOKING Page 30
ADMINISTRATION FORM
Fig A.7
ONLINE TAXI BOOKING Page 31
VEHICLE DETAIL
Fig A.8
ONLINE TAXI BOOKING Page 32
DRIVER DETAIL
Fig A.9
ONLINE TAXI BOOKING Page 33
BILL
Fig A.10
ONLINE TAXI BOOKING Page 34
VEHICLE TARIFF
Fig A.11
ONLINE TAXI BOOKING Page 35
VEHICLE DETAIL REPORT
Fig A.12
ONLINE TAXI BOOKING Page 36
DRIVER DETAILS REPORT
Fig A.13
ONLINE TAXI BOOKING Page 37
CUSTOMER REGISTRATION REPORT
Fig A.14
ONLINE TAXI BOOKING Page 38
CUSTOMER BOOKING REPORT
Fig A.15
ONLINE TAXI BOOKING Page 39
BILL REPORT
Fig A.16
ONLINE TAXI BOOKING Page 40