Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
390 views
in Database Management System by (30.3k points)
closed by

Consider the instance of the BORROWER and DE- POSlTOR relations shown in following figure which stores the details of customers in a Bank. Answer the following queries in relational algebra.

(a) Display the details of the customers who are either a depositor or a borrower.

Borrower Depositor
Acc_No Name Amount Acc_No Name Amount
AC123 juwee 50000 AC123 juwee 500
AC103 Rasheeda 25000. AC105 Shabana 25000
AC106 Vishnu 25000 AC116 Vishnu 125000
AC108 Aiswarya 30000 AC108 Aiswarya 3000

(b) Display the name of customers who are both a depositor and a borrower. 

(c) Display the details of the customers who are d positors but not borrowers. 

(d) Display the name and’amount of customer who is a borrower but not depositor.

1 Answer

+1 vote
by (29.3k points)
selected by
 
Best answer

(a)

   Acc_No          Name
AC 123 Albin
AC 105 Shabana
AC116 Vishnu
AC108 Aiswarya
AC103 Rasheeda
AC 106 Vishnu

(b)

       Acc_No            Name
AC123 Albin
AC108 Aiswarya

(c)

    Acc_No        Name
AC105 Shabana
AC116 Vishnu

(d)

    Name           Amount
Rasheeda 25000
Vishnu 25000

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

...