Please enable JavaScript.
Coggle requires JavaScript to display documents.
Ch. 9 and Appendix F: Boolean Expressions (Boolean Expressions (A=B…
Ch. 9 and Appendix F: Boolean Expressions
Data Integration
Join
combines two datasets with a shared identity value
Subtypes
Inner join
each row in right table is combined horizontally with any row in the right table that has the same identity value
most commonly used
Outer join
Left outer join
Right outer join
Full outer join
inner join + a left outer join + a right outer join
Based on relational algebra
Union
lines up each column containing similar information on top of another
Boolean Expressions
A=B
Expression A equals expression B
A != B
A does not equal B
A>B
A is greater than B
A>=B
A is greater than or equal to B
A<B
A is less than B
A<=B
A is less than or equal to B
A
A is True
NOT A
A is False
A IN B
A is in the set of B things
A NOT IN B
A is not in the set of B things
A OR B
Expression A is True or expression B is True or both expressions are True
A AND B
Expression A is True and expression B is True
A OR (B AND C)
Expression A is True or expression B and Expression C are both true or expression A and expression B and C are true
A AND (B OR C)
Expression A is true and expression B, expression C, or expressions B and C are True