Draw an ER diagram for the exercise and specify the primary key for each entity and the cardinality on both sides of the relationships.

EMPLOYEE is-assigned-to PROJECT

Each PROJECT has at least one EMPLOYEE assigned to it

Each EMPLOYEE may or may not be assigned to any existing PROJECT or may be assigned to one or more PROJECTS