a) A company has a number of employees. Each employee may be assigned to one or more projects. A project must have at least one employee assigned and may have several employees assigned.
i) Draw an ER Diagram
ii) Identify cardinalities
iii) Identify modalities
b) Elaborate primary and alternate key with the help of a pictorial example.