Notes / Section 9

Databases

ER model

ER-model.

Relational algebra and tuple calculus

Relational model: relational algebra, tuple calculus.

SQL

SQL.

Integrity constraints and normal forms

Integrity constraints, normal forms.

File organization and indexing

File organization, indexing (B and B+ trees).

Transactions and concurrency control

Transactions and concurrency control.