Movers and Packers Management System

Movers and Packers Management System
Chapter 1
1. INTRODUCTION
1.1 Aim of the project
 Easy to generate report booking and queries.
 Provide an interactive platform between clients and packers and Movers Company.
 It is very much faster than manual system.
 Easy and fastest record finding technique.
 It is very much flexible to work.
 It is very user oriented.
 Data can be stored for a longer period.
1.2 Overview of the project
Packers and Movers Management System is software which provide an interactive

platform between users and packers and Movers Company. This project provides best and
reliable services in relocating. Users can book the services through this web portal.
In proposed system we do not have to maintain everything manually. Through this system if any
enquiry occurs it is corresponding entries is done automatically because database management
system gives facility of having relationship between the tables.
1|Page
Dept. of CSE, BGSIT, B.G NAGAR 2020-21
1.3 Outcome of the project

Present system is manual. The Project Metrics has to enter all the details of the project,
documents, and tasks. It also maintenance the team information and also efforts estimation.
 Easy to generate report.
 It is very much faster than manual system.
 Easy and fastest record finding technique.
 It is very much flexible to work.
 Man power required is very less.
Data can be stored for a longer period.
1.4 Software requirements
 Operating system: Windows XP
 Tools: PHP Triad (PHP, MySQL, Apache, and PHPMyAdmin)
Hardware Requirement
This software requires following minimum hardware configuration
 Processor: Pentium-iv and above
 RAM: 256 MB
 Hard Disk: 4.3GB
 Floppy Disk: 1.44 MB
 CD Drive
2|Page
Chapter 2
2. DESIGN
2.1 Schema Diagram
Fig 2.1 schema diagram
3|Page
2..2 Use case diagram
Fig.2.2.1 Use Case Diagram User
4|Page
Fig.2.2.2 Use Case Diagram Admin
5|Page
2.3 Data Flow Diagram
6|Page
Fig.2.3.1 User Chart User
Fig.2.3.2 User Chart User
7|Page
2.4 Entity Relation Diagram
Fig:2.4 Database Entity Relation Diagram
8|Page
Chapter 3
3. IMPLEMENTATION
3.1 Description of tables
v mpmsdb tbladmin
ID : int(10)
AdminName : varchar(50)
UserName : varchar(50)
MobileNumber : bigint(10)
Email : varchar(120)
Password : varchar(200)
AdminRegdate : timestamp
v mpmsdb tblcontact
ID : int(10)
Name : varchar(200)
Telephone : bigint(10)
Subject : mediumtext
Message : mediumtext
RequestDate : timestamp
IsRead : int(5)
v mpmsdb tblpage
ID : int(10)
PageType : varchar(50)
PageTitle : mediumtext
PageDescription : mediumtext
UpdationDate : timestamp
9|Page
v mpmsdb tblservices
ID : int(10)
Title : varchar(200)
Description : mediumtext
Image : varchar(200)
CreationDate : timestamp
v mpmsdb tbluser
ID : int(10)
Name : varchar(120)
Location : varchar(200)
ShiftingLoc : varchar(200)
ShiftingDate : varchar(200)
BreifItems : mediumtext
Items : mediumtext
Professional : varchar(200)
RequestDate : timestamp
Remark : varchar(200)
Status : varchar(50)
UpdationDate : timestamp
10 | P a g e
3.2 Backend Implementation
3.2.1 MySQL Server
SQL (Structured Query Language) is a domain-specific language used in programming and

designed for managing data held in a relational database management system (RDBMS), or for
stream processing in a relational data stream management system (RDSMS). In comparison to
older read/write APIs like ISAM or VSAM, SQL offers two main advantages: first, it introduced
the concept of accessing many records with one single command; and second, it eliminates the
need to specify how to reach a record, e.g. with or without an index.
Originally based upon relational algebra and tuple relational calculus, SQL consists of a data
definition language, data manipulation language, and data control language. The scope of SQL
includes data insert, query, update and delete, schema creation and modification, and data access
control. Although SQL is often described as, and to a great extent is, a declarative language
(4GL), it also includes procedural elements. SQL was initially developed at IBM by Donald D.
Chamberlin and Raymond F. Boyce in the early 1970s. This version, initially called SEQUEL
(Structured English Query Language), was designed to manipulate and retrieve data stored in
IBM's original database management system, System R, which a group at IBM San Jose
Research Laboratory had developed during the 1970s.
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 directly 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
3.2.2 Normalization
Normalization is the process of efficiently organizing data in a database. There are two
goals of the normalization process: eliminating redundant data (for example, storing the same
data in more than one table) and ensuring data dependencies make sense (only storing related
data in a table). Both of these are worthy goals as they reduce the amount of space a database
consumes and ensure that data is logically stored. There are several benefits for using
Normalization in Database.
11 | P a g e
Benefits
• Eliminate data redundancy

• Improve performance
• Query optimization
• Faster update due to less number of columns in one table Index improvement
There are different types of normalizations form available in the database.
1.First Normal Form (1NF)
First normal form (1NF) sets the very basic rules for an organized database:
• Eliminate duplicative columns from the same table.
• Create separate tables for each group of related data and identify each row with
unique column or set of columns (the primary key).
• Remove repetitive groups
• Create Primary Key
Before we proceed let's understand a few things -- A KEY is a value used to identify a record in
a table uniquely. A KEY could be a single column or combination of multiple columns Note:
Columns in a table that are NOT used to identify a record uniquely are called non-key columns.
Primary Key
2.Second Normal Form(2NF)
Second normal form(2NF) further address the concept of removing duplicative data:
12 | P a g e
• Meet all the requirements of the first Normal form.

• Remove the subset of data that apply to multiple rows of a table and place them in
separate tables.
3.Third Normal Form (3NF)
Third normal form (3NF) goes one large step further:

• Meet all the requirements of the second normal form.
• Remove columns that is not dependent upon the primary key.
4. Fourth Normal Form (4NF)
Finally, fourth normal form (4NF) has one additional requirement:

• Meet all the requirements of the third normal form.
• A relation is in 4NF if it has no multi-valued dependencies.
If PK is composed of multiple columns, then all non-key attributes should be derived from FULL
PK only. If some non-key attribute can be derived from partial PK then remove it. The 4NF also
known as BCNF NF.
3.3 Front End Implementation
3.31 Algorithms
Index
1. Display options home page and quotation page for the new booking.
2. Link corresponding pages to them.
Register
1. Connect to database.
2. Read customers’ name, email, phone number, address.
3. Check if any of the field is null.
4. If any of the field is null then,
5. Display warning message.
6. Else insert the values into the corresponding table and show successfully registered.
13 | P a g e
Admin login
2. Read admin name and password using post method.
3. If the entered values are correct then,
4. Redirect to admin operation.
5. Else show error message.
Admin operations
1. Show admin operations such as,

2. View customer, view payment, view new bookings.
View customers:
2. Retrieve the customers’ name, email, phone number, address from the corresponding
table.
3. Display the details in the form of table.
View Bookings
2. Retrieve the location shift from, location shift to, brief of items, items to be shift, and date of
shifting from the corresponding table.
View payment
2. Retrieve the payment amount and payment type.
14 | P a g e
Chapter 4
4. RESULT AND ANALYSIS
4.1 Snapshots
Fig.4.1 Index page
15 | P a g e
Fig.4.2 Service Page
16 | P a g e
Fig.4.3 About Us
17 | P a g e
Fig.4.4 Request Quote Page

18 | P a g e
Fig.4.5 Contact Us Page
19 | P a g e
Fig.4.6 Admin Login Page
20 | P a g e
Fig.4.7 Admin Dashboard
21 | P a g e
Fig.4.8 Admin’s Profile
22 | P a g e
Fig.4.9 Add Service
23 | P a g e
Fig.4.10 Manage Service
24 | P a g e
Fig.4.11 View Users
25 | P a g e
Fig.4.12 Booking Details
26 | P a g e
Fig.4.13 Search Booking
27 | P a g e
Fig.4.14 Forgot Password
4.2 Discussion
Project use: It is used in door to door services of shifting your goods. It is used by packers and movers to
move your heavy furniture, heavy electronic item.
Benefits: Below are some benefits of hiring packers and movers in
Safety: The main concern while relocating is the safety of the goods and packers and movers in Pune
provides that only. They pack the goods with right packing method and in appropriate container that
prevents the goods from damages.
Insurance: One of the best benefits is the insurance that a reliable moving company does for the safety
of the goods against damages. With this all the losses will be compensated to you if occur any during
relocation.
Convenience: You need to only discuss your requirements and demands regarding moving and shifting
and the rest will be handle by the packers and movers. You need not to put any efforts in the shifting
process rather you can simply enjoy hassle free move with them by just seeing them working as per
needs and demands.
Cost Effective: If you will follow the DIY process you could cost a lot for labor costing, transportation
charges, packaging materials etc. but with packers and movers in Pune you only have to pay their fee
that is much lesser than the DIY process expenses.
28 | P a g e
Chapter 5
5. CONCLUSION AND FUTURE ENHANCEMENT
Conclusion
The project titled as Movers & Packers Management System was deeply studied and analyzed to
design the code and implement. It was done under the guidance of the experienced project guide.
All the current requirements and possibilities have been taken care during the project time.
Movers & Packers Management System is used for daily operations in any organization to
maintain or access employee related information for internal administration purposes.
Future Enhancement
1.In future we can add an option customer feedback.

2.We can add option chat between customer and admin to clear their doubts.
3.We can make it national level movers and packers management system.
Chapter 6
6. REFERENCES
[1] Fundamentals of Database Management System by Pearson author Navathe 7th.

[2] PHP Pandas by Daylee Rees.
[3] Learn to code HTML and CSS by Shay Howe.
29 | P a g e

Movers and Packers Management System

Uploaded by

Copyright:

Available Formats

Movers and Packers Management System

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Movers and Packers Management System

Uploaded by

Copyright:

Available Formats

Movers and Packers Management System

1.1 Aim of the project

 Easy to generate report booking and queries.

 It is very much faster than manual system.

 Easy and fastest record finding technique.

 It is very much flexible to work.

 It is very user oriented.

 Data can be stored for a longer period.

1.2 Overview of the project

Packers and Movers Management System is software which provide an interactive

1.3 Outcome of the project

 Easy to generate report.

 It is very much faster than manual system.

 Easy and fastest record finding technique.

 It is very much flexible to work.

 Man power required is very less.

Data can be stored for a longer period.

1.4 Software requirements

 Operating system: Windows XP

 Tools: PHP Triad (PHP, MySQL, Apache, and PHPMyAdmin)

This software requires following minimum hardware configuration

 Processor: Pentium-iv and above

 Hard Disk: 4.3GB

 Floppy Disk: 1.44 MB

Fig 2.1 schema diagram

2..2 Use case diagram

Fig.2.2.1 Use Case Diagram User

Fig.2.2.2 Use Case Diagram Admin

2.3 Data Flow Diagram

Fig.2.3.1 User Chart User

Fig.2.3.2 User Chart User

2.4 Entity Relation Diagram

Fig:2.4 Database Entity Relation Diagram

3.2 Backend Implementation

3.2.1 MySQL Server

SQL (Structured Query Language) is a domain-specific language used in programming and

• Eliminate data redundancy

There are different types of normalizations form available in the database.

1.First Normal Form (1NF)

2.Second Normal Form(2NF)

• Meet all the requirements of the first Normal form.

3.Third Normal Form (3NF)

Third normal form (3NF) goes one large step further:

4. Fourth Normal Form (4NF)

Finally, fourth normal form (4NF) has one additional requirement:

3.3 Front End Implementation

1. Show admin operations such as,

4. RESULT AND ANALYSIS

Fig.4.1 Index page

Fig.4.2 Service Page

Fig.4.4 Request Quote Page

Fig.4.5 Contact Us Page

Fig.4.6 Admin Login Page

Fig.4.7 Admin Dashboard

Fig.4.8 Admin’s Profile

Fig.4.9 Add Service

Fig.4.10 Manage Service

Fig.4.11 View Users