3B - Courier Delivery System PDF

Preview

Summary

ICTDATABASE MANAGEMENT SYSTEMPROJECTCOURIER DELIVERY SYSTEMGROUPD1CS2413BGROUP MEMBERSNAME STUDENT IDSITI FASIHAH AUNI BT AMIR 2020819406NURIZZATI NABILA BT ZAIDI 2020489552NUR ADDYANA BT MAN 2020605026SARAH IZZATI BT MOHAMMAD SABRI 2020819972PREPARED FOR:MADAM MARHANIS JAMALUDINSUBMISSION DATE:21 N...

Description

ICT501 DATABASE MANAGEMENT SYSTEM PROJECT COURIER DELIVERY SYSTEM GROUP D1CS2413B GROUP MEMBERS NAME

STUDENT ID

SITI FASIHAH AUNI BT AMIR

2020819406

NURIZZATI NABILA BT ZAIDI

2020489552

NUR ADDYANA BT MAN

2020605026

SARAH IZZATI BT MOHAMMAD SABRI

2020819972

PREPARED FOR: MADAM MARHANIS JAMALUDIN SUBMISSION DATE: 21 NOVEMBER 2021

1

1) INTRODUCTION BACKGROUND STUDY

In 1986, Pos Malaysia Berhad started offering EMS (Express Mail Service), a service offered through a network of postal administration members of the Universal Postal Union (UPU). Two years later, Pos Malaysia expanded the express and courier services to domestic destinations under the brand name Pos Laju. Initially, Pos Laju only delivered to 5 international destinations, now it’s to over 8.5 million addresses in the country, and to over 200 countries and territories worldwide. Pos Laju has grown to become a household name and the e-Commerce courier of choice in Malaysia.

The brand’s prepaid boxes and envelopes have been in high demand since they were first introduced in 2012. On average, more than half a million units are sold every month, and that volume continues to grow at an exceptional rate. Most online businesses prefer the convenience of Pos Laju’s ‘pay first, pack and post later’ packaging concept as it serves cost- and time saving needs of its customers. Pos Laju offers On Demand Pick-up (ODP) service, a convenient choice for customers to just call for a delivery pick-up straight from their premises, for only an additional service surcharge of RM5.00 per pick-up, regardless of the number of items. Free pick-up service is offered to contract customers. Other convenient touchpoints include Pos Laju Prepaid EziDrop, a 24/7 automated dropbox machine for posting of Pos Laju prepaid items and Pos Laju EziBox, a self service parcel lockers that primarily caters to service missed Pos Laju deliveries to customers who were not at home to receive their parcels. This service will soon be extended to online shoppers to select Pos Laju EziBox as their alternative Pos Laju shipping or delivery address.

We are choosing this courier as a guideline to build our database due to the company’s initiatives allow us to immediately increase our customer touchpoints and better yet, offer more convenient channels that fit today’s busy lifestyle by providing more choices and flexibility for our customers to send or collect packages whenever they want, at strategic locations. Due to this, a good DBMS is needed to make the courier well-functioned and to avoid issues and complaints from the customers regarding the services provided.

2

PROJECT DESCRIPTIONS Pos Laju System has a few problems that keep occurring during the process of delivering packages to the receivers. This is due to ineffective management and the prevalent use of a traditional method. The traditional delivering system brings inconvenience to both staff and customers as it requires a lot of manual work. Therefore, Pos Laju needs to figure out the solutions so that they can improve their management and run their restaurant successfully. The problems statement and proposed solution are: 1)

Pos Laju lacks a single database or mechanism for conveniently tracking any problem of

their documents. Hence, by using a database it would be easier to extract information if the database is properly designed. 2)

Pos Laju still recording data using a book record such as pen and paper. Writing on a

book record can make human errors when recording the data such as address. So that, the item cannot be delivered because of incomplete customer details. Some of the packages cannot be delivered because of incomplete customer detail. Hence, by using a database they can deliver the packaging to customers correctly. 3)

Pos Laju’s data can be stolen easily due to the lack of security and people can change or

steal the information. As a result, Pos Laju's data will be compromised, potentially harming Pos Laju's reputation. Therefore, the database can ensure that the data is more secure by requiring user permission and requiring the user to enter a password. 4)

Pos Laju needs to backup and recovery because the data not be done automatically. They

have to find the data and do it manually. Data also needs to be restored in its original location. It takes a lot of their energy and time because much of it has to be done manually. Therefore, the database could eliminate the need for data redundancy. Because all data will be saved in one database and monitored by the admin coordinator, employing a database system will eliminate the need for multiple copies. Data can also be backed up, and it will be less difficult than utilizing a manual approach. 5)

Pos Laju may also run into big problems in the future when generating delivery reports if

they use a manual file system to store all of their shipments and the company’s data. The manual file system also leads to their inaccurate shipping calculations which can lead to bankruptcy and

3

they are unable to track if their company is at a loss. Hence, by using a database they can easily extract and calculate the data accurately.

OBJECTIVES ●

to build and develop a database system for a courier service that will appropriately monitor and record transactions

●

to manage the details of Courier,Delivery and Customers

●

to make day-to-day work less stressful by automating all manual work in courier-related businesses and replacing it with computer-based work

●

To help in managing for the fast delivery of the couriered items.

●

To provide updates to the customer about the status of the delivery

2) CONCEPTUAL DESIGN

2.1 ) BUSINESS RULE ●

Each customer need to give their and recipient details such as name, phone number and address

●

Each customer is given the option to choose the delivery packages provided

●

Packages status depends on the package that the customer has chosen

●

Every package has their delivery time and date

●

The location for delivery based on package delivery time

●

Each service is provided according to the package delivery time

●

Employees need to arrange packages for delivery

●

Customers can keep tracking their parcel through delivery status

4

2.2 ) ENTITY RELATIONSHIP DIAGRAM (ERD)

5...