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
PayPal Gateway not configured
PayPal Gateway not configured