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

Table of Contents

I. BACKGROUND.

1. Introduction to Databases.
2. Database Environment.

II. THE RELATIONAL MODEL AND LANGUAGES.

3. The Relational Model.
4. Relational Algebra and Relational Calculus.
5. SQL: Data Manipulation.
6. SQL: Data Definition.
7. Query-By-Example.
8. Commercial RDBMSs: Access and Oracle.

III. DATABASE ANALYSIS AND DESIGN TECHNIQUES.

9. Database Planning, Design, and Administration.
10. Fact-Finding Techniques.
11. Entity-Relationship Modeling.
12. Enhanced Entity-Relationship Modeling.
13. Normalization.

IV. METHODOLOGY.

14. Methodology - Conceptual Database Design.
15. Methodology - Logical Database Design for the Relational Model.
16. Methodology - Physical Database Design for Relational Databases.
17. Methodology - Monitoring and Tuning the Operational System.

V. SELECTED DATABASE ISSUES.

18. Security.
19. Transaction Management.
20. Query Processing.
21. Programmatic SQL.

VI. CURRENT TRENDS.

22. Distributed DBMSs - Concepts and Design.
23. Distributed DBMSs - Advanced Concepts.
24. Introduction to Object DBMSs.
25. Object-Oriented DBMSs - Concepts and Design.
26. Object-Oriented DBMSs - Standards and Systems.
27. Object-Relational DBMSs.

VII. EMERGING TRENDS.

28. Web Technology and DBMSs.
29. Semistructured Data and XML.
30. Data Warehousing Concepts.
31. Data Warehousing Design.
32. OLAP and Data Mining.

APPENDICES.

A. Users' Requirements Specification for DreamHome Case Study.
B. Other Case Studies.
C. File Organization and Storage Structures.
D. When is DBMS Relational?
E. Alternative ER Modeling Notations.
F. Summaryof the Database Design Methodology for Relational Databases.
G. Estimating Disk Space Requirements.
H. Example Web Scripts.
References.
Further Reading.
Index.

Read More