Explain the basic results that come from the restrict, project, and join functions
A restrict extracts selected rows from a table–records that satisfy prescribed conditions–to create a new table.
A project extracts selected attributes (columns) from a table to create a new table.
A join builds a new table, from two existing tables, by matching rows on a value of a common attribute.
You might also like to view...
Which of the following types of interviews is most likely to involve several people, such as a search committee, who gather in a conference or seminar room with a job applicant to discuss the position?
A) Group interview B) Telephone interview C) Panel interview D) One-on-one interview E) Action interview
Which two currencies account for more than half of all the trading volume in the foreign exchange market?
A) Euro and Chinese yuan B) U.S. dollar and the British pound C) Euro and the British pound D) U.S. dollar and the euro
Which of the following strategies is also called a minimax regret strategy?
A) conservative strategy B) opportunity loss strategy C) average payoff strategy D) aggressive strategy
The outstanding bonds of International Plastics mature in 6 years and pay semiannual interest payments of $33.50 on a $1,000 face value bond. The bonds are currently selling for $1,008.64. The coupon rate is ________ percent, the current yield is ________ percent, and the yield to maturity is ________ percent.
A. 6.70; 6.78; 6.57 B. 6.70; 6.64; 6.52 C. 6.64; 6.83; 6.57 D. 6.55; 6.91; 6.75 E. 6.55; 6.86; 6.60