Visvesvaraya Technological University: "Courier Management System"
Visvesvaraya Technological University: "Courier Management System"
Visvesvaraya Technological University: "Courier Management System"
2022- 2023
Submitted in partial fulfillment of the requirements for the award of the degree of
BACHELOR OF ENGINEERING
in
INFORMATION SCIENCE & ENGINEERING
Submitted by
Ms. Malini R
Assistant Professor
Dept. of ISE, ATRIA I. T.
&
Mrs. Asma Begum
Assistant Professor
Dept. of ISE, ATRIA I. T.
CERTIFICATE
Certified that the project work entitled “COURIER MANAGEMENT SYSTEM”
carried out by AISHWARYA P (1AT20IS001), GREESHMA (1AT20IS026)
are bonafide students of ATRIA INSTITUTE OF TECHNOLOGY, Bengaluru, in partial
fulfillment for the award of Degree of Bachelor of Engineering in Information Science &
Engineering of Visvesvaraya Technological University, Belagavi, during the academic year
2022-23. It is certified that all corrections/suggestions indicated for Internal Assessment have been
incorporated in the report deposited in the department library. The project report has been approved
as it satisfies the academic requirements in respect of project work prescribed for the said degree.
Guide HOD
External Viva
1.
2.
DECLARATION
Institute of Technology, Bengaluru, would hereby declare that the project entitled “COURIER
Bengaluru, and submitted in partial fulfillment of the course requirement for the award of degree of
We further declare that the work embodied in this report has not been submitted to
any other university or institution for the award of any other degree.
AISHWARYA P
(1AT20IS008)
GREESHMA R
(1AT20IS026)
Dept. of ISE
-
ABSTRACT
designed primarily for the use in the couriers logistics industry this system will allow courier and
logistical services company to increase scope of the business by reducing the paper work cost and
accountability of goods involved this system also allows quick and easy management of transporting
parcels from one point to another as they can be easily tracked compared to the use of manual systems
of recording information as it includes message sent to the receiver and the sender to track the parcel
courier services employees use the system through an easy to navigate graphical interface for efficient
processing . After the parcel being sent has been processed a sent is sent with estimated time of delivery
and the customers will be updated once there is a delay moreover a notification will be issued to the
customers for pick up however if the receiver is a distance away they can also request a delivery
thereafter the customer dashboard is updated that the meal is sent out and the estimated time of delivery
once the parcel arrives at the destination then the dashboard is updated to be delivered .Since this will
reduce the man required at the front desk it will reduce the loss of goods and services and accountability
in terms of credit. This project is developed using PHP, JavaScript and MYSQL. This system is an
online application which can be hosted online and therefore the user needs an internet connection or the
company.
ii
Dept. of ISE
ACKNOWLEDGEMENT
We are grateful to our institution, Atria Institute of Technology, for having provided us
with the facilities to successfully complete this mini project on COURIER
MANAGEMENT SYSTEM.
We thank Dr. T N Srinivasa, principal and Dr. Shanthi Mahesh, HOD, ISE for
providing us all the necessary facilities for the successful completion of our mini-project.
Deadlines play a very important role in the successful completion of the academic
project on time, efficiently and effectively. We take this opportunity to express our deep
sense of gratitude to our guide and coordinators Dr.T N Anitha, Professor and Ms. Malini
R, Assistant Professor, Department of ISE for their valuable guidance and help
throughout the course of the academic mini-project. They have always been patient with us
and helped immensely in completing the task on hand. We also thank them for their
immense support, guidance, specifications & ideas without which seminar would have been
completed without full merit.
Last but not least from the Department of Information Science and Engineering,
teaching and non-teaching staffs for their constant encouragement, support, patience, and
endurance shown during the preparation of this report were remarkable. We also thank the
management.
Finally, we thank our parents and friends for their motivation, morale and material
support.
AISHWARYA P(1AT20IS008)
GREESHMA R(1AT20IS026)
iii
Dept. of ISE
Management System
TABLE OF CONTENTS
Abstract
Acknowledgement
1 Introduction to database 6
2 Introduction to project 14
2.1.1 Introduction 14
2.1.4 Scope 15
2.3.1 branches 17
18
2.3.2 parcels
2.3.3 parcel tracks 18
2.3.4 system settings 19
19
2.3.5 users
Dept. of ISE
3 DESIGN 20
5 CONCLUSION 28
6 REFERENCES 29
Dept. of ISE
Courier management system 2022-2023
LIST OF FIGURES
1.3 ER Diagram 22
B.5 IN TRANSIT 35
B.7 REPORTS 36
Dept. of ISE 1
courier management system 2022-2023
LIST OF TABLES
2.3.1 BRANCHES 11
2.3.2 PARCELS 11
2.3.3 PARCELS_TRACKS 12
2.3.5 USERS 13
Dept. of ISE
Courier management system 2022-2023
CHAPTER 1
INTRODUCTION TO DATABASE
Database and database technology has a major impact on the growing use of
computers. It is fair to say that databases play a critical role in almost all areas where
computers are used, including business, electronic commerce, engineering, medicine,
genetics, law, education, and library science. The word database is so commonly used that
we must begin by defining what the database is.
The preceding definition of a database is quite general, for example, we may consider
the collection of words that make up this page of text to be related data and hence to
constitute a database. However, the common use of the term database is usually more
restricted. A database has the following properties:
● A database represents some aspect of the real world, sometimes called the mini world
or the universe of discourse. The changes to the mini world are reflected in the
database.
● A database is a logically coherent collection of data with some inherent meaning. A
random assortment of data cannot correctly be referred to as a database.
● A database is designed, built and populated with data for a specific purpose. It has an
intended group of users and some preconceived applications in which these users are
interested.
Dept. of ISE 1
courier management system 2022-2023
In other words, a database has some source from which data is derived, some degree
of interaction with events in the real world, and an audience that is actively interested in its
contents. The end-users of the database may perform business transactions (for example a
customer buys a camera) or events may happen that may cause the information in the
database to change. In order for a database to be accurate and reliable at all times, it must
be a true reflection of the mini world that it represents; therefore changes must be reflected
in the database as soon as possible.
A database can be of any size and complexity. A database may be generated and
maintained manually or computerized. For example, a library card catalog is a database that
may be created and maintained manually. A computerized database may be created and
maintained either by a group of application programs written specifically for that task or by
a database management system.
Dept. of ISE
Courier management system 2022-2023
applied consistently and access to certain parts of the data must be restricted. We can try to
manage the data by storing it in operating system files.
● We probably do not have 500GB of main memory to hold all the data. We must,
therefore, store data in a storage device such as a disk or tape and bring relevant parts
into the main memory for processing as needed.
● Even if we have 500 GB of main memory, on computer systems with 32 bit
addressing, we cannot refer directly to more than about 4 GB of data. We have to
program some method of identifying all data items
● We have to write special programs to answer each question a user may want to ask
about the data. These programs are likely to be complex because of the large volume
of data to be searched.
● We must protect the data from the inconsistent changes made by different users
accessing the data concurrently. If applications must address the details of such
concurrent access, this adds greatly to their complexity.
● We must ensure that the data is restored to a consistent state if the system crashes
while changes are being made.
● Operating systems provide only a password mechanism for security. This is not
sufficiently flexible to enforce security policies in which different users have
permission to access different subsets of the data.
● DBMS is a piece of software designed to make the preceding tasks easier. By storing
data in DBMS rather than as a collection of operating system files, we can use the
DBMS’s features to manage the data in a robust and efficient manner. As the volume
of data and the number of users grow hundreds of gigabytes of data and thousands of
users are common in current corporate database DBMS support becomes
indispensable.
Dept. of ISE 1
courier management system 2022-2023
Dept. of ISE
Courier management system 2022-2023
Data Integrity and Security: if data is always accessed through DBMS, the DBMS
can enforce integrity constraints. For example, before inserting salary information for an
Dept. of ISE 1
courier management system 2022-2023
employee, the DBMS can check that the department budget is not exceeded. Also, it can
enforce access controls that govern what data is visible to different classes of users.
Data Administration: when several users share data, centralizing the administration
of data can offer significant improvements. Experienced professionals who understand the
nature of the data being managed, and how different groups of users use it, it can be
responsible for organizing the data representation to minimize redundancy and for
finetuning the storage of the data to make retrieval efficient.
The goal of the three-schema architecture illustrated in the figure is to separate the
user application from the physical database. In this architecture, schemas can be
defined at the following three levels:
● The internal level has an internal schema, which describes the physical storage
structure of the database. The internal schema uses a physical data model and describes
the complete details of data storage and access paths for the database.
● The conceptual level has a conceptual schema, which describes the structure of the
whole database for a community of users. The conceptual schema hides the details of
physical storage structures and concentrates on describing entities, data types,
Dept. of ISE
Courier management system 2022-2023
● The external or view level includes a number of external schemas or user views.
Each external schema describes the part of a database that a particular user group is
interested in and hides the rest of the database from that user group. As in the previous
level, each external schema is typically implemented using a representational data
model, possibly based on external schema design in a high-level data model.
Dept. of ISE 1
courier management system 2022-2023
CHAPTER 2
INTRODUCTION TO PROJECT
2.1 Overview of the project
2.1.1 Introduction
This document aims at defining overall software requirement for COURIER
MANAGEMENT SYSTEM efforts have been made to define the requirements
exhaustively and accurately. The final product will be having only features/functionalities
mentioned in this document and assumptions for any additional functionality/feature
should not be made by any of the parties involved in developing/testing/implementing
using this product .
resources in an optimum manner to ensure timely service with least cost. Every
between hubs or zones will have a time limit set under which it must be completed.
Dept. of ISE
Courier management system 2022-2023
2.1.4 Scope
parceling management systems in different areas of logistics and cargo transport. The web based system
will first get to Skyward Express, due to many parcels being sent to many counties; and have had cases
of losses in parcel and cargo. This will help the cargo and parcel handlers in simplicity of their
operations.
Dept. of ISE 1
courier management system 2022-2023
As a result of the online courier management systems the following are the anticipated advantages and
benefits of the proposed system:
Firstly, it will help in making efficient deliveries and more accountability due to ease pf follow up of
the transportation of a courier from one destination to another.
The system will also help to reduce labor cost involved. This is because it needs few users compared to
the manual system that needs a lot of users and more paper work involved.
The system will be less probable to make mistake, since it’s a web based system. This will also lead to
ease the speed of execution and number of optimum screens to accommodate the maximum throughput.
Lastly, it will make the job easier by hastening the work process therefore saving time.
The proposed system has some disadvantages due to the change made from operating from manual to
computerized system.
These include:
4. Unemployment: some of the workers expressed fear that they will be laid off due to the introduction
of computerized systems.
5. Training cost: the employees will be trained on the effective use of the courier system which will cost
the company both time and finances.
6. Maintenance cost: the system will require modification due to new user requirements, upgrades and
installations. However, the courier management system for the transport and cargo sector is worth
undertaking as the benefits it will introduce are
Dept. of ISE
Courier management system 2022-2023
2.3.1 BRANCHES
BRANCHES table has the attributes id , branch_code ,street, city ,state ,zip_code ,
country ,contact , date
2.3.2 PARCELS
Dept. of ISE 1
courier management system 2022-2023
2.3.3 PARCELS_TRACKS
PARCEL_TRACKS table has the attributes id , parcel_id ,status , date_created
SYSTEM SETTINGS table has the attributes id, name, email, contact, address, cover images.
Dept. of ISE
Courier management system 2022-2023
2.3.5 USERS
USERS table has the attributes of id, firstname, lastname, email, password, type, branch id, date
created.
Dept. of ISE 1
courier management system 2022-2023
CHAPTER 3
DESIGN
Architecture
SEND ORDERS
COLLECT ORDERS
USER
USER
ADMIN PICKUP
ASSIGN DROP
Dept. of ISE
Courier management system 2022-2023
Courier Management system Project in PHP . In this project, you can simply perform the operations
to manage the couriers and the parcels. You can log in as the system admin and also can add and
delete the Courier. you can also Update Status for courier delivered or not .
Courier Management System is the simplest solution for Courier & Cargo Tracking
Business. This Courier Management System project will have different modules.
The login section will have login facility for the admin who will operate this system and online
While taking orders from its customers, it will take all the details of its customers who is placing the
orders and all the details for the recipient such as its address, name, mobile number.
During billing process, system generates a consignment number for their products. Through this
consignment no. customers or its recipient will able to track their products from any location using
internet.
This Courier Management System project will provide information recipient with following detail –
where the current consignment is, till when it will reached its final destination, date of placing
Dept. of ISE 1
courier management system 2022-2023
Dept. of ISE
Courier management system 2022-2023
CHAPTER 4
Functional requirements are those requirements that are used to illustrate the internal
working nature of the system, the description of the system, and explanation of each
subsystem. It consists of what task the system should perform, the processes involved,
which data should the system holds and the interfaces with the user.
Depending upon the user role he/she will be able to access only the specific modules of
the system.
1) Login facility for enabling only authorized access to the system
2) User (with role Data Entry operator) will be able to modify /add/delete information
about different students that are enrolled for the course in different years
4.1.2Non-Functional Requirements
It describes aspects of the system that are concerned with how the system provides the
functional requirements.
They are:
Security: The subsystem should provide a high level of security and integrity of the
data held by the system, only authorized personnel of the company can gain access to
Dept. of ISE 1
courier management system 2022-2023
the company’s secured page on the system; and only users with valid password and
username can login to view user’s page.
Performance and Response time: The system should have high performance rate
when executing user’s input and should be able to provide feedback or response
within a short time span usually 50 seconds for highly complicated task and 20 to 25
seconds for less complicated task.
Error handling: Error should be considerably minimized and an appropriate error
message that guides the user to recover from an error should be provided. Validation
of user’s input is highly essential. Also the standard time taken to recover from an
error should be 15 to 20 seconds.
Availability: This system should always be available for access at 24 hours, 7 days a
week. Also in the occurrence of any major system malfunctioning, the system should
be available in 1 to 2 working days, so that the business process is not severely
affected.
Ease of use: Considered the level of knowledge possessed by the users of this
system, a simple but quality user interface should be developed to make it easy to
understand and required less training.
● A later version of the software will incorporate encryption techniques in the user/license
authentication process
Dept. of ISE
Courier management system 2022-2023
4.3SOFTWARE REQUIREMENTS
4.3.1 SERVER SIDE
2. OS: windows7/8/10
3. MYSQL server
4.3.3 PHP
Dept. of ISE 1
courier management system 2022-2023
APACHE Apache is the most widely used web server software. Developed and
maintained by Apache Software Foundation, Apache is open-source software available for
free. It runs on 67% of all web servers in the world. It is fast, reliable, and secure. It can be
highly customized to meet the needs of many different environments by using extensions
and modules. Most WordPress hosting providers use Apache as their web server software.
However, WordPress can run on other web server software as well.[2]
4.3.5 HTML
HyperText: HyperText simply means "Text within Text". A text has a link within it, is a
hypertext. Every time you click on a word that brings you to a new webpage, you have
clicked on a hypertext.
Markup language: A markup language is a programming language that is used to make text
more interactive and dynamic. It can turn a text into images, tables, links, etc. An HTML
document is made of many HTML tags and each HTML tag contains different content.[3]
Dept. of ISE
Courier management system 2022-2023
CONCLUSION
expertise. Technology is not a static or stagnant field, but rather one that is constantly
changing as new trends arise. As patterns change and improve, it's past time for us to
change with them. The use of online courier management systems is important for
getting accountability and making goods get delivered quickly and making the work
easier. As a result, this system would make it easier for Kenya's courier companies be
Dept. of ISE 1
courier management system 2022-2023
REFERENCES
The following books were referred during the analysis and execution phase of the project
2014,McGraw Hill
Links:
http://www.google.com
www.w3schools.com
www.tutorialspoint.php
http://stackoverflow.com
Wikipedia.org
Dept. of ISE
Courier management system 2022-2023
Dept. of ISE 1
courier management system 2022-2023
Dept. of ISE
Courier management system 2022-2023
Dept. of ISE 1
courier management system 2022-2023
Dept. of ISE
Courier management system 2022-2023
Dept. of ISE 1
courier management system 2022-2023
Dept. of ISE
Courier management system 2022-2023
B.5 In Transit
Dept. of ISE 1
courier management system 2022-2023
B.7 Reports
Dept. of ISE
Courier management system 2022-2023
Dept. of ISE 1