Contents

• Relational Databases
  • Introduction
  • Relational Model
  • Relational Operators
  • SQL Select
  • Query-By-Example (QBE)
  • Example Queries: Part A
  • Example Queries: Part B
  • Example Queries: Part C
  • Data Dictionary
  • SQL Features
  
  
• Relational Calculus
  • Tuple Relational Calculus
  • Domain Relational Calculus
  • Tableau
  
  
• Design
  • Normal Forms
  • Functional Dependencies
  • Covers
  • Algorithm to Decompose R into 3NF
  • Functional Dependency Preservation
  • Algorithm to Decompose R into BCNF
  
  
• Index Mechanisms
• Optimization
• Database Concurrency
• Appendix: Advanced Queries
• About this document ...