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$).$ EXPLAIN THE PROBLEM GIVEN ABOVE AND SOLVE IT ACCORDING TO THE RULES.

PLEASE DO NOT ANSWER USING CHATGPT.