Page 34 - Discrete Structure II
P. 34
Exercise 1
Consider the following table
ID Number First Name Last Name GPA
326895 Mercedes Suarez 3.4
225867 Paul Gunter 2.98
125369 Paul Doe 2.98
896731 Kathy Henry 2.75
What projection operator will produce the table below.
First Name GPA
Mercedes 3.4
Paul 2.98
Paul 2.98
Kathy 2.75
Answer: P2, 4
Condition Operator
The Condition Operator Sc lists the records that satisfy the condition specified by C.
Example: Consider the table above, what is the output when Sc is applied when C=”GPA > 3”?
Sc (table):
ID Number First Name Last Name GPA
326895 Mercedes Suarez 3.4
