Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
8 Cards in this Set
- Front
- Back
SELECT OPERATOR Define: Select Operator what is the format? |
Selects row that satisfies the condition Format: σ condition (relation) |
|
SELECT OPERATOR Write the select operator for: From person, select row where hobby is hockey. |
σ hobby = 'hockey' (Person) |
|
SELECT OPERATOR Are these correct uses of selection conditions? σ id > 1000 OR hobby = 'hockey' (Person) σ id > 3000 AND id < 3500 (Person) σ NOT(hobby = 'hockey') (Person) |
Yes Yes Yes |
|
PROJECT OPERATOR Define: Project operator |
This specifies what information is projected to the output. Format: π attribute list (relation) |
|
PROJECT OPERATOR Project the name and hobby from Person |
π name, hobby (Person) |
|
EXPRESSION EXAMPLE What would be the output? |
|
|
When are two relations compatible for union |
1. Both have same number of columns 2. Name of attributes are the same |
|
Remember this |
lol |