Why we design this Website?

With the development of internet and logistics, more and more people choose to purchase online. It brings many conveniences to people, but some problems are generated at the same time. One of those difficulties is that people are hard to locate particular procedure or person when they receive a broken package. Thus, we want to create an information system for tracking the delivery of specific goods, and we aim to establish a large-scale network that keeps following all the deliveries so that users can interact with easily. Meanwhiles, administrators can monitor the package tracking status and work productivity of staffs at any time. In this way, both efficiency and quality in logistics can be improved.


What can we do?

In our websites, we will record and provide following information for users:
• Personnel information (ID) of Customers, Couriers, truck drivers;
• Information (location, status, ID) of goods that is to be delivered;
• Database of stations within each city with IDs.


Our Features

• Customers can track goods with ID;
• Couriers handles delivery from station to the customer’s address: they update the goods’ status during delivery;
• Truck drivers handles goods transfers from station to station when the destination of the goods and the current station does not match;
• Couriers can select what goods they want to handle instead of system auto-assign; Admins have rights to monitor delivery and transfer specifics.


Our Design

1. Customers have attributes: customer_ID, name, address (unit number, avenue, city);
2. Goods have attributes: goods_ID, current location (station), status, destination (address), assigned_truck_ID (handles transfer), assigned_courier_ID (handles delivery);
3. Courier have attributes: courier_ID, name, working location, packages delivered;
4. Truck drivers have attributes: driver_ID, current station, next station, packages transferred;
5. Staff members have attributes: staff_ID, name, and working location;
6. Password databases: one for customers; one for couriers, staffs, and drivers; another for admin/manager;
7. Customers can register themselves; couriers, drivers and staffs are registered by admin;
8. Customers can track goods by logging into their account and using the good’s ID to find additional information:
(1) Current status of goods
• In station
•Transferring station
• Awaiting delivery
• In delivery
• Delivered
(2) Location of goods
(3) Courier information (assigned_courier_ID, courier name);
9. Goods that are in “awaiting delivery” status will be handled by Couriers, they will only deliver goods that are in the station where they work. Besides, Couriers need to check off all the goods before delivering, then updates the status from “awaiting delivery” to “in delivery”. Once the goods are delivered to customers, the courier needs to change the status from “in delivery” to “delivered”;
10. Goods that are “in station” will be handled by truck drivers, they will only transfer goods if drivers and goods have the same destination. Truck drivers need to check off all the goods before they begin to transfer, then updates the status from “in station” to “transferring station”. Once they are at the destined station, the driver updates the status again, from “transferring station” to “awaiting delivery”;
11. Once truck drivers arrive at their “next station”, a new destination is given and goods matching their destination will be transferred;
12. Staff members assign routes to truck drivers, and distribute destinations for drivers;
13. Admins have access to all information such as number of goods handled by each courier and driver, and also the entire list of goods. Besides, they can also search for each individual goods with goods_ID;

Image Description