Cs6400 exam 3 - Study guides, Class notes & Summaries

CS6400 - Exam 3 UPDATED Questions and CORRECT Answers logical (or conceptual) level - CORRECT ANSWER- how users interpret the relation schemas and the meaning of their attributes implementation (or physical storage) level - CORRECT ANSWER- how the tuples in a base relation are stored and updated

CS6400 - Exam 3 UPDATED ACTUAL Questions and CORRECT Answers Natural Join - CORRECT ANSWER- The result of this is the set of all combinations of tuples in R and S that are equal on their common attribute names. A special case of an equijoin. Left Outer Join - CORRECT ANSWER- A construct operator which results in the set of all combinations of tuples in R and S that are equal on their common attribute names, in addition (loosely speaking) to tuples in R that have no matching tuples in...