Consider the following relational schema (the primary keys are in bold): client (taxPayerID, name, address) stock (sTick

[answerhappygod]

Consider the following relational schema (the primary keys are
in bold):
client (taxPayerID, name, address)
stock (sTicker, sName, rating, prinBus, sHigh,
sLow, sCurrent, ret1Yr, ret5Yr)
mutualFund (mTicker, mName, prinObj, mHigh,
mLow, mCurrent, yield, familyID)
fundFamily (familyID, company,
cAddress)
stockPortfolio (taxPayerID, sTicker,
sNumShares)
mutualFundPortfolio (taxPayerID, mTicker,
mNumShares)
Write the following queries in Relational Algebra and
SQL.
1. Which clients have not invested in both stocks whose
principal business is 'Healthcare' and mutual funds whose principal
objective is 'Stability'?
2. Which clients have not invested in any of the mutual funds
within the 'American fund family'?
3. Which clients have invested in both stocks and mutual
funds?
4. Which clients have invested in mutual funds whose principal
objective is 'I' (i.e., Income)?
*I will not upvote if I do not have both relational algebra and
SQL. Thank you