DB Design

CL1 (Qualified)
Relational terminology: Entities

Relational terminology: Attributes

Relational terminology: Records (Tuples)

Relationships (One-to-One, One-to-Many)

Understanding ER notation

Understanding normalization concept

Data Integrity

CL2 (Competent)
Understanding RDBMS architecture

Transactions: ACID

Transactions: Recovery

Transactions: Locking

Transactions: Isolation

Transactions: Concurrency

Optimization database (performance, volume)

Optimizing the Database Design by Denormalizing