When a new customer (sender of the parcels) requests for parcel deliveries, ABC collects many details that are related to them. Among the many information that is required to be collected at that time, the contact phone and email details of the customer are considered to be vital.

Whenever a customer requests a parcel delivery, the parcel-delivery information such as the delivery address and receiver details are collected. Subsequently, one of ABC employees collects the parcel from the sender, verifies whether the address for delivery is mentioned on the parcel, and then creates an invoice for the charges related to its delivery.

For each parcel-delivery, ABC also maintains the details of the employee involved, the date and time of collection/pick up, and delivery. Though most of the parcels are delivered to the specified addressees, some of them occasionally is not deliverable due to incorrect/incomplete delivery address. Such parcels are returned to the senders.

Identify the following: Entities, Relationships, and Primary

Answer rating: 100% (QA)

Entities Customer Parcel Delivery ABC Employee Invoice Relationships A customer requests a parcel delivery onetomany relationship A customer provides ... View the full answer