RDBMS Fundamentals

Yes, there are rules for database design. Just like there are design patterns for application development and software engineering, there are design patterns for database design. These database patterns encourage table independence, scalability, and help databases be less fragile for future changes.

  1. Keys
  2. First Normal Form
  3. Second Normal Form
  4. Third Normal Form