Question #$2$: $[15$ points$]$

Draw a complete EER diagram based on the following Truck Leasing Company

description.

A truck leasing company $($TLC$)$ is organized in truck operating hubs $($TOH$)$ that are located in

different cities in different countries. Each TOH has an address in a country and a unique TOH

number $($TOH$\_$no$).$ The TLC operates different TRUCKS which are identified by a unique

TRUCK$\_$number. There are three different types of trucks: bulk, container, and tank. The truck

type bul $\frac{?}{\text{b}\text{a}\text{r}}(k)$ and container is characterized by payload, the truck type tank is characterized by

volume. All trucks are characterized by a total weight. Each TOH of the TLC has employees.

There are three types of employees: Office$\_$Employee, Maintenance, and Driver. An employee

is identified by an SSN and contact data. Contact data consists of an address, an email, and a

phone$-$number.