First page Back Continue Last page Graphics
Preparation for colstruction 2
The preparation is for colstruction 2 instead of labsession 2 because of a holiday.
Study chapter 3 of the database book, up to and including all of section 3.2.
- In 3.2.3 additional operators are introduced that make the expression of some queries easier.
- Note that we are not going to study sections 3.3, 3.4 and 3.5.
Notes:
We study the remainder of section 3.2 by the next colstruction. We do it by the colstruction because there is no labsession the week before easter.
In section 3.2.3 some additional operators are introduced. Let us briefly mention two of them:
The Join operator is very useful because it lets us use the connection between two tables through a common attribute. We have noticed today that we often need to combine a cartesian product with a selection on the common attribute. The join operator provides us with a more compact way to do this.
The Division operator is a very special one that lets us perform a selection based on sets. Exercise 3.5h can be expressed quite easily using the Division operator.