PART 3 (RELATIONAL SET OPERATORS)

0.0(0)
studied byStudied by 0 people
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
Card Sorting

1/7

encourage image

There's no tags or description

Looks like no tags are added yet.

Study Analytics
Name
Mastery
Learn
Test
Matching
Spaced

No study sessions yet.

8 Terms

1
New cards

Select

this commands will produced the selected values of attributes for every row that is true for a set of specified conditions

2
New cards

Project

this commands will show all values of the selected fields/attributes

3
New cards

Union

this commands will show all the union of two tables (A and B)

4
New cards

Intersect

this command will show the rows in which A and B intersect or are the same. A and B

5
New cards

Difference

this command will show the rows two tables that only appear in one table and do not appear in the other.

6
New cards

Product

produces all combinations of rows from two tables (A and B) where the first part of the row is from table A and the second part is table B

7
New cards

Join

this command combines rows from two tables that have shared values on a selected attribute.

8
New cards

Divided

this command combines rows from two tables that have shared values on a selected attribute.