VISVESVARAYA TECHNOLOGICAL UNIVERSITY

“Jnana Sangama”, Belagavi-590018

Project- Report
on
“Air Cargo Management System”
SUBMITTED IN PARTIAL FULFILLMENT FOR THE AWARD OF DEGREE OF

BACHELOR OF ENGINEERING
IN
Computer Science and Engineering
SUBMITTED BY
Darshan D K [1JB21CS035]
Darshan M [1JB21CS036]

Under the Guidance of

Dr Prakruthi M K
Associate professor

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

SJB INSTITUTE OF TECHNOLOGY
No.67, BGS Health & Education City, [Link] Rd, Kengeri, Bengaluru, Karnataka 560060

2023 - 2024
 || Jai Sri Gurudev ||
Sri Adichunchanagiri Shikshana Trust ®
SJB INSTITUTE OF TECHNOLOGY
No.67, BGS Health & Education City, [Link] Rd, Kengeri, Bengaluru, Karnataka 560060

Department of Computer Science and Engineering

CERTIFICATE

Certified that the DBMS Mini Project report entitled “Air Cargo Management System”
carried out by Mr. Darshan D K, Darshan M bearing USN 1JB21CS035, 1JB21CS036 are
bonafide students of SJB Institute of Technology in partial fulfilment for 5th semester of
BACHELOR OF ENGINEERING in Computer Science and Engineering as prescribed by
Visvesvaraya Technological University, Belagavi during the academic year 2023-24. It is
certified that all corrections/suggestions indicated for Internal Assessment have been incorporated
in the report deposited in the departmental library. The Project report has been approved as it
satisfies the academic requirements of prescribed subject of Database Management System
[21CS53] for the said degree.

Signature of Guide Signature of HOD

Dr Prakruthi M K Dr. Krishna A N
Associate Professor Professor & Head
Dept. of CSE, SJBIT Dept. of CSE, SJBIT
 ACKNOWLEDGEMENT
We would like to express our profound grateful to His Divine Soul Jagadguru Padmabhushan
Sri Sri Sri Dr. Balagangadharanatha Mahaswamiji and His Holiness Jagadguru Sri Sri Sri
Dr. Nirmalanandanatha Mahaswamiji for providing us an opportunity to complete our
academics in this esteemed institution.

We would also like to express our profound thanks to Revered Sri Dr. Prakashnath Swamiji,
Managing Director, SJB Institute of Technology, for his continuous support in providing amenities
to carry out project in this admired institution.

We express our gratitude to Dr. K. V. Mahendra Prashanth, Principal, SJB Institute of Technology,
for providing us an excellent facilities and academic ambience which have helped us in
satisfactory completion of project work.

We extend our sincere thanks to Dr. Krishan A N, Head of the Department, Computer Science
and Engineering for providing us an invaluable support throughout the period of our project work.

We wish to express our heartfelt gratitude to our guide Dr Prakruthi M K, for her valuable
guidance,suggestions and cheerful encouragement during the entire period of our project work.

Finally, we take this opportunity to extend our earnest gratitude and respect to our parents,
Teaching & Non teaching staffs of the department, the library staff and all our friends, who have
directly or indirectly supported us during the period .

Regards,
Darshan D K [1JB21CS035]
Darshan M [1JB21CS036]
 TABLE OF CONTENTS

LIST OF FIGURES ................................................................................................................... 2

ABSTRACT .............................................................................................................................. 3

CHAPTER 1: INTRODUCTION ............................................................................................. 4

1.1 Background Study............................................................................................................ 5

1.2 Problem Statement ........................................................................................................... 5

1.3 Objective .......................................................................................................................... 6

1.4 Future Scope .................................................................................................................... 6

1.5 Project Proposal ............................................................................................................... 6

1.6 Significance of Problem ................................................................................................... 6-7

CHAPTER 2: REVIEW OF LITERATURE ............................................................................ 8

2.1 Introduction ..................................................................................................................... 8

2.2 Literature Studies ............................................................................................................ 8-9

2.3 Conclusion ...................................................................................................................... 10

CHAPTER 3: REQUIREMENTS AND MODULES ............................................................... 11

3.1 Requirements .................................................................................................................. 11

3.2 Modules .......................................................................................................................... 11

CHAPTER 4: DESIGN AND APPLICATION .................................................................... 12

4.1 Design ............................................................................................................................ 12

4.2 Application and Usages ................................................................................................. 13

CHAPTER 5: ENTITY-RELATIONSHIP AND SCHEMA DIAGRAM ......................... 14-15

CHAPTER 6: SNAPSHOTS .............................................................................................. 16-19

CHAPTER 7: SUMMARY,CONCLUSION, RECOMMENDATION .................................. 20

REFERENCES ........................................................................................................................ 21
 Sl. No. Figure No. Title of figure Page No.

1 1.1 Entity-Relationship Diagram 10

2 1.2 Schema Diagram 11

3 4.1 Home page and verified certificate 17

7 4.2 Admin and dashboard page 18

8 4.3 Profile and change password page 19

9 4.4 New and verified application page 20

10 4.5 View verified and rejected application page 21

11 4.5 Forgot password and user defined page 22

 DATABASE MANAGEMENT SYSTEM 21CS53

Department of CSE, SJBIT Page 1

 DATABASE MANAGEMENT SYSTEM 21CS53

LIST OF FIGURES

Department of CSE, SJBIT Page 2

 DATABASE MANAGEMENT SYSTEM 21CS53

ABSTRACT

Air Cargo management simplifies the task of organizing air cargo through a comprehensive software
solution. Users are prompted to input dimensions for containers and products, along with weight and
orientation constraints. To streamline data entry, the system is equipped with an internal database
capable of storing details for up to 50 containers and 4000 products. If a product code matches an
entry in the database, relevant information is automatically populated into the corresponding fields,
minimizing manual input. The software offers multiple packing methods, allowing users to
maximize cargo space by loading from either the floor or end of the container, among other options.
Once all necessary data is entered, a summary is provided for review, affording users the opportunity
to make adjustments or additions before proceeding. Additionally, users have the option to save the
input data file for future reference or replication of similar cargo configurations. Upon completion,
the system initiates cargo packing based on the specified parameters and selected packing method,
ensuring efficient and effective management of air cargo shipments.

Department of CSE, SJBIT Page 3

 DATABASE MANAGEMENT SYSTEM 21CS53

CHAPTER 1:

INTRODUCTION 1.0

An “ Air Cargo Management System “is a web-based solution that controls every stage of an air

cargo shipment, from acceptance to delivery. It's designed to improve the services offered by

airlines, streamline cargo operations, and ensure effective management of freight and cargo.

A simple web-based application that uses PHP/OOP and a MySQL database to manage air cargo

businesses is available as free source code. In object-oriented programming (OOPs), classes and

objects form the basic foundation of a system. Inheritance is one of the most important concepts of

OOPs. This Air Cargo Management System project has only small scope. The system contains

different relevant modules such as transactions. It has 2 sides of user interfaces which are

the Admin Panel and the Public-Side. The visitor can browse the site and read some information

such as the 'Welcome' and 'About Us' contents. It also allows the company/business clients to

trace or track their shipment on the website. The system will require the clients to enter their

shipment reference code for tracing their shipment or cargo. The Admin Panel is the side of the

system which is accessible only to the management. This side is managed by 2 types of user roles

which are the Administrators and Staff. The Administrator users have the privilege to access and

manage all the features and functionalities on the said system side. While the Staff has only

limited permission. The system generates a printable transaction detail where the client shipment

and cargo information are listed. In this system, the shipment cargo prices will depend on the cargo

types. Each cargo type has 3 types of prices which are the City to City Price, State to State Price,

and Country to Country Price. The prices will be multiplied by the cargo's weight (kg.) when

calculating the total amount of the transaction.

Department of CSE, SJBIT Page 4

 DATABASE MANAGEMENT SYSTEM 21CS53

1.1 BACKGROUND STUDY:

a) An air cargo management system is a web-based solution that controls every stage of an air
cargo shipment, from acceptance to final delivery. It's designed to improve air cargo
services, streamline cargo operations, and ensure effective cargo and freight
management.

b) Cargo booking software provides end-to-end solutions involved in cargo processing and
management. nGen RES is a solution that offers an intuitive user experience with an easy-
to-use UI.

c) An air cargo management course provides a comprehensive overview of the air cargo
industry. The industry is important in the field of logistics, world trade, and supply chain
management.

d) Cargo management refers to the handling of activities in the logistic centres and warehouse
which includes transporting cargo, unloading cargo, picking, sorting, and warehousing.

1.2 PROBLEM STATEMENT:

Air Cargo Manager is a comprehensive air cargo management module, designed for addressing the
areas of General cargo, Bulk cargo operations through Aviation. All The aspects of cargo like documentation
handling, movement, and storage are addressed in this module. Subsequently, this study seeks to answer
the following problems:
a) How does an air cargo management system help a company manage its cargo?
b) How does an air cargo management system help a company save money?
c) What are some of the challenges that air cargo management systems face?
d) How can air cargo management systems be improved?
e) How can air cargo management systems be used to improve customer satisfaction?

1.3 OBJECTIVE:
a) This applied research aims to design, develop and implement air cargo management system.
This web-based application provides:
b) General Cargo Booking (Manifestation of cargo)
• Storing of Cargo (actual cargo weight, volume etc. are recorded)
• Generating the gate pass for bringing the cargo into the warehouse

Department of CSE, SJBIT Page 5

 DATABASE MANAGEMENT SYSTEM 21CS53
• Marking the truck exit • Delivery order for rejected or damaged cargo
• Generating gate pass for redelivery of cargo
• Housekeeping movements for maintenance i.e., moving the cargo from one place to
another
• Extensive report and querying facilities • Creation of master like cargo agents,
commodity master.

1.4 FUTURE SCOPE:

a) Sustainable aviation initiatives
b) Drone delivery services
c) AI and automation integration
d) Improved cargo tracking
e) Cybersecurity measures
f) Revamped supply chain strategies
g) Digital approach to air cargo service

1.5 PROJECT PROPOSAL

An air cargo management system is a process that helps track, execute, and
facilitate the routes of outgoing and incoming shipments. It can help with the
following:
a) Efficiency: The system helps to ensure that the process is error-free and hassle-free.
b) Planning: The system helps with proper planning and analysis of the process.
c) Resource utilization: The system helps to utilize resources effectively, which can lead to zero
wastage of manpower and time.
d) Customer satisfaction: The system helps to provide complete transparency, which can lead
to complete customer satisfaction.
e) Cargo tracking: The system helps to track the entire cargo process, which gives the
customer assurance.

1.6 SIGNIFICANCE OF THE PROBLEM:

a) Planning: Helps with the planning and analysis of the process

b) Tracking: Helps track the entire cargo process

c) Efficiency: Helps utilize resources effectively, leading to zero wastage of both manpower

Department of CSE, SJBIT Page 6

 DATABASE MANAGEMENT SYSTEM 21CS53

d) Transparency: Helps with complete transparency leading to complete customer satisfaction

e) Error reduction: Helps ensure that the process is simple, error-free, and shipments are
properly managed
f) Knowledge sharing: Helps knowledge is easily shared among all users, allowing for speedy
answers to problems and cost reduction

CHAPTER 2: REVIEW OF LITERATURE

2.1 INTRODUCTION:
This section discusses findings and observations done by some research works on web based
air cargo management system. The gathered information on these related papers strengthens and
supports the research study.

2.2 LITERATURE STUDIES:

With increasing globalization, the air cargo industry has continued to serve as a key facilitator of

world trade and has doubled in volume every 10 years since 1970 (Chang et al., 2007). Goods

transported by air account for 36% by value of all goods traded globally (IATA, 2006). Worldwide,

air cargo transport has grown about 50% faster than passenger transport during 1995 and 2004

(Wong et al., 2009) and continues to grow in recent years. Air cargo transport is becoming a

significant revenue source for airlines (Han et al., 2010, Nobert and Roy, 1998), whose profit has

climbed to 40% in average in 2009 from about only 5% in 2000. Boeing (2014) forecasts that the air

cargo market will continue to grow by 4.7% per year and will triple in revenue by 2033 from 207.8

billion revenue ton kilometres (RTKs) in 2013 to over 521.8 RTKs in 2033 (see Fig. 1). This growth is

largely attributed to the expansion in Asian markets, particularly in China, as shown in Fig. 2

(Petersen, 2007). Several factors drive this dramatic growth, including the rapidly growing global

trade, the high demand for fast and timely delivery, and firms’ efforts to keep a low inventory

through frequent replenishments (Li et al., 2009, Ou et al., 2010).

Department of CSE, SJBIT Page 7

 DATABASE MANAGEMENT SYSTEM 21CS53
Airlines are challenged to manage their air cargo operations efficiently by developing strategic

operation plans that allow these airlines to promptly adapt and respond to changes in the global

competitive environment (Nobert and Roy, 1998, Ferguson et al., 2013). In response to such

challenges, an increasing amount of theoretical research has been conducted to address the

problems in air cargo operations since the 1990s. However, most problems, real-world problems in

particular, remain unsatisfactorily solved, partly because of the complexities of air cargo operations.

Therefore, this study aims to present the challenges faced by the air cargo transport industry

through a comprehensive review of the literature on all aspects of air cargo operations and through

a comparison of previous theoretical research with practical realities. In particular, we aim to

develop a big picture of air cargo operations to show the highly interdependent decisions among

many interfaces and players.

The rest of this paper is organized as follows. Section 2 describes air cargo transport processes and

Identifies their latent features. Section 3 categorizes and tabulates the air cargo literature. Section 4

presents real-world decision problems in the air cargo industry, highlights the gaps between

academic research and realities and then suggests new research opportunities.

In this work, we reviewed the literature on air cargo operations and compared state-of-the-art

theories with real-world practices. We first described the air cargo industry and then analyzed the

characteristics of air cargo operations compared with air passenger operations. Then, we conducted

a bibliographic survey of the literature on air cargo operations, in which we focused on studies that

used quantitative models from the perspectives of airlines, freight forwarders, and the air cargo.

2.3 CONCLUSION:
In conclusion, Air Cargo handling equipment plays a pivotal role in logistics. It ensures that goods
are delivered safely and punctually, connecting businesses and consumers globally. As technology
continues to evolve, so will the capabilities of these machines, driving further advancements in the
Air Cargo industry.

Department of CSE, SJBIT Page 8

 DATABASE MANAGEMENT SYSTEM 21CS53

CHAPTER 3: REQUIRMENTS AND MODULES

3.1 HARDWARE AND SOFTWARE REQUIRMENTS:
a) Processor : Intel Core i3
b) Processor Speed : 13 GHz
c) RAM Size : 4 GB RAM (min) Minimum
d) Disk Space: 100 GB Space(min)
e) Operating System : Windows
f) Processor Speed : 13 GHz Software Requirements

a) Back End : MYSQL

b) Server : XAMPP
c) Front End : PHP, CSS, JavaScript
d) Google Chrome/Internet Explorer/Microsoft Edge

DATABASE USED:
a) MySQL

3.2 MODULES:
a) Cargo pricelist: Used to add, edit, and report price lists for different materials
in the cargo transport
b) Airway bill automation: Used to create and submit air waybills along the supply
chain
c) Direct airline connectivity: Used to view air freight carrier schedules and book
storage space
d) Improved shipment visibility: Used to track air cargo routes in real time
e) Shipment tracking: Used to provide a real-time view of shipment progress
f) AWB stock control: Used to maintain AWB stock and monitor usage and
current stock levels

Department of CSE, SJBIT Page 9

 DATABASE MANAGEMENT SYSTEM 21CS53

CHAPTER 4: DESIGN AND APPLICATION

4.1 DESIGN:

An air cargo management system (CMS) is a web-based solution that controls every step of
air cargo shipment, from acceptance to final delivery. CMSs are designed to:
a) Streamline cargo operations

b) Improve air cargo services

c) Ensure effective cargo and freight management

d) Automate workflows

e) Optimize cargo space

f) Ensure regulatory compliance

g) Provide real-time visibility into shipment status

Department of CSE, SJBIT Page 10

 DATABASE MANAGEMENT SYSTEM 21CS53

4.2 APPLICATION AND USAGES:

An air cargo management system is a web-based platform
that helps airlines manage all stages of air cargo shipments. It
can help with:

a) Streamlining:
Air cargo management systems can streamline and make transactions more
accurate.

b) Tracking routes:
Air cargo management systems can help with tracking routes, including the
outbound process from receiving goods to loading them onto aircraft.

c) Providing real-time data:

Air cargo management systems can provide real-time data to help with
business insights and achieving maximum productivity.

d) Integration with other systems:

Air freight software solutions can integrate with other systems, including
warehouse management systems, enterprise resource planning systems, and e-
commerce platforms.

Department of CSE, SJBIT Page 11

 DATABASE MANAGEMENT SYSTEM 21CS53

Other applications of air cargo management systems include:

a) End-to-end cargo reservations

b) Cargo revenue accounting

c) Warehouse management

d) Cargo GSSA management

e) Express door-to-door management

f) International freight forwarding management

Department of CSE, SJBIT Page 12

 DATABASE MANAGEMENT SYSTEM 21CS53

CHAPTER 5: ENTITY- RELATION

Department of CSE, SJBIT Page 13

 DATABASE MANAGEMENT SYSTEM 21CS53

SCHEMA DIAGRAM:

FIG 5.2: SCHEMA DIAGRAM

Department of CSE, SJBIT Page 14

 DATABASE MANAGEMENT SYSTEM 21CS53

CHAPTER 6: System Snapshots of some features:

FIG:6.1: Trace Shipment Page (Public)

Department of CSE, SJBIT Page 15

 DATABASE MANAGEMENT SYSTEM 21CS53

FIG 6.2: Cargo Type List (Admin-Panel)

FIG 6.3: Transaction Form (Admin-Panel)

Department of CSE, SJBIT Page 16

 DATABASE MANAGEMENT SYSTEM 21CS53

FIG:6.4: Transaction Details (Admin-Panel)

Department of CSE, SJBIT Page 17

 DATABASE MANAGEMENT SYSTEM 21CS53

CHAPTER 7: SUMMARY, CONCLUSION, RECOMMENDATION

7.1 SUMMARY AND CONCLUSION:

Cargo Management System is a comprehensive web-based solution for controlling every

stage of air cargo shipment from acceptance to final delivery. This digital platform is

designed to streamline airlines' cargo operations, improve air cargo services, and ensure

effective cargo and freight management. Air cargo is another term for air freight. It is the

carriage or the transportation of goods through an air carrier. Transport services via air are

the most valuable when it comes to moving express shipments around the globe and it

consists of air mail, air freight and air express. An air cargo management system is a

web-based solution that controls every stage of air cargo shipments, from acceptance
to final delivery. It's designed to improve air cargo services, streamline cargo
operations, and ensure effective cargo and freight management. After accepting

shipments ready for carriage, airport cargo and ground handling personnel can prepare the

air cargo for flight. The goods in transit must be received and security cleared once again.

Goods left on the aircraft that are in transit are considered transit cargo.

7.2 RECOMMENDATIONS:
Here are some air cargo management systems:

a) Cargo Flash
Offers end-to-end cargo reservations, revenue accounting, warehouse
management, and more
b) iCargo
A cloud platform for air cargo management and collaboration with
stakeholders

c) Shipthis

An AI-powered freight forwarding software that can help streamline a

team's workflow
Department of CSE, SJBIT Page 18
 DATABASE MANAGEMENT SYSTEM 21CS53

d) Minimize human error

Cargo management systems can process data seamlessly, saving time
and effort.

e) Provide real-time data

An on-demand air cargo monitoring solution can provide real-time,
relevant sensor data.

f) Improve transparency
Air cargo management systems can provide access to real-time data.

g) Provide an all-in-one place for data

Air cargo management software can provide document generation and
keep all data in one place.

h) Provide solutions for key processes

CARGOSTACK's Revenue Management solution provides tools for
inventory control, revenue optimization, and capacity management

7.3 REFERENCES:
K. Amaruchkul et al.
Air-cargo capacity allocation for multiple freight forwarders
Transp. Res. Part E
(2011)
F. Azadian et al.
Dynamic routing of time-sensitive air cargo using real-time information
Transp. Res. Part E
(2012)
F.T.S. Chan et al.
Development of a decision support system for air-cargo pallets loading problem: a
case study
Expert Syst. Appl.
(2006)
C.K. Chan et al.
Agent-based flight planning system for enhancing the competitiveness of the air cargo

Department of CSE, SJBIT Page 19

 DATABASE MANAGEMENT SYSTEM 21CS53

industry
Expert Systems with Applications
(2012)
Y.H. Chang et al.
A survey and optimization-based evaluation of development strategies for the air
cargo industry
Int. J. Prod. Econ.
(2007)
E.P. Chew et al.
Short-term booking of air cargo space
Eur. J. Oper. Res.
(2006)
U. Derigs et al.
Solving a real-world vehicle routing problem with multiple use of tractors and trailers
and EU-regulations for drivers arising in air cargo road feeder services
Eur. J. Oper. Res.
(2011)
J. Ferguson et al.
Estimating domestic US airline cost of delay based on European model
Transp. Res. Part C: Emerging Technol.
(2013)
S. Gontarz et al.
Use of magnetic monitoring of vehicles for proactive strategy development
Transp. Res. Part C: Emerging Technol.

Department of CSE, SJBIT Page 20