Given the Sale and Cash Receipt relational database tables below, which of the relational algebra operators are needed to determine the unpaid balance due for each sale? Assume the only fields the user wants to appear in the query solution are SaleID and Balance Due, and also assume the user wants sales with zero balances to be included in the query solution.
A) SELECT, PROJECT, and JOIN
B) PROJECT and SELECT
C) JOIN only
D) PROJECT and JOIN
E) SELECT and JOIN

Question

Given the Sale and Cash Receipt relational database tables below, which of the relational algebra operators are needed to determine the unpaid balance due for each sale? Assume the only fields the user wants to appear in the query solution are SaleID and Balance Due, and also assume the user wants sales with zero balances to be included in the query solution. 
A) SELECT, PROJECT, and JOIN 
B) PROJECT and SELECT 
C) JOIN only 
D) PROJECT and JOIN 
E) SELECT and JOIN

Quizplus · Accepted Answer

The Answer of Given the Sale and Cash Receipt relational database tables below, which of the relational algebra operators are needed to determine the unpaid balance due for each sale? Assume the only fields the user wants to appear in the query solution are SaleID and Balance Due, and also assume the user wants sales with zero balances to be included in the query solution. 
A) SELECT, PROJECT, and JOIN 
B) PROJECT and SELECT 
C) JOIN only 
D) PROJECT and JOIN 
E) SELECT and JOIN

Given the Sale and Cash Receipt Relational Database Tables Below