Part I: Introduction to Databases and Database Design

1. Goals of Effective Database Design

2. Database Types

3. Relational Database Fundamentals

Part II: Database and Design Process Techniques

4. Understanding User Needs

5. Translating User Needs Into Data Models

6. Extracting Business Rules

7. Normalizing Data

8. Designing Databases to Support Software Applications

9. Common Design Patterns

10. Common Design Pitfalls

Part III: A Detailed Case Study

11. User Needs and Requirements

12. Building a Data Model

13. Building a Relational Model

14. Extracting Business Rules

15. Normalization and Refinement

16. Microsoft Access

17. MySQL

Part IV: Advanced Topics

18. Introduction to SQL

19. Building Databases with SQL Scripts

20. Database Elements

21. Database Security

Appendixes

Appendix A. Exercise Solutions

Appendix B. Sample Database Designs

Appendix C. Glossary

Index