CIS 761: Database Management Systems

Prerequisites

• some familiarity with databases, in particular basic SQL.
• a bit of mathematical background, in particular familiarity with reasoning about sets.

Knowledge and skills that should be acquired in this course

Mastery

1. the relational model.
2. query languages: relational algebra; SQL.
3. design issues: decomposition, normalization.

Familiarity

1. another data model: the Entity-Relationship (ER) model.
2. other query languages for the relational model:
   Datalog; tuple relational calculus.
3. implementation issues: indexing and hashing,
   query processing and query optimization.
4. transaction management: serializability, concurrency control &
   protocols, recovery system.
5. data mining; data warehousing.