An employee may be assigned to many projects. Some employees have not been

assigned to any projects. A project must be assigned to at least 1 employee. The

employees attributes needed are (telephone, email and office number). The

projects attributes needed are (title, duration). For every employee that is

assigned to a project the number of allocated work hours to the particular

project must be defined.

a. Create an E-R diagram with surrogate primary key, if it is necessary.

b. Produce the cardinality Min and Max functions

c. Create an ERM diagram