Question: ( 3 5 points ) A project management database contains information about projects ( identified by project - id , and they have title, description,

(35 points) A project management database contains information about projects (identified by
project-id, 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).
 (35 points) A project management database contains information about projects (identified

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!