Question: Write a database relational algebra expressions for below : Consider the following relations that store data about card account system in a commerical bank. The
Write a database relational algebra expressions for below :
Consider the following relations that store data about card account system in a commerical bank. The organization offers two type of cards : Debit and Credit (card type)
Customer (CustID, CustName, TelNo, HouseNo, Area); CardAccount(CardNo, CustID, Expiry, Date, CardType) Merchant(MerchantID, Name, Location) Transaction(CardNo, MerchantID, Date, Ammount)
Now Write relational algebra expressions for the following queries :
1. Display the card number and card type of all customers. 2. Display the name and telephone no. of all customers residing in the area of ABC. 3. Display the ID of customers who have both debit cars and credit cards. 4. To view the customer Name, Telephone Number, and Expity Date of cards customers. 5. Display the Name, House no. and Area of all customers having debit card. 6. Display the Customers id, Card Number, Date and Amount for each transcation of a customer. The query should also display CustID for card accounts who have not made any transcatio. 7. To show all Card Numbers for which transcations have been occurred from all merchants at XYZ road. 8. Display the ID of all customers residing in 'CEF' who have credit card but not debit card. 9. To show the maximum and minumum ammount of transcation. 10. Dipsplay the count of all customers living in 'Berlin'
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
