Inspection |
RegNo |
DateInspected |
Period |
Evaluation |
|
ABC123 |
2000-01-03 |
2000 |
OK |
ABC123 |
1999-01-15 |
1999 |
OK |
DFG456 |
2000-12-04 |
2000 |
FAIL |
HIK123 |
2000-10-20 |
2000 |
OK |
TOP111 |
2000-05-11 |
2000 |
OK |
|
In the second tuple of Inspection the value of attribute
Period is not equal to 2000. Thus the selection condition is false
and the tuple will not be included in the result. |
Inspection |
RegNo |
DateInspected |
Period |
Evaluation |
|
ABC123 |
2000-01-03 |
2000 |
OK |
|
|