We have only one question to be solved, which is about Database concepts. I do not think there is a reference for this question and if there is just include it please. Question 4. Research question...

We have only one question to be solved, which is about Database concepts. I do not think there is a reference for this question and if there is just include it please. Question 4. Research question (10 marks). Excellence in Research for Australia http://www.arc.gov.au/excellence-research-australia is a comprehensive quality evaluation framework of research produced in Australian universities. Assume that the research paper index (RPI) for each department is defined as the total number of papers by academics in the department, normalised by the total number of academics in the department. In calculating the RPI for academic departments, each paper carries one point and is divided to departments according to the number of contributing authors. For example, consider a paper by three authors where two authors are from Department A and one author from Department B, the paper contributes 2/3 point to the RPI of department A and 1/3 point to that of department B. As another example, a paper by two authors from department A contributes one point to the RPI of Department A. Based on the Academics database, write SQL queries to output deptnum and RPI for each academic department, ranked in decreasing order of RPIs. You can write several queries and define views to keep intermediate query results. Explain in English what each query or view is doing. You are expected to run and test your queries in SQL Developer. The Academic database is attached.