A relational database is to be designed for a medium$-$sized company named Global Support Solutions $($GSS$),$which deals with industrial applications of computers. The company delivers various products to its customers,ranging from a single application program to the complete installation of hardware with customized software.The company employs various experts, consultants, and supporting staff. All personnel are employed on a long$-$term basis, i$.$e$.,$ there are no short$-$term or temporary staff.Although the company is structured for administrative purposes $($i$.$e$.,$ it is divided into departments headed bydepartment managers$),$ all projects are carried out in an interdisciplinary way. For each project, a project teamis selected, grouping employees from different departments, and a Project Manager $($also an employee of thecompany$)$ is appointed. The Project Manager is entirely and exclusively responsible for the control of theproject, quite independently of the company's hierarchy. Each employee works in some departments. Every manager is an employee. A department may participate in none$/$one$/$many projects. At least one department participates in a project. An employee may be engaged in none$/$one$/$many projects. Project teams consist of at least one member. Each project has specific title, deadline, and project$\_$value Each project can have any of the following statuses: Ongoing, Terminated, Completed, And Closed.