Package Delivery Website [WEB]

For my part, I completed package 2 which entailed these features:

Basic Features:

1. Upon receiving a parcel, the station manager will search for the parcel delivery record based on the “Parcel ID” and assign it to a delivery man. The system should update the delivery status of the parcel to “delivery to destination in progress”. (See "Parcel" Table for details.). A record associated to the “Parcel ID” should be inserted in the “DeliveryHistory” table, with the description: e.g., “Received parcel by StationMgrSG on 29 Mar 2023 4:00pm.” (Note: StationMgrSG is the Login ID of the station manager.)

2. The delivery man can view a list of parcel delivery records assigned to him, with the status of “delivery to destination in progress”. After completing the tasks assigned, the delivery man will update the delivery status as follows: • For local delivery, update the status to “delivery completed” once the delivery is successful. A record associated to the “Parcel ID” will be inserted in the “DeliveryHistory” table with the description: e.g., “Parcel delivered successfully by abc1 on 30 Mar 2023 10:00am.” (Note: abc1 is the Login ID of the delivery man.) • For overseas delivery, update the status to “delivery to airport in progress” after delivered to airport. A record associated to the “Parcel ID” will be inserted in the “DeliveryHistory” table, with a description: e.g., “Parcel delivered to airport by abc1 on 30 Mar 2023 1:00pm.” (Note: abc1 is the Login ID of the delivery man.)

Advanced Features:

3. When the station manager assigns a parcel to a delivery man, the system should validate that the delivery man can only be assigned with a maximum of 5 parcels with status of “delivery to destination in progress”.

4. For each unsuccessful delivery, e.g., parcel receiver is not found, wrong address, parcel damaged, etc., the delivery man will update the delivery status to “delivery failed” and create a "Delivery Failure Report" in the system explaining the situation. (See "DeliveryFailure" Table for details.) System to ensure that only parcel delivery records with the status of “delivery failed” are allowed to create “Delivery Failure Report”.