Database Systems: A Practical Approach to Design, Implementation, and Management

1. Introduction to Databases
2. Database Environment
3. Database Architectures and Cloud Computing
4. The Relational Model
5. Relational Algebra and Relational Calculus
6. SQL: Data Manipulation
7. SQL: Data Definition
8. Advanced SQL
9. Database System Development Lifecycle
10. Database Analysis and the DreamHome Case Study
11. Entity–Relationship Modeling
12. Enhanced Entity–Relationship Modeling
13. Normalization
14. Advanced Normalization
15. Methodology—Conceptual Database Design
16. Methodology—Logical Database Design for the Relational Model
17. Methodology—Physical Database Design for Relational Databases
18. Methodology—Monitoring and Tuning the Operational System
19. Security and Administration
20. Professional, Legal, and Ethical Issues in Data Management
21. Transaction Management
22. Query Processing
23. Distributed DBMSs—Concepts and Design
24. Distributed DBMSs—Advanced Concepts
25. Replication and Mobile DBMSs
26. The Web, Cloud, and Microservices
27. Modern Frameworks in Database-Driven Development
28. Object-Relational DBMSs
29. Object-Oriented DBMSs
30. NoSQL, Multimodel, and NewSQL DBMSs
31. Data Warehousing Concepts
32. Data Warehousing Design
33. OLAP
34. Data Mining

APPENDICES

• A. Users’ Requirements Specification for DreamHome Case Study
• B. Other Case Studies
• C. Alternative ER Modeling Notations
• D. Summary of the Database Design Methodology for Relational Databases
• E. File Organizations and Indexes
• F. When Is a DBMS Relational? (Online)
• G. Estimating Disk Space Requirements (Online)
• H. Introduction to Object-Oriented Concepts (Online)