Industry Database is the database of an industrial organization producing at project level. Some requirements for this database are listed below.

#Each project is done in a section. More than one project can be done in a department. Every project has a manager. A person who works in the department of the project manager, where the project is done it is not mandatory.

#Each staff works in a department. Each department has a manager. The department manager does not have to be a person working in that department.

#A staff member can be the manager of more than one department or project.

The materials used in the institution are the materials that constitute the inputs of the projects and are consumed in the projects. Each of these materials can be produced in-house, ready-made from companies. It can be purchased, or some of it is produced in the institution and some of it is purchased.

#Many materials can be consumed in a project. A material can also be consumed in more than one project.

# More than one material can be produced in a section. A material can also be produced in zero, one or many sections.

#A material can be purchased from more than one company. It is also possible to purchase many materials from one company.

The QUANTITY attributes in the #PRODUCTION, CONSUMPTION and PURCHASE asset clusters show the total production, consumption and purchase amounts during the year, respectively.

Answer the following questions.

(1) Give Entity-Relational Chart (ER Diagram) and Relational Schema.

(2) [Relational algebra] "Find the registration number and name of persons who are directors of a department other than the department in which they work".

(3) [SQL] "Find the numbers and names of the projects whose materials are all produced in the department where they are made (does not consume any materials that are not produced in the department where they are made)"

(4) [Multiple Relationship Analysis (TRC)] . "Find the registration number and name of the personnel who are paid higher than the manager of the department they work"

(5) [Relational algebra] "Find the numbers and names of the projects that consume all the materials consumed in project 6 (among the materials consumed include all the materials consumed in project 6)"