EXAMRADAR

Question: If we want to include attributes from two different relations, which of the following operations is needed?

Answer:

Consider a Query to find the names of all bank customers who have either an account or a loan or both. Note that the customer relation does not contain the information, since a customer does not need to have either an account or a loan at bank. To answer this query we the information in the depositor relation and in the borrower relation.

 

So the expression needed is

 

Π customer-name (borrower) U Π customer-name (depositor)

MCQ: If we want to include attributes from two different relations, which of the following operations is needed?

Correct Answer: A. Set difference

Explanation:

Consider a Query to find the names of all bank customers who have either an account or a loan or both. Note that the customer relation does not contain the information, since a customer does not need to have either an account or a loan at bank. To answer this query we the information in the depositor relation and in the borrower relation.

 

So the expression needed is

 

Π customer-name (borrower) U Π customer-name (depositor)

Discuss a Question

Related Questions

You may be interested in:

Advanced Database Management System MCQs

Recently Added Articles

5 Best Amazon Advertising Agencies for Growing Brands

Last updated on: November 6, 2026Posted by: ExamRadar

Best Free AI Humanizers for Academic Writing

Last updated on: October 30, 2026Posted by: ExamRadar

How Image to Text Conversion Make Printed Study Materials Easier to Use?

Last updated on: October 23, 2026Posted by: ExamRadar

7 Best Online Exam Makers for Teachers, Schools, and Businesses

Last updated on: October 21, 2026Posted by: ExamRadar

How to pick a Bintan resort when you’ve only got 48 hours

Last updated on: September 23, 2026Posted by: ExamRadar

Features to Look for While Choosing the Best Automation Tool

Last updated on: July 15, 2026Posted by: ExamRadar

AI vs Machine Learning: Key Differences Every Professional Should Know

Last updated on: February 13, 2026Posted by: ExamRadar