(Solved) : 2 Relational Algebra Mysql Use Following Relational Database Schema Primary Keys Indicated Q26700924 . . . .

2. Relational Algebra and mySQL

You are to use the following relational database schema, primarykeys are indicated in bold face. The purpose of this database is tohelp understand how the flow of money and political alliancesaffect the“causes” championed by our legislature.

Senator Business RichPerson Cause Contribution Alliance

(SID, name, netWorth, state, party)
(BID, name, netWorth, ceo-ssn)
(SSN, name, netWorth, actualTaxRate,party) (cause-name,politicalAlignment, type) (SID, SSN, amount, cause-name)
(SID1, SID2, cause-name)

Each of the relational attributes is as follows:

Senator.SID: The unique ID of a Senator

Senator.name: The name of a Senator

Senator.netWorth: The total monetary assets of a Senator

Senator.state: The home state of a Senator

Senator.party: The party affiliation (democrat,republican,other)of a Senator

Business.BID: