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:

Quantity Supplied

The complete measure of a good or service that suppliers are willing and capable of selling at an identified price throughout a specified duration.

Supply Curve

A graph that represents the relationship between the price of a good or service and the quantity of it that suppliers are willing to produce at various prices.

Personal Computers

Electronic devices designed for individual use, capable of executing a set of instructions and processing data.

Fabric

A material made from fibers, threads, or yarns, used for producing clothing, household items, and other textiles.