Create an entity relationship diagram $($ERD$)$ for the following scenario. Draw the entities, attributes,

and relationships $($including cardinality$).$ Remember, entities should all have unique identifiers. Use UML notations.

Scenario:

A local package delivery company wants to track its deliveries. This involves keeping track of packages

and the clients who send and receive them. The company also wants to keep track of its drivers and

trucks that delivered a particular package.

Each package has a weight, shipping cost, pick up date, and delivery date. A package has exactly two

clients involved, a sender and receiver. A client is designated as a sender or receiver depending on

the particular package. The database should track clients' first name, last name, street, city, state, zip

code, email, and phone number. Each client is associated with at least one package, but can be

associated with many packages.

A package is loaded to at most one truck for delivery. A truck is described by its VIN $($i$.$e$.,$ vehicle

identification number, which is unique for each truck$),$ make $($i$.$e$.,$ the maker of the vehicle$),$ and

model. A truck can load many packages, but the company also wants to track trucks that haven$$t

loaded any package yet $($such as new trucks$).$

A truck may have no driver assigned $($if it is a new truck$)$ and can have different drivers over time.

When a driver is assigned to a truck, the date and shift are recorded. Drivers$$ information needs to be

entered before they are assigned to any truck $($that is$,$ new drivers may have zero truck assigned$).$ A

driver may be assigned to drive different trucks over time. Recorded for each driver is first name, last

name, and SSN$.$

Finally, the company also wants to track complaints filed by the clients. A client can file multiple

complaints. Each complaint corresponds to one package, though it's possible for the same package to

have multiple complaints. Recorded for each complaint is the date, time, and description of the

complaint.