Based on the following notation, which relational algebra command would list all information from the table concerning the customer with numeric CustomerNum 260? Customer (CustomerNum, CustomerName, Street, City, State, PostalCode)
A)SELECT Customer 260 RESULTS Answer
B)SELECT Customer WHERE CustomerNum=260 GIVING Answer
C)SELECT Customer GIVING Answer WHERE CustomerNum='260'
D)SELECT Customer WHERE CustomerNum='260' RESULTS Answer

Question

Quizplus · Accepted Answer

The correct command in relational algebra to list all information for a customer with a specific numeric identifier (in this case, CustomerNum 260) follows the syntax: SELECT WHERE GIVING . Therefore, option B correctly specifies the operation to select all records from the "Customer" table where the "CustomerNum" is 260.

Based on the Following Notation, Which Relational Algebra Command Would