A well-known delivery company wishes to implement a customer program, which allows managing its customers' information according to their regularity. The information that is recorded each time a customer requests service is the following: customer name, general data (address, telephone number, etc.), time of the request, time of delivery, type of delivery, location of the place where the package is picked up, site of the messenger at the time of acceptance of the service, total distance travelled including travel to the pick-up point and trip to the delivery point, total time of the delivery process (time of delivery confirmation - time of acceptance of the service), amount of product picked up, amount of service, amount of tip (can be 0), and type of payment (cash, visa, etc.).

    Using ER-merise language or UML language, propose a conceptual database schema representing regular customer information. Identify entities (e.g., DeliveryType, Customer, Service) specifying their attributes and domains and their associations and cardinalities.

    Transform the conceptual schema from the previous question into a logical schema. Use the rules to move from the entity-relationship model to a relational schema.

Answer rating: 100% (QA)

Entity Customer Attributes customer name general data address telephone number etc time of the request time of delivery type of delivery location of t... View the full answer