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
Movers and Packers Management System

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
Dept. of CSE, BGSIT, B.G NAGAR 2020-21
Movers and Packers Management System

Chapter 2

2. DESIGN
2.1 Schema Diagram

Fig 2.1 schema diagram

3|Page
Dept. of CSE, BGSIT, B.G NAGAR 2020-21
Movers and Packers Management System

2..2 Use case diagram

Fig.2.2.1 Use Case Diagram User

4|Page
Dept. of CSE, BGSIT, B.G NAGAR 2020-21
Movers and Packers Management System

Fig.2.2.2 Use Case Diagram Admin

5|Page
Dept. of CSE, BGSIT, B.G NAGAR 2020-21
Movers and Packers Management System

2.3 Data Flow Diagram

6|Page
Dept. of CSE, BGSIT, B.G NAGAR 2020-21
Movers and Packers Management System

Fig.2.3.1 User Chart User

Fig.2.3.2 User Chart User

7|Page
Dept. of CSE, BGSIT, B.G NAGAR 2020-21
Movers and Packers Management System

2.4 Entity Relation Diagram

Fig:2.4 Database Entity Relation Diagram

8|Page
Dept. of CSE, BGSIT, B.G NAGAR 2020-21
Movers and Packers Management System

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)
 Email : varchar(120)
 Subject : mediumtext
 Message : mediumtext
 RequestDate : timestamp
 IsRead : int(5)

v mpmsdb tblpage
 ID : int(10)
 PageType : varchar(50)
 PageTitle : mediumtext
 PageDescription : mediumtext
 Email : varchar(120)
 MobileNumber : bigint(10)
 UpdationDate : timestamp

9|Page
Dept. of CSE, BGSIT, B.G NAGAR 2020-21
Movers and Packers Management System

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)
 MobileNumber : bigint(10)
 Email : varchar(200)
 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
Dept. of CSE, BGSIT, B.G NAGAR 2020-21
Movers and Packers Management System

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
Dept. of CSE, BGSIT, B.G NAGAR 2020-21
Movers and Packers Management System

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
Dept. of CSE, BGSIT, B.G NAGAR 2020-21
Movers and Packers Management System

• 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
Dept. of CSE, BGSIT, B.G NAGAR 2020-21
Movers and Packers Management System

Admin login

1. Connect to database.
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:

1. Connect to database.
2. Retrieve the customers’ name, email, phone number, address from the corresponding
table.
3. Display the details in the form of table.

View Bookings

1. Connect to database.
2. Retrieve the location shift from, location shift to, brief of items, items to be shift, and date of
shifting from the corresponding table.
3. Display the details in the form of table.

View payment

1. Connect to database.
2. Retrieve the payment amount and payment type.
3. Display the details in the form of table.

14 | P a g e
Dept. of CSE, BGSIT, B.G NAGAR 2020-21
Movers and Packers Management System

Chapter 4

4. RESULT AND ANALYSIS

4.1 Snapshots

Fig.4.1 Index page

15 | P a g e
Dept. of CSE, BGSIT, B.G NAGAR 2020-21
Movers and Packers Management System

Fig.4.2 Service Page

16 | P a g e
Dept. of CSE, BGSIT, B.G NAGAR 2020-21
Movers and Packers Management System

Fig.4.3 About Us

17 | P a g e
Dept. of CSE, BGSIT, B.G NAGAR 2020-21
Movers and Packers Management System

Fig.4.4 Request Quote Page

18 | P a g e
Dept. of CSE, BGSIT, B.G NAGAR 2020-21
Movers and Packers Management System

Fig.4.5 Contact Us Page

19 | P a g e
Dept. of CSE, BGSIT, B.G NAGAR 2020-21
Movers and Packers Management System

Fig.4.6 Admin Login Page

20 | P a g e
Dept. of CSE, BGSIT, B.G NAGAR 2020-21
Movers and Packers Management System

Fig.4.7 Admin Dashboard

21 | P a g e
Dept. of CSE, BGSIT, B.G NAGAR 2020-21
Movers and Packers Management System

Fig.4.8 Admin’s Profile

22 | P a g e
Dept. of CSE, BGSIT, B.G NAGAR 2020-21
Movers and Packers Management System

Fig.4.9 Add Service

23 | P a g e
Dept. of CSE, BGSIT, B.G NAGAR 2020-21
Movers and Packers Management System

Fig.4.10 Manage Service

24 | P a g e
Dept. of CSE, BGSIT, B.G NAGAR 2020-21
Movers and Packers Management System

Fig.4.11 View Users

25 | P a g e
Dept. of CSE, BGSIT, B.G NAGAR 2020-21
Movers and Packers Management System

Fig.4.12 Booking Details

26 | P a g e
Dept. of CSE, BGSIT, B.G NAGAR 2020-21
Movers and Packers Management System

Fig.4.13 Search Booking

27 | P a g e
Dept. of CSE, BGSIT, B.G NAGAR 2020-21
Movers and Packers Management System

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
Dept. of CSE, BGSIT, B.G NAGAR 2020-21
Movers and Packers Management System

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
Dept. of CSE, BGSIT, B.G NAGAR 2020-21