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:

Straight-Line Depreciation

A depreciation method where an asset's cost is evenly distributed over its expected lifespan.

Net Present Value

A financial metric used to evaluate the profitability of an investment, calculated by subtracting the present value of cash outflows from the present value of cash inflows over a period.

Capital Budgeting

The process of making long-term planning decisions for investment projects, evaluating their potential profitability and financial impact.

Straight-Line Depreciation

A method of calculating depreciation by evenly spreading the cost of an asset over its useful life.