Based on the following table, which relational algebra command creates a new table named CustState containing the fields CustomerNum and State? Customer (CustomerNum, CustomerName, Street, City, State, PostalCode)
A)JOIN Customer WITH (CustomerNum, State) GIVING CustState
B)PROJECT Customer OVER (CustomerNum, State) GIVING CustState
C)SELECT Customer OVER (CustomerNum, State) GIVING CustState
D)MAKE-TABLE CustState FROM Customer WITH (CustomerNum, State)

Question

Quizplus · Accepted Answer

The correct command to create a new table containing only specific fields from an existing table is the PROJECT command. In relational algebra, PROJECT is used to select certain columns from a table, which matches the requirement to create CustState with only CustomerNum and State fields from the Customer table.

Based on the Following Table, Which Relational Algebra Command Creates