Solved

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)

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q12: If you want to select records containing

Q13: The attributes of an entity become the

Q14: In relational algebra, what command is used

Q15: Discuss the difference between the major sort

Q16: When you can determine the value of

Q18: If you are sorting records by more

Q19: List five aggregate functions available in Access.

Q20: What type of functions are Count, Sum,

Q21: List six properties that define a relation,

Q22: If you use an aggregate function in