Terps Enterprise, Inc., is a consultant firm with approximately $300$ employees. A database is required to keep track of all employees, their dependents, projects worked on$,$ and departments assigned to$.$ Every employee has a unique Social Security Number $($SSN$)$ and is required to store the full name $($in three fields $-$ first name, middle name initial, and last name$),$ date of birth $($DOB$),$ gender, address $($in four fields $-$ street, city, state, and zip code$),$ salary, supervisor's SSN if any, department assigned to$,$ and total number of hours that she or he worked on $($during the most recent week$).$ There are three departments $($Headquarters$,$ Administration, and Research$),$ each with a unique identifier, name, manager $($who is an employee$),$ the manager's starting date, and location$($s$).$ Each department, except the Headquarter $($at single location$),$ may have up to three locations. Many employees can work on a project, and an employee can work on many projects $($e$.$g$.,$ Capital Refinery, Metro Transportation, and so on$).$ Number of hours that an employee works on a project should be recorded weekly. A project is organized by a department and is distinguished by a unique project identifier. We must store the project name and location. An employee may carry dependents, whose names, DOB, genders, and relationships to the corresponding employee should be recorded.