The National Science Foundation (NSF) is a significant funder of academic research in the United States. Researchers submit proposals to various programs (for example, the “INFO INTEGRATION & INFORMATICS” (III) program in the the “Computer Science Engineering” (CSE) directorate is primarily responsible for funding research on database systems.) Panels of peer reviewers (other academics in related fields) decide which proposals will be funded, and there are some managers in NSF that are managing the funds. Once the grants are awarded, the university (Organization) administers them on behalf of the researchers. These grants typically range from $50,000 to millions of dollars, and they are used by researchers to pay graduate students, postdocs, and staff, acquire equipment and supplies, and cover expenses like travel. It is important that each grant have a PI that known as the owner of the grant and he/she is a researcher in that organization. Given the vast number of grants awarded over the years, spanning from the early to mid-1990s, researchers want to access information on all recent grants awarded to prestigious institutions such as MIT, Harvard, Carnegie Mellon, Stanford, UC Berkeley, and the University of Louisville. It is important to note that these grants cover various fields, not just computer science. Please answer the following questions (All the queries need to be written in Relational Algebra): a. Write a query to find the title and amount of the grants for which Professor Stonebraker is the principal investigator (PI). b. Write a query that finds the number of times an MIT researcher has received (not necessarily a PI) a grantover$1 million since 1/1/2008. Retrieve the name of the researcher and the number of such grants awarded. c. Write a query that finds all the grants related to the field 'Computer Science', and retrieve the title of the grant and the name of the principal investigator.
The National Science Foundation (NSF) is a significant funder of academic research in the United States. Researchers submit proposals to various programs (for example, the “INFO INTEGRATION & INFORMATICS” (III) program in the the “Computer Science Engineering” (CSE) directorate is primarily responsible for funding research on
Please answer the following questions (All the queries need to be written in Relational Algebra): a. Write a query to find the title and amount of the grants for which Professor Stonebraker is the principal investigator (PI). b. Write a query that finds the number of times an MIT researcher has received (not necessarily a PI) a grantover$1 million since 1/1/2008. Retrieve the name of the researcher and the number of such grants awarded. c. Write a query that finds all the grants related to the field 'Computer Science', and retrieve the title of the grant and the name of the principal investigator.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
