Question A. (50 marks) A simplified database is being constructed to keep track of a company's departments, staffs, offices, and projects. The company has a unique company id, a name, and an address. The company owns many departments, each has a unique dept name. A department hires many staffs, a staff belongs to one department only. A staff has a unique staff_id, a name, an email, and a position. A department owns many offices, an office belongs to one department only. An office has a unique office_id. Each staff works in one office only. One or more departments can cooperate to conduct a project. A project has a unique project id, a name, and a date. A staff participates in at least one or multiple projects. 1) Design an ER diagram for this application, stating any assumptions you make (e.g., a department can conduct multiple projects). [20 marks] 2) For your ER diagram given above, convert it into relational schema using the mapping guidelines discussed in the lecture. For each relation (table) obtained, specify the name and its attribute, as well as primary key. [20 marks]