Question: ( 3 5 points ) A project management database contains information about projects ( identified by project - id , and they have title, description,
points A project management database contains information about projects identified by
projectid and they have title, description, start date, end date, and budget and employees identified
by SSN each employee has name, surname, specialty, and phone number A project has any number
of project packets but each packet identified by packet id title, duration must belong to an exactly
one project. Project packets are assigned to employees. For each packet, at least one employee is
assigned to and employee can be assigned to any number of packets for a particular duration. Some
of the employees are managers and they supervise employees who are assigned to project packets.
For each assignment of employee to any project packet, exactly one manager must supervise.
However, a manager can supervise any number of assignments. Draw an ER diagram that describes
the given information assuming no further constraints hold
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
