Question: Using this information BRANCH ( branch _ name, City, Assets ) ACCOUNT ( account _ number, C _ SSN , branch _ name, balance, account
Using this information BRANCHbranchname, City, Assets
ACCOUNTaccountnumber, CSSN branchname, balance, accounttype, interestrate, overdraft,
BSSN
CUSTOMERCSSN firstname, lastname, address
CUSTOMERACCOUNTCSSN accountnumber, date
TRANSACTIONINSTANCEtransactioncode, transactionnumber, accountnumber, date, time,
amount TRANSACTIONtransactioncode, transactiontype, description, charge
BANKERBSSN firstname, lastname, address, startdate, phone, manager SSN
Express the following queries in Algebra.
List the accounts with no transaction since September st
List customers CSSN firstname, lastname of the Broad Street branch.
List customers CSSN firstname, lastname who have an account in Newark one or
more accounts
List customers CSSN first name, lastname who have no account in Newark.
List customers CSSN firstname, lastname who have accounts in every branch in
Newark.
List customers CSSN firstname, lastname who have more than one account at the
Broad Street branch.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
