a) (10 points) Write down the relation algebra operation to create a table called "SponsorAndFunding" that contains the sponsor names and their funding amounts from the Research Account table. Show the result of this operation in a tabular format. b) (10 points) Write down the relation algebra operation to create a table called "Exxon Project" that contains all rows where sponsor name is "Exxon Group" from the Research Account table. Show the result of this operation in a tabular format. c) (10 points) Write down the relation algebra operation to create a table called ExxonAccountInfo" that contains Account Number, Account Title, and Amount of Funding of all Exxon projects from the table ExxonProject created above. Show the result of this operation in a tabular format. d) (15 points)Show the result of a product of the two tables Research Account and Research Expenditure in a tabular format. e) (15 points) Let us call the table created in part (d) as AccountCrossExpenditure. Using this as the initial source table, write down the relational algebra operations needed to create a final table called AccountCharge that contains the Account Title, Description of Charge, and Amount for all research expenditures. Show the result of this operation in a tabular format. Research Account Account Number AA-5-12345 AA-5-56789 AA-1-24680 AA-5-35791 AA-5-24795 Sponsor Name Account Title Koch Foundation Enterprise Systems Research Exxon Group Renewable Energy Programs GM Research Manufacturing Education Gates Foundation Computational Studies Exxon Group Environmental Studies Start Date 9/1/19 1/1/18 1/1/20 9/1/19 1/1/19 End Date Amount of Funding 8/31/21 $360,000 12/31/21 $150,000 5/31/21 $100,000 12/31/20 $250,000 8/31/22 $200,000 Research Expenditure Charge Number TO01 EQ001 TOO2 TOO3 EQ002 EQ003 EV001 EV002 EV003 T004 TO05 EQ004 EQ005 EV004 T006 Project Number Description of Charge Date posted AA-5-56789 Travel - Dr. George 4/30/18 AA-5-56789 Equipment - Laptop Computer 5/31/18 AA-5-35791 Travel - Dr. Grant 10/31/18 AA-5-12345 Travel - Dr. Westbrook 11/30/19 AA-5-35791 Equipment - Optimization Software 12/15/19 AA-5-12345 Equipment - Computers 12/16/19 AA-5-12345 Event - Guest Seminar 12/31/19 AA-1-24680 Event - Lean Workshop 1/31/20 AA-5-35791 Event - Modeling Synposium 1/31/20 AA-5-24795 Travel - Dr. Roberson 1/31/20 AA-1-24680 Travel - Dr. Adams 2/15/20 AA-5-24795 Equipment - Greenhouse Meter 2/15/20 AA-1-24680 Equipment - Rapid Prototyping 2/28/20 AA-5-56789 Event - Renewable Energy Workshop 3/1/20 AA-5-24795 Travel - Dr. Felton 3/3/20 Amount $1,500 $1,500 $3,500 $1,250 $1,840 $4,500 $625 $4,500 $15,000 $3,000 $1,500 $25,000 $50,000 $5,000 $2,500 a) (10 points) Write down the relation algebra operation to create a table called "SponsorAndFunding" that contains the sponsor names and their funding amounts from the Research Account table. Show the result of this operation in a tabular format. b) (10 points) Write down the relation algebra operation to create a table called "Exxon Project" that contains all rows where sponsor name is "Exxon Group" from the Research Account table. Show the result of this operation in a tabular format. c) (10 points) Write down the relation algebra operation to create a table called ExxonAccountInfo" that contains Account Number, Account Title, and Amount of Funding of all Exxon projects from the table ExxonProject created above. Show the result of this operation in a tabular format. d) (15 points)Show the result of a product of the two tables Research Account and Research Expenditure in a tabular format. e) (15 points) Let us call the table created in part (d) as AccountCrossExpenditure. Using this as the initial source table, write down the relational algebra operations needed to create a final table called AccountCharge that contains the Account Title, Description of Charge, and Amount for all research expenditures. Show the result of this operation in a tabular format. Research Account Account Number AA-5-12345 AA-5-56789 AA-1-24680 AA-5-35791 AA-5-24795 Sponsor Name Account Title Koch Foundation Enterprise Systems Research Exxon Group Renewable Energy Programs GM Research Manufacturing Education Gates Foundation Computational Studies Exxon Group Environmental Studies Start Date 9/1/19 1/1/18 1/1/20 9/1/19 1/1/19 End Date Amount of Funding 8/31/21 $360,000 12/31/21 $150,000 5/31/21 $100,000 12/31/20 $250,000 8/31/22 $200,000 Research Expenditure Charge Number TO01 EQ001 TOO2 TOO3 EQ002 EQ003 EV001 EV002 EV003 T004 TO05 EQ004 EQ005 EV004 T006 Project Number Description of Charge Date posted AA-5-56789 Travel - Dr. George 4/30/18 AA-5-56789 Equipment - Laptop Computer 5/31/18 AA-5-35791 Travel - Dr. Grant 10/31/18 AA-5-12345 Travel - Dr. Westbrook 11/30/19 AA-5-35791 Equipment - Optimization Software 12/15/19 AA-5-12345 Equipment - Computers 12/16/19 AA-5-12345 Event - Guest Seminar 12/31/19 AA-1-24680 Event - Lean Workshop 1/31/20 AA-5-35791 Event - Modeling Synposium 1/31/20 AA-5-24795 Travel - Dr. Roberson 1/31/20 AA-1-24680 Travel - Dr. Adams 2/15/20 AA-5-24795 Equipment - Greenhouse Meter 2/15/20 AA-1-24680 Equipment - Rapid Prototyping 2/28/20 AA-5-56789 Event - Renewable Energy Workshop 3/1/20 AA-5-24795 Travel - Dr. Felton 3/3/20 Amount $1,500 $1,500 $3,500 $1,250 $1,840 $4,500 $625 $4,500 $15,000 $3,000 $1,500 $25,000 $50,000 $5,000 $2,500