Figure $5\mathrm{.}6$

One possible database state for the COMPANY relational database schema.

EMPLOYEE

DEPARTMENT

DEPT$\_$LOCATIONS

WORKS$\_$ON

PROJECT

DEPENDENT

A courier company maintains up$-$to$-$date information on the processing and current location of

each shipped item. To do this, the courier relies on a company$-$wide system described as follows:

Shipped items are the heart of the courier product tracking information system. Shipped

items can be characterized by item number $($unique$),$ weight, dimensions, insurance

amount, destination, and final delivery date.

Shipped items are received into the courier system at a single retail center. Retail centers

are characterized by their type, unique ID$,$ and address.

Shipped items make their way to their destination via one or more standard the courier

transportation events $($i$.$e$.,$ flights, truck deliveries$).$ These transportation events are

characterized by a unique schedule number type $($e$.$g$.,$ flight, truck$)$ and a delivery route.

Create an Entity Relationship diagram that captures this information about the courier system.

Be certain to indicate identifiers and cardinality constraints.