Based on the Following Table, Which Relational Algebra Command Creates

question 17

Multiple Choice

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)

---

Definitions:

Total Revenues

The overall sum of money earned by a business from its sales of goods or services, calculated without deducting any expenses.

Marginal Product

The incremental increase in output resulting from the use of one additional unit of a resource, while keeping other resources constant.

Variable Resource

A factor of production whose quantity can easily be changed in the short term to increase or decrease production levels.

Fixed Resource

An asset or resource in production that cannot be easily increased or decreased in the short term, such as land or machinery.