Basically,
Chapters 3, 5 & 6
from the textbook.
We have covered the second part of the course,
II. Queries.
While we talked about
some relational-calculus and Datalog examples,
these are not covered by the test.
Only topics covered both in the reading and in class are fair game.
Test #2 is not cumulative, so it does not test the topics
covered by Test #1.
That said,
to understand the topics here,
you have to have understood what came before.
(For instance,
you have to know the normal forms to do loseeless-join
decomposition.)
- Normalization: Schema Refinement
[Ch 3: §4&5]
- lossless join decomposition
- dependency preservation
- synthesis
- Relational Algebra
[Ch 5]
- relational algebra operators
- queries
- SQL (Ch.5)
[Ch 6: §1–5]
- syntax & conceptual model
- aggregate operators
- NULL values
- queries, queries, queries!
|