Question: Using this information BRANCH ( branch _ name, City, Assets ) ACCOUNT ( account _ number, C _ SSN , branch _ name, balance, account

Using this information BRANCH(branch_name, City, Assets)
ACCOUNT(account_number, C_SSN, branch_name, balance, account_type, interest_rate, overdraft,
B_SSN)
CUSTOMER(C_SSN, first_name, last_name, address)
CUSTOMER_ACCOUNT(C_SSN, account_number, date)
TRANSACTION_INSTANCE(transaction_code, transaction_number, account_number, date, time,
amount) TRANSACTION(transaction_code, transaction_type, description, charge)
BANKER(B_SSN, first_name, last_name, address, start_date, phone, manager SSN)
Express the following queries in Algebra.
List the accounts with no transaction since September 1st 2024.
2. List customers (C_SSN, first_name, last_name) of the Broad Street branch.
3. List customers (C_SSN, first_name, last_name) who have an account in Newark (one or
more accounts).
4. List customers (C_SSN, first name, last_name) who have no account in Newark.
5. List customers (C_SSN, first_name, last_name) who have accounts in every branch in
Newark.
6. List customers (C_SSN, first_name, last_name) 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!