What I do
- Apply relational algebra and set theory
- Design normalized schemas (1NF, 2NF, 3NF, BCNF)
- Write complex SQL queries and joins
- Optimize query performance
- Implement referential integrity
When to use me
When working with relational databases, designing data models, or writing complex queries.
Key Concepts
- 1NF: Atomic values, no repeating groups
- 2NF: No partial dependencies
- 3NF: No transitive dependencies
- BCNF: Boyce-Codd normal form
- Denormalization: When and how to denormalize
Query Optimization
- Index selection and composite indexes