“INTELLIGENT TRANSPORT PLANNING SYSTEM”

A PROJECT REPORT

Submitted by

Student Full Name

(PRN No)

in partial fulfilment for the award of the degree of

BACHELOR OF ENGINEERING

in
Computer Engineering/Information Technology
Sankalchand Patel College of Engineering, Visnagar

Sankalchand Patel University, Visnagar

April 2025
 Sankalchand Patel College of Engineering, Visnagar

At & Post: Visnagar, Gujarat - Pincode

CERTIFICATE

This is to certify that the project report submitted along with the project
entitled “Intelligence transport planning system” has been carried out
by Poriya Umang Alpeshbhai under my guidance in partial fulfillment for
the degree of Bachelor of Engineering in Computer Engineering, 8th
Semester of Sankalchand Patel University, Visnagar during the academic
year 2022-23.

Dr. Rajesh Patel Dr. Kirit Modi

Internal Guide Head of the Department
SSS

T-13 Platinum Plaza ,Opp Good Luck Party Ploat ,Nr. D-Mart
Circle, Mehsana - 384002
E-mail: info@[Link], web :-www..[Link]

Date: / 05 / 2023

TO WHOM IT MAY CONCERN

This is to certify that Poriya Umang Alpeshbhai a student of

Sankalchand Patel College of Engineering has successfully completed
his/her internship in the field of Computer Engineering from 14/01/2022
to 29/04/2022 (Total number of Weeks: 15 ) under the guidance of Mr.
Hitesh Chaudhary.

His internship activities include Introduction, System Environment,

Feasibility Study, System Design, System Testing, Implementation,
Conclusion, and reference.

During the period of her/ his internship program with us, he/she had been
exposed to different processes and was found diligent, hardworking and
inquisitive.

We wish him every success in his life and career.

For Greencircle Technology

Authorised Signature Industry Stamp

SSS

Sankalchand Patel College of Engineering, Visnagar

At & Post: Visnagar, Gujarat - Pincode

DECLARATION

We hereby declare that the Internship report submitted along with the
Internship entitled “Intelligence transport planning system” submitted
in partial fulfillment for the degree of Bachelor of Engineering in
Computer Engineering/Information Technology to Sankalchand Patel
University, Visnagar, is a bonafide record of original project work carried
out by us at Greencircle Technology under the supervision of Mr. Hitesh
Chaudhary and that no part of this report has been directly copied from any
student’s reports or taken from any other source, without providing due
reference.

Name of the Student Sign of Student

 ACKNOWLEDGMENT

We wish to express our sincere gratitude to our company guide Mr. Hitesh Chaudhary
and our faculty guide Dr. Rajesh Patel, for helping us through our project by giving us
the necessary suggestions and advises along with their valuable co-ordination in
completing this work. We also thank our parents, friends and all the members of the
family for their precious support and encouragement which they had provided in
completion of our work. Thus, in conclusion to the above said, we once again thank the
company guide and faculties and members of Sankalchand Patel College of
Engineering for their valuable support in completion of the project.

Thank You
Poriya Umang Alpeshbhai

i
 ABSTRACT

 A Intelligent Transport Planning System (ITPS) is specialized software for planning,

executing and optimizing the shipment of goods. Admin perform three main tasks in
ITPS: party, rates, billing and payment of all billing statement to ship a party’s order,
book the shipment, details of trucks, and then track its movement to delivery. The broader
goals of using a TPS are to improve shipping efficiency, reduce cost, gain real time
supply chain visibility and ensure party’s satisfaction.

 In this project main role is admin In ITPS admin can manage truck details, material,
party, sites, petrol pump details, royalty, excavator rates, way bridge, driver details, and
admin can manage the all of these rates, and prices statement A ITPS is one of the core
technologies used in supply chain management. The ITPS is a software application to
maintain day to day transactions in transport office. Using this system admin can manage
transport work. He/she can select vehicle (truck) to transport the good

ii
 TABLE OF CONTENTS

Acknowledgement...........................................................................................................i
Abstract...........................................................................................................................ii
Table of Contents...........................................................................................................iii
List of Figures.................................................................................................................v
List of Tables..................................................................................................................v

Chapter 1 Introduction.................................................................................................1
Purpose..........................................................................................................1
Scope.............................................................................................................1
Chapter 2 System Environment..................................................................................2
Hardware configuration.................................................................................2
Software configuration..................................................................................2
Software features...........................................................................................2
PHP TRIAD...............................................................................2
Speed optimization.........................................................2
Macromedia Dreamweaver 8.........................................3
Dreamweaver and accessibility......................................5
PhpMyAdmin.................................................................5
Apache web server......................................................................5
Configuration Files......................................................................................6
Chapter 3 Feasibility study..........................................................................................7
Technical feasibility.......................................................................................7
Behavioral feasibility.....................................................................................7
Economic feasibility......................................................................................7
Chapter 4 System design..............................................................................................8
UML diagram................................................................................................8
Use case diagram............................................................................................8
Activity diagram..........................................................................................11
Class diagram...............................................................................................14
Entity relationship diagram..........................................................................16
Data flow diagram.........................................................................................18
Data Dictionary.............................................................................................21

Chapter 5 System Testing...........................................................................................26

iii
 Unit testing...................................................................................................26
Integration testing........................................................................................26
User acceptance testing................................................................................27
Chapter 6 Implementation...........................................................................................28
User training..................................................................................................28
Security and Maintenance............................................................................29
Screenshot....................................................................................................30
Chapter 7 Conclusion..................................................................................................50
Chapter 8 Reference.....................................................................................................51

Chapter 5 System Testing...........................................................................................26

iv
 LIST OF FIGURES

Fig. 4.1 - Use case diagram

Symbol Fig. 4.2 - Use case
diagram
Fig. 4.3 - Activity
diagram(admin) Fig. 4.4 - Class
diagram
Fig. 4.5 - Entity relationship diagram
symbol Fig. 4.6 - Entity relationship
diagram
Fig. 4.7 - Data flow diagram (zero level)
Fig. 4.8 - Data flow diagram (admin)

LIST OF TABLES

Table 4.7.1 –
Admin Table 4.7.2 Details
– Truck
Table 4.7.3 – Material Catagory
Table 4.7.4 – Party
Table 4.7.5 – Site
Table 4.7.6 – Pump
Table 4.7.7 – Royalty
Table 4.7.8 –
Excavator
Table 4.7.9 – Way Bridge
Table 4.7.10 – Driver
Table 4.7.11 – Daily
v
Form Table 4.7.12–
Payment

v
i
1ET1020208
Introduction
(1ET1020

1. INTRODUCTION

A TPS is a detailed information about carriers, but it is also a transactional and

communication system that enables Party to plan, execute and track shipments. To do all
of those things, it must have strong integration with carrier systems and data sources or
some way to download carrier information. It must also facilitate entry of the Party’s
orders that specify what is to be shipped and Material details that are integrated with the
TPS. A TPS will sometimes be integrated with a Site to enable better coordination of the
tasks that occur at the interface of site and truck details, driver detailssuch as royalty of
goods, Excavator scheduling, waybridge rates, driver rates, petrol rates
.
Transport planning system is a software application to maintain day by day
transactions, payment, prices, rates. Using this system user can manage transport work.
Admin can also check his goods delivery status online.
Purpose:
Proposed system will automate all the work done manually in existing transport
system. It will store all the records of goods delivery. Using this system user can online
check rates of transportation and routes to the destination. Here user can check everything
online and can book his order to transport his goods. User can also manage billing
operation of transportation. Admin can also check which truck is available for
transportation and how long it takes to reach the delivery point. This system provide the
basic components of a shared information system to support the collaboration, rates,
routes, roles, transaction sets, documents, and information exchanged to facilitate the
booking, execution, and settlement of any type of transportation movement.

Scope:
The scope of transport system involves order processing, transportation, materials
handling, all integrated throughout a network of facilities Demonstration of significant
cost savings. Significant contribution to the overall growth of the company. Improvement
in visibility and security, especially in transit. Simplification of supply chain process
across modes and carriers.
1ET1020208
System Environment

2. SYSTEM ENVIRONMENT

2.1 HARDWARE CONFIGURATION

1. Pentium IV Processor
2. 512 MB RAM
3. 40GB HDD
4. 1024 * 768 Resolution Color Monitor
Note: This is not the “System Requirements”.

2.2 SOFTWARE CONFIGURATION

1. OS: Windows XP
2. PHP Triad (PHP5.6, MySQL, Apache, and PhpMyAdmin)

2.3 SOFTWARE FEATURES

2.3.1 PHP TRIAD
PHP Triad installs a complete working PHP/MySQL server environment on
Windows platforms (9x/ NT). Installs PHP, MySQL, Apache, and PhpMyAdmin.

[Link] PHP
PHP is a scripting language originally designed for producing dynamic web pages.
It has evolved to include a command line interface capability and can be used in
standalone graphical applications. While PHP was originally created by Rasmus Lerdorf
in 1995, the main implementation of PHP is now produced by The PHP Group and
serves as the de facto standard for PHP as there is no formal specification. PHP is free
software released under the PHP License; however, it is incompatible with the GNU
General Public License (GPL), due to restrictions on the usage of the term PHP. It is a
widely-used general-purpose scripting language that is especially suited for web
development and can be embedded into HTML. It generally runs on a web server, taking
PHP code as its input and creating web pages as output. It can be deployed on most web
1ET1020208
System Environment

servers and on almost every operating system and platform free of charge. PHP is
installed on more than 20 million websites and 1 million web servers.
PHP originally stood for Personal Home Page. It began in 1994 as a set of Common
Gateway Interface binaries written in the C programming language by the
Danish/Greenlandic programmer Rasmus Lerdorf. Lerdorf initially created these Personal
Home Page Tools to replace a small set of Perl scripts he had been using to maintain his
personal homepage. The tools were used to perform tasks such as displaying his résumé
and recording how much traffic his page was receiving. He combined these binaries with
his Form Interpreter to create PHP/FI, which had more functionality.
PHP/FI included a larger implementation for the C programming language and
could communicate with databases, enabling the building of simple, dynamic web
applications.

Usage
PHP is a general-purpose scripting language that is especially suited for web
development. PHP generally runs on a web server, taking PHP code as its input and
creating web pages as output. It can also be used for command-line scripting and client-
side GUI applications. PHP can be deployed on most web servers, many operating
systems and platforms, and can be used with many relational database management
systems. It is available free of charge, and the PHP Group provides the complete source
code for users to build, customize and extend for their own use.

[Link] Speed optimization

As with many scripting languages, PHP scripts are normally kept as human-
readable source code, even on production web servers. In this case, PHP scripts will be
compiled at runtime by the PHP engine, which increases their execution time. PHP scripts
are able to be compiled before runtime using PHP compilers as with other programming
languages such as C (the language PHP and its extensions are written in). Code optimizers
aim to reduce the computational complexity of the compiled code by reducing its size and
making other changes that can reduce the execution time with the overall goal of
improving performance. The nature of the PHP compiler is such that there are often
opportunities for code optimization, and an example of a code optimizer is the Zend
Optimizer PHP extension.
1ET1020208
System Environment
1ET1020208
System Environment

[Link] Macromedia Dreamweaver 8

Is a professional HTML editor for designing, coding, and developing websites,
web pages, and web applications Whether you enjoy the control of hand-coding HTML or
prefer to work in a visual editing environment, Dreamweaver provides you with helpful
tools to enhance your web creation experience.
The visual editing features in Dreamweaver let you quickly create pages without
writing a line of code. You can view all your site elements or assets and drag them f rom
an easy-to-use panel directly into a document. You can streamline your development
workflow by creating and editing images in Macromedia Fireworks or another graphics
application, then importing them directly into Dreamweaver, or by adding Macromedia
Flash objects.

[Link] Dreamweaver and accessibility

Accessibility refers to making websites and web products usable for people with
visual, auditory, motor, and other disabilities. Examples of accessibility features for
software products and websites include screen reader support, text equivalents for
graphics, keyboard shortcuts, change of display colors to high contrast, and so on.
Dreamweaver provides tools that make the product accessible and tools that help you
author accessible content:
Using Dreamweaver accessibility features For Dreamweaver web designers who
need to use accessibility features, Dreamweaver offers screen reader support, keyboard
navigation, and operating system accessibility support. For more information, see Using
Dreamweaver accessibility features.
Authoring for accessibility For Dreamweaver web designers who need to create
accessible content, Dreamweaver assists you in creating accessible pages that contain
useful content for screen readers and comply with government guidelines.

[Link] phpMyAdmin
PhpMyAdmin is an open-source tool written in PHP intended to handle the
administration of MySQL over the World Wide Web. phpMyAdmin supports a wide
range of operations with MySQL. Currently it can create and drop databases,
create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage users
and permissions, and manage keys on fields. while you still have the ability to direct
1ET1020208
System Environment
1ET1020208
System Environment

execute any SQL statement. phpMyAdmin can manage a whole MySQL server (needs a
super-user) as well as a single database. To accomplish the latter, you’ll need a properly
set up MySQL user who can read/write only the desired database. It’s up to you to look
up the appropriate part in the MySQL manual.

PhpMyAdmin can:
 browse and drop databases, tables, views, fields and indexes
 create, copy, drop, rename and alter databases, tables, fields and indexes
 maintenance server, databases and tables, with proposals on server configuration
 execute, edit and bookmark any SQL-statement, even batch-queries
 load text files intotables
 create and read dumps of tables
 export data to various formats: CSV, XML, PDF, ISO/IEC 26300 - OpenDocument
Text and Spreadsheet, Word, Excel and LATEX formats
 administer multiple servers
 manage MySQL users andprivileges
 check referential integrity in MyISAM tables
 using Query-by-example (QBE), create complex queries automatically connecting
required tables
 create PDF graphics of your Database layout
 search globally in a database or a subset of it

Apache Web Server

Often referred to as simply Apache, a public-domain open-source Web server developed
by a loosely-knit group of programmers. The first version of Apache, based on the NCSA
httpd Web server, was developed in 1995.
Core development of the Apache Web server is performed by a group of about 20
volunteer programmers, called the Apache Group. However, because the source code is
freely available, anyone can adapt the server for specific needs, and there is a large public
library of Apache add-ons. In many respects, development of Apache is similar to
development of the Linux operating system.
1ET1020208
System Environment

2.4 CONFIGURATION FILES

Apache uses a system of three text files for managing its configuration data. All three of
these files (almost always) appear in Apache’s. /Conf directory and are designed to be
edited by system administrators:
1. [Link] for general settings
2. [Link] for resource settings
3. [Link] for securitysettings

When Apache first starts, these files are processed in the order shown above.
Originally, the initial installation of Apache included default entries within each of the
three files. In the most recent versions of Apache, however, the default installation has
changed. Now [Link] is treated as the “master” configuration file and it contains all of
the settings. Both [Link] and [Link] still exist in the installation, but they contain
no settings and are empty except for some comments.
 1ET1020208
Feasibility Study

3. FEASIBILITY STUDY

The feasibility study is carried out to test whether the proposed system is worth
implemented. Feasibility study is the test of proposed system regarding its work ability.

 The key consideration involved in the feasibility study is:

 Technical
 Behavioral
 Economic

TECHNICAL FEASIBILITY:
It is a measure of a specific technical solution and availability of technical solution. The
availability of technical resources and expertise. The user interface uses HTML- CSS
which are very powerful tools to develop web applications. It is user friendly and ease to
use. Hence building application using these technologies provides less tedious work. The
back end is uses MySQL which has well integration. Hence the system is technically
feasible.

BEHAVIORAL FEASIBILITY:
People are inherently resistant to change and computers have been known to
facilitate change. An estimate should be made of how strong a reaction the user staff is
likely to have towards the development of computerized system.

ECONOMIC FEASIBILITY:
The procedure is to determine the benefits and savings that are expected from a
candidate system and compare it with cost. If a benefit outweighs costs, then the decision
is made to design and implement the system otherwise further alterations are made in the
proposed system.
Manpower cost
Hardware cost
Software cost
210185 System Design

4. SYSTEM DESIGN

4.1 UML DIAGRAM

The Unified Modeling Language (UML) is a standard language for writing
software blueprints. The UML may be used to visualize, specify, construct, and document
the artifacts of a software intensive system. The UML is a language
Visualizing
 Specifying
 Constructing
 Documenting
A language provides a vocabulary and the rules for combining words in that
vocabulary for the purpose of communication. A modeling language is a language whose
vocabulary and rules focus on the conceptual and physical representation of a system. A
modeling language such as the UML is thus a standard language for software blueprints.

4.1.1 DIAGRAMS IN THE UML

A diagram is the graphical presentation of a set of elements, most often
rendered as a connected graph of vertices and arcs. A diagram represents an elided view
of the elements that make up a system. The UML includes nine such diagrams:
 Use case diagram
 Activity diagram
 Class diagram

4.2 USE CASE DIAGRAM

 Use Case Diagram Displays the relationship among actors and use cases.
 A use case diagram shows a set of use cases and actors (a special kind of class)
and their relationships.
 Use case diagrams address the static use case view of a system.
 These diagrams are especially important in organizing
210185 System Design

Symbol Details

 An Actor is used to represent something

1. that uses our system. An actor can be a person or
other system.

2.  Use cases are the actions that a user takes

on a system forinstance.

3.  System boundary specifies the limitation

environment of a wholesystem

 Assign Work Flow specifies the task doing by

4. which actor.
 Simply say Roll or Acting of anActor
define by Assign Work Flow.

5.  Association specifies the Actors sub

division or parent & child relationship.

Fig 4.1 Use case diagram Symbol

210185 System Design

Fig 4.2 Use Case Diagram

210185 System Design

4.3 ACTIVITY DIAGRAM

Activity diagrams are one of the five diagrams in the UML for modeling the
dynamic aspects of systems. An activity diagram is essentially a flowchart, showing flow
of control from activity to activity. You use activity diagrams to model the dynamic
aspects of a system. For the most part, this involves modeling the sequential (and possibly
concurrent) steps in a computational process. With an activity diagram, you can also
model the flow of an object as it moves from state to state at different points in the f low
of control. Activity diagrams may stand alone to visualize, specify, construct, and
document the dynamics of a society of objects, or they may be used to model the f low of
control of an operation. Whereas interaction diagrams emphasize the flow of control from
object to object, activity diagrams emphasize the flow of control from activity to activity.

An activity is an ongoing non atomic execution within a state machine. Activities

ultimately result in some action, which is made up of executable atomic computations
those results in a change in state of the system or the return of a value. Activity diagrams
are not only important for modeling the dynamic aspects of a system, but also for
constructing executable systems through forward and reverse engineering.

Action states and activity states are just special kinds of states in a state machine.
When you enter an action or activity state, you simply perform the action or the activity;
when you finish, control passes to the next action or activity. Activity states are somewhat
of shorthand, therefore. An activity state is semantically equivalent to Expanding its
activity graph (and transitively so) in place until you only see actions. Nonetheless,
activity states are important because they help you break complex computations into
parts, in the same manner as you use operations to group and reuse expressions.
210185 System Design

Fig 4.3 Activity Diagram (Admin)

210185 System Design

4.4 CLASS DIAGRAM

A class diagram shows a set of classes, interfaces, and collaborations and their
relationships. These diagrams are the most common diagram found in modeling object -
oriented systems. Class diagrams address the static design view of a system. Class
diagrams that include active classes address the static process view of a system. Class
diagrams are the most common diagram found in modeling object- oriented systems. A
class diagram shows a set of classes, interfaces, and collaborations and their relationships.
You use class diagrams to model the static design view of a system. For the most part,
this involves modeling the vocabulary of the system, modeling collaborations, or
modeling schemas. Class diagrams are also the foundation for a couple of related
diagrams: component diagrams and deployment diagrams. Class diagrams are important
not only for visualizing, specifying, and documenting structural models, but also for
constructing executable systems through forward and reverse engineering. Class diagrams
commonly contain the following things:
 Classes
 Interfaces
 Collaborations
 Dependency, generalization, and associationrelationships
210185 System Design

Fig 4.4 Class-Diagram

210185 System Design

4.5 ENTITY RELATIONSHIP DIAGRAMS

 A conceptual model of data used in an application obtained by using an entity
relationship model (E-Rmodel).
 Entities specify distinct real-world items in an application, relationships represent
dependencies between entities & attributes specify properties of entities &
relationships.
 E-R models have the facility to describe 1 to 1, 1 to many, many too many conditional
& operational relationships.
 E-R modelassist in designing relationships.
 A relation is a table which depicts an entity set. Each column in the relation corresponds
to an attribute of the entity. Each row contains a member of the entity set.
 Relations in a database are normalized. Normalization is a procedure used to transform a
set of relations into another set which has some desirable properties.
 The successive normal forms are called 2NF, 3NF, BCNF, 4NF, 5NF.

Symbol Details

1. Diamond specifies the relation among the

two tables or entities.

Ellipse used to describe the primary key & Reference keys f

with underline name.
2.

. 3. Table identity specifies the name of the

210185 System Design
Fig 4.5 Entity Relationship Diagram symbol
210185 System Design

Fig 4.6 Entity Relationship Diagram

210185 System Design

4.6 DATA FLOWDIAGRAM

A Data Flow Diagram (DFD) is a graphical representation of the "flow" of data
through an Information System. A data flow diagram can also be used for the
visualization of Data Processing.
It is common practice for a designer to draw a context-level DFD first which shows
the interaction between the system and outside entities. This context-level DFD is then
"exploded" to show more detail of the system being modeled.
A DFD represents flow of data through a system. Data flow diagrams are commonly
used during problem analysis. It views a system as a function that transforms the input
into desired output. A DFD shows movement of data through the different
transformations or processes in the system.
Dataflow diagrams can be used to provide the end user with a physical idea of where
the data they input ultimately has an effect upon the structure of the whole system from
order to dispatch to restock how any system is developed can be determined through a
dataflow diagram. The appropriate register saved in database and maintained by
appropriate authorizes.

Fig 4.7 Data Flow Diagram (Zero Level)

210185 System Design

Fig 4.8 Data Flow Diagram (Admin)

210185 System Design

4.7 DATA DICTIONARY

Table 4.7.1.:-Admin
Field Datatype Length Constraint Description
Id Int 2 Primary key To store id of
admin
Username Varchar 255 Not null To store admin
username
Password varchar 255 Not null To store admin
password
B_name varchar 255 Not null To admin
name
B_address Varchar 255 Not null To store
address
B_contact Varchar 255 Not null To store
contact
B_pin Int 6 Not null To store
pincode
B_logo varchar 255 null To store logo

Table 4.7.2.:-Truck_details
Field Datatype Length Constraint Description
Tra_id Int 3 Primary Key To give trucks
unique id
Tra_number Varchar 255 Not null To store truck
id
Tra_weight Flote 10,2 Not null To store truck
weight
Tra_active ENUM ‘No’,’yes’ Not null To store truck
status
210185 System Design

Table 4.7.3.:-Material_Catagory
Field Datatype Length Constraint Description
M_id Int 3 Primary Key To give
material
unique id
M_name Varcahr 255 Not null To store
material name
S_gst Float 2.2 Not null To store state
gst
C_gst Float 2,2 Not null To store
central state
gst details
Hsn_score Varchar 255 Not null To store hsn
score
Open_stock Float 10,3 Not null To store open
stock details
Unit Varchar 255 Not null To store unit
of materials

Table 4.7.4.:-Party Details

Field Datatype Length Constraint Description
P_id Int 5 Primary key To give party
unique id
p_opening Float 10,2 Not null To store party
opening status
P_name Varchar 255 Not null To store party
name
P_Add Varchar 255 Not null To store party
address
P_pincode Int 6 Not null To store party
pincode
P_Mobile Varchar 10 Not null To store party
mobile number
State Int 2 Not null To store party
state
P_email varchar 255 NULL To store party
email
210185 System Design

Table 4.7.5.:-Site

Field Datatype Length Constraint Description

S_id Int 5 Primary key To give site
unique id
P_id Int 5 Foreign key To store party
id
S_name Varchar 255 Not null To store site
name
S_address Varchar 255 Not null To store site
address
S_mobile Int 10 Not null To store site
mobile number
S_personname Varchar 255 Not null To store site
person name
S_email Varchar 255 Null To store site
email id
Other Text - Null To store other
details of site
status ENUM ‘No’,’Yes’ Not null To check
status of site

Table 4.7.6.:-Petrol Pump

Field Datatype Length Constraint Description

Pm_id Int 3 Primary key To give petrol
pump unique
id
Pm_name varchar 255 Not null To store patrol
pump name
Pm_address Varchar 255 Not null To store pump
address
Pm_contact Varchar 10 Not null To store pump
contact
Pm_pin Int 6 Not null To store pump
pincode
Pm_opening Float 10,2 Not null To store pump
opening status
Pm_email Varchar 255 Null To store pump
email id
210185 System Design

Table 4.7.7.:-Royalty
Field Datatype Length Constraint Description
R_id Int 5 Primary Key To give
royalty unique
id
R_opening Float 10,2 Not null To store
royalty
opening time
R_Name Varchar 255 Not null To store
royalty name
R_add Varchar 255 Not null To store
royalty address
R_contact Varchar 10 Not null To store
royalty contact
R_email Varchar 255 Null To store
royalty email
R_active ENUM ‘No’,’yes’ Not null To store
royalty active
status

Table 4.7.8.:-Excavator
Field Datatype Length Constraint Description
E_id Int 5 Primary Key To give
excavator
unique id
E_opening Float 10,2 Not null To store
excavator
opening time
E_Name Varchar 255 Not null To store
excavator
name
E_add Varchar 255 Not null To store
excavator
address
E_contact Varchar 10 Not null To store
excavator
contact
E_email Varchar 255 Null To store
excavator
email
E_active ENUM ‘No’,’yes’ Not null To store
excavator
active status
210185 System Design

Table 4.7.9.:-Way Bridge

Field Datatype Length Constraint Description
W_id Int 5 Primary Key To give way
bridge unique
id
W_opening Float 10,2 Not null To store way
bridge opening
time
W_Name Varchar 255 Not null To store way
bridge name
W_add Varchar 255 Not null To store way
bridge address
W_contact Varchar 10 Not null To store way
bridge contact
W_email Varchar 255 Null To store way
bridge email
W_active ENUM ‘No’,’yes’ Not null To store way
beidge active
status

Table 4.7.10.:-Driver

Field Datatype Length Constraint Description

D_id Int 3 Primary Key To give way
Driver unique
id
D_name Varchar 255 Not null To store
Driver Name
D_address Varchar 255 Not null To store driver
address
D_contact Varchar 10 Not null To store driver
contact
D_licence Varchar 255 Not null To store driver
licence
D_exp date 10 Null To store driver
licence exp
date
D_active ENUM ‘No’,’yes’ Not null To store driver
active status
210185 System Design

Table 4.7.11.:-Daily Form

Field Datatype Length Constraint Description
Df_id Int 5 Primary To give daily form unique id
Key
Tra_id Int 3 F.k To give truck unique id
Df_date Date 10 Not null To store daily form date
Pm_id Int 3 f.k To give pump unique id
Km Int 10 Not null To store truck kilometer
Desiel Float 10,2 Null To store desiel stock
D_price Float 3,2 Not null To store desiel price
P_type Enum ‘cash’,’ Not null To store pump payment type
credit’
P_chalan Varchar 255 Null To store pump chalan
D_id Int 3 f.k To give driver unique id
E_id Int 5 f.k To give excavator unique id

E_rate Float 4 Not null To store the rate of royalty

E_type ENUM ‘cash’,’ Not null To store excavator type of
credit’ payment
R_id Int 5 f.k To give royalty unique id

R_weight Float 10,2 Not null To store royalty time weight

R_rate Float 3,2 Not null To store royalty rate

R_type ENUM ‘cash’,’ Not null To store type of royalty payment
credit’ type
R_chalan Varchar 255 Not null To store royalty chalan type

W_id Int 5 f.k To store way bridge

W_rate Int 4 Not null To store way bridge rate
W_type ENUM ‘cash’,’ Not null To store way bridge type of
credit’ payment
210185 System Design
P_id Int 5 f.k To store party unique id
S_id Int 5 f.k To store site unique id
S_weight Float 10,2 Not null To store site truck weight
S_price Float 3,2 Not null To store site price
S_paymen ENUM ‘cash’,’ Not null To store site side payment method
t credit’
Remarks TEXT - Null To store remarks

Table 4.7.12.:-Payment
Field Datatype Length Constraint Description
Pay_id Int 5 Primary key To store
unique
payment id
Pay_date Date 10 Not null To store pay
date
Pay_type ENUM ‘r’,’p’,’e’,’w’,’pa’ Not null To store
payment
method
Id Int 5 F.k To store
payments id
Pay_amount Float 10,2 Not null To store
payment
amount
Pay_type ENUM ‘cash’,’credit’ Not null To store
payment type
Pay_chequeno Varchar 10 Null To store
payment
cheque no
Pay_date Date 10 Null To store
payment date
Pay_remarks text - Null To store
payment
remarks
 SSS

210185 System Testing

5. SYSTEM TESTING

System testing is the stage of implementation, which is aimed at ensuring that the
system works accurately and efficiently before live operation commences. Testing is the
process of executing the program with the intent of finding errors and missing operations
and also a complete verification to determine whether the objectives are met and the user
requirements are satisfied. The ultimate aim is quality assurance.

Tests are carried out and the results are compared with the expected document. In the
case of erroneous results, debugging is done. Using detailed testing strategies, a test plan
is carried out on each module. The various tests performed in “Network Backup System”
are unit testing, integration testing and user acceptance testing.

5.1 UNIT TESTING

The software units in a system are modules and routines that are assembled and
integrated to perform a specific function. Unit testing focuses first on modules,
independently of one another, to locate errors. This enables, to detect errors in coding and
logic that are contained within each module. This testing includes entering data and
ascertaining if the value matches to the type and size supported by java. The various
controls are tested to ensure that each performs its action as required.

5.2 INTEGRATION TESTING

Data can be lost across any interface, one module can have an adverse effect on
another, sub functions when combined, may not produce the desired major functions.
Integration testing is a systematic testing to discover errors associated within the
interface. The objective is to take unit tested modules and build a program structure. All
the modules are combined and tested as a whole. Here the Server module and Client
module options are integrated and tested. This testing provides the assurance that the
application is well integrated functional unit with smooth transition of data.
 SSS

210185 System Testing

5.3 USER ACCEPTANCE TESTING

User acceptance of a system is the key factor for the success of any system. The
system under consideration is tested for user acceptance by constantly keeping in tou ch
with the system users a Time of developing and making changes whenever required
 SSS

210185 Implementation

6. IMPLEMENTATION

Implementation is the stage in the project where the theoretical design is turned
into a working system and is giving confidence on the new system for the users that it will
work efficiently and effectively. It involves careful planning, investigation of the current
system and its constraints on implementation, design of methods to achieve the
changeover, an evaluation of change over methods. Apart from planning major task of
preparing the implementation are education and training of users. The implementation
process begins with preparing a plan for the implementation of the system. According to
this plan, the activities are to be carried out, discussions made regarding the equipment
and resources and the additional equipment has to be acquired to implement the new
system. In network backup system no additional resources are needed.

Implementation is the final and the most important phase. The most critical stage in
achieving a successful new system is giving the users confidence that the new system will
work and be effective. The system can be implemented only after thorough testing is done
and if it is found to be working according to the specification. This method also offers the
greatest security since the old system can take over if the errors are found or inability to
handle certain type of transactions while using the new system.

6.1 USER TRAINING

After the system is implemented successfully, training of the user is one of the most
important subtasks of the developer. For this purpose, user manuals are prepared and
handled over to the user to operate the developed system. Thus, the users are trained to
operate the developed system. Both the hardware and software securities are made to run
the developed systems successfully in future. In order to put new application system into
use, the following activities were taken care of Preparation of user and system
documentation Conducting user training with demo and hands on Test run for some
period to ensure smooth switching over the system The users are trained to use the newly
developed functions. User manuals describing the procedures for using the functio ns
listed on menu are circulated to all the users. It is confirmed that the system is
implemented up to users need and expectations.
SSS
 SSS

210185 Implementation

6.2 SECURITY AND MAINTENANCE

Maintenance involves the software industry captive, typing up system resources. It
means restoring something to its original condition. Maintenance follows conversion to
the extend those changes are necessary to maintain satisfactory operations relative to
changes in the user’s environment. Maintenance often includes minor enhancements or
corrections to problems that surface in the system’s operation. Maintenance is also done
based on fixing the problems reported, changing the interface with other software or
hardware enhancing the software.

Any system developed should be secured and protected against possible hazards.
Security measures are provided to prevent unauthorized access of the database at various
levels. An uninterrupted power supply should be so that the power failure or voltage
fluctuations will not erase the data in the files.

Password protection and simple procedures to prevent the unauthorized access are
provided to the users. The system allows the user to enter the system only through proper
user name and password.
 SSS

210185 Implementation

6.3 SNAPSHOT

Home page
 SSS

210185 Implementation

About Us page
 SSS

210185 Implementation

Service page
 SSS

210185 Implementation

Contact Us page
 SSS

210185 Implementation

Admin Login

Admin Dashboard
 SSS

210185 Implementation

Party page

Add Party Page

 SSS

210185 Implementation

Trip Detail page

Add Trip Details

 SSS

210185 Implementation

Driver Page

Add Driver Details

 SSS

210185 Implementation

Material Page

Add Material Page

 SSS

210185 Implementation

Truck Details Page

Add Truck Page

 SSS

210185 Implementation

Royalty Details Page

Add Royalty details Page

 SSS

210185 Implementation

Excavator Detail Page

Add Excavator Details Page

 SSS

210185 Implementation

Way Bridge Detail Page

Add Way Bridge Detail Page

 SSS

210185 Implementation

Payment Detail page

Add Payment detail Page

 SSS

210185 Implementation

Party Report Page

Party Report Print Page

 SSS

210185 Implementation

Royalty Report Page

Pump Report Page

 SSS

210185 Implementation

Excavator Report Page

Way Bridge Page

 SSS

210185 Implementation

Payment Report page

 SSS

210185 Implementation

Party Remaining Report

Royalty Remaining Report

 SSS

210185 Implementation

Excavator Remaining Report

Way Bridge Remaining Report

 SSS

210185 Conclusion

7. CONCLUSION

Various eCommerce giants, logistics company, distribution businesses have

been looking for fine solutions to minimize the overhead spending and brings fluency
into their business operations. Thus, being able to track their freight and consignments
proved to be a meaningful way to devise the potholes in the process that can be shaped
to perfection.

In addition to this, Transportation Management Systems has also brought other

most useful ways of tracking shipments, reducing unnecessary costs, understanding the
needs of the customers, and also gathering real-time information about the entire
shipping process..

Transportation management systems play a crucial role in supply chains. An

effective transport management system provides deep visibility to ensure more efficient
transportation planning and execution. This inevitably results in higher customer
satisfaction, which leads to more sales and business growth.
 SSS

210185 Biography

8. REFERENCE

[1] [Link]
[2] [Link]
[3]
[Link]
[4] [Link]
TMS