(Solved) : Figure 2 Er Diagram Section 2 Populate Database Please Check Sections 3 Details Section 3 Q28523622 . . . .

Figure2 ER Diagram

Section2

Populate the database. Pleasecheck sections 3 for details.  

Section3

Use SQLto specify the following queries.   Whenyou populate the database, insert datasuch that at least one rowwill bedisplay as the result of runningeach query.

1)Retrieve information about theprojects (title, status and whether archived or not) that have an‘Optional’ reviewer.2)Retrieve the information aboutthe investigators (first name, last name and organization) who havedone more than one project.3)Retrieve the information ofreviewers (first name and last name), investigators (first name andlast name) for the project “Air Quality ResearchProject”.4)Get the contact information(contact number, contact person name, contact