Projects Inc. is an engineering firm. A database is required to keep track of all employees, their projects assigned, and departments worked in$.$

Every employee has a unique number$($EmpID$)$ assigned by the firm, also required to store his or her name and date of birth. If an employee is currently married to another employee in the organization, the date of marriage must be stored

However, no record of marriage is required if an employee$$s spouse is not also an employee. Each employee is given a job title $($for example, engineer, secretary$,$ and so on$).$

There are eleven departments, each with a unique name. An employee can report to only one department. Each department has a phone number.

To procure various kinds of equipment, each department deals with many vendors. A vendor typically supplies equipment to many departments. We are required to store the name and address of each vendor and the date of the last meeting between a department and a vendor.

Many employees can work on a project. An employee can also work on many projects. The company keeps track of the starting date and ending date for every employee participating in a project.

Projects are exclusively categorized into internal projects and outside projects. Each project has a project$\_$ID$,$ description and the due date of the project. For an outside project, an hourly rate and location also needs to be recorded. For internal ones, the number of participants and the project manager $($by the EmpNo$)$ will be recorded.