An employee may be assigned to many projects. Some employeeshave not been
assigned to any projects. A project must be assigned to at least1 employee. The
employee’s attributes needed are (telephone, email and officenumber). The
project’s attributes needed are (title, duration). For everyemployee that is
assigned to a project the number of allocated work hours to theparticular
project must be defined.
a. Create an E-R diagram with surrogate primary key, ifit is necessary.
b. Produce the cardinality Min and Maxfunctions
c. Create an ERM diagram