Database

Table

Datatypes

Entities and Relationships

Index

Key

Candidate key

Primary key

Foreign Key

Referential Integrity

Equijoins and Outer Joins

Artificial Primary Keys (Surrogate Keys)

Drawbacks of Surrogate Keys

Constraints