You are previewing Fundamentals of Database Management Systems, Second Edition.
O'Reilly logo
Fundamentals of Database Management Systems, Second Edition

Book Description

Gillenson's new edition of Fundamentals of Database Management Systems provides concise coverage of the fundamental topics necessary for a deep understanding of the basics. In this issue, there is more emphasis on a practical approach, with new "your turn" boxes and much more coverage in a separate supplement on how to implement databases with Access.

In every chapter, the author covers concepts first, then show how they're implemented in continuing case(s.) "Your Turn" boxes appear several times throughout the chapter to apply concepts to projects. And "Concepts in Action" boxes contain examples of concepts used in practice. This pedagogy is easily demonstrable and the text also includes more hands-on exercises and projects and a standard diagramming style for the data modeling diagrams. Furthermore, revised and updated content and organization includes more coverage on database control issues, earlier coverage of SQL, and new coverage on data quality issues.

Table of Contents

  1. Cover Page
  2. Title Page
  3. Copyright
  4. OTHER JOHN WILEY & SONS, INC. DATABASE BOOKS
  5. Dedication
  6. Brief Contents
  7. Contents
  8. PREFACE
    1. PURPOSE OF THIS BOOK
    2. NEW IN THE SECOND EDITION
    3. ORGANIZATION OF THIS BOOK
    4. SUPPLEMENTS
    5. ACKNOWLEDGMENTS
  9. ABOUT THE AUTHOR
  10. CHAPTER 1: DATA: THE NEW CORPORATE RESOURCE
    1. OBJECTIVES
    2. CHAPTER OUTLINE
    3. INTRODUCTION
    4. THE HISTORY OF DATA
    5. DATA IN TODAY'S INFORMATION SYSTEMS ENVIRONMENT
    6. SUMMARY
    7. KEY TERMS
    8. QUESTIONS
    9. EXERCISES
    10. MINICASES
  11. CHAPTER 2: DATA MODELING
    1. OBJECTIVES
    2. CHAPTER OUTLINE
    3. INTRODUCTION
    4. BINARY RELATIONSHIPS
    5. UNARY RELATIONSHIPS
    6. TERNARY RELATIONSHIPS
    7. EXAMPLE: THE GENERAL HARDWARE COMPANY
    8. EXAMPLE: GOOD READING BOOK STORES
    9. EXAMPLE: WORLD MUSIC ASSOCIATION
    10. EXAMPLE: LUCKY RENT-A-CAR
    11. SUMMARY
    12. KEY TERMS
    13. QUESTIONS
    14. EXERCISES
    15. MINICASES
  12. CHAPTER 3: THE DATABASE MANAGEMENT SYSTEM CONCEPT
    1. OBJECTIVES
    2. CHAPTER OUTLINE
    3. INTRODUCTION
    4. DATA BEFORE DATABASE MANAGEMENT
    5. THE DATABASE CONCEPT
    6. DBMS APPROACHES
    7. SUMMARY
    8. KEY TERMS
    9. QUESTIONS
    10. EXERCISES
    11. MINICASES
  13. CHAPTER 4: RELATIONAL DATA RETRIEVAL: SQL
    1. OBJECTIVES
    2. CHAPTER OUTLINE
    3. INTRODUCTION
    4. DATA RETRIEVAL WITH THE SQL SELECT COMMAND
    5. EXAMPLE: GOOD READING BOOK STORES
    6. EXAMPLE: WORLD MUSIC ASSOCIATION
    7. EXAMPLE: LUCKY RENT-A-CAR
    8. RELATIONAL QUERY OPTIMIZER
    9. SUMMARY
    10. KEY TERMS
    11. QUESTIONS
    12. EXERCISES
    13. MINICASES
  14. CHAPTER 5: THE RELATIONAL DATABASE MODEL: INTRODUCTION
    1. OBJECTIVES
    2. CHAPTER OUTLINE
    3. INTRODUCTION
    4. THE RELATIONAL DATABASE CONCEPT
    5. DATA RETRIEVAL FROM A RELATIONAL DATABASE
    6. EXAMPLE: GOOD READING BOOK STORES
    7. EXAMPLE: WORLD MUSIC ASSOCIATION
    8. EXAMPLE: LUCKY RENT-A-CAR
    9. SUMMARY
    10. KEY TERMS
    11. QUESTIONS
    12. EXERCISES
    13. MINICASES
  15. CHAPTER 6: THE RELATIONAL DATABASE MODEL: ADDITIONAL CONCEPTS
    1. OBJECTIVES
    2. CHAPTER OUTLINE
    3. INTRODUCTION
    4. RELATIONAL STRUCTURES FOR UNARY AND TERNARY RELATIONSHIPS
    5. REFERENTIAL INTEGRITY
    6. SUMMARY
    7. KEY TERMS
    8. QUESTIONS
    9. EXERCISES
    10. MINICASES
  16. CHAPTER 7: LOGICAL DATABASE DESIGN
    1. OBJECTIVES
    2. CHAPTER OUTLINE
    3. INTRODUCTION
    4. CONVERTING E-R DIAGRAMS INTO RELATIONAL TABLES
    5. THE DATA NORMALIZATION PROCESS
    6. TESTING TABLES CONVERTED FROM E-R DIAGRAMS WITH DATA NORMALIZATION
    7. BUILDING THE DATA STRUCTURE WITH SQL
    8. MANIPULATING THE DATA WITH SQL
    9. SUMMARY
    10. KEY TERMS
    11. QUESTIONS
    12. EXERCISES
    13. MINICASES
  17. CHAPTER 8: PHYSICAL DATABASE DESIGN
    1. OBJECTIVES
    2. CHAPTER OUTLINE
    3. INTRODUCTION
    4. DISK STORAGE
    5. FILE ORGANIZATIONS AND ACCESS METHODS
    6. INPUTS TO PHYSICAL DATABASE DESIGN
    7. PHYSICAL DATABASE DESIGN TECHNIQUES
    8. EXAMPLE: GOOD READING BOOK STORES
    9. EXAMPLE: WORLD MUSIC ASSOCIATION
    10. EXAMPLE: LUCKY RENT-A-CAR
    11. SUMMARY
    12. KEY TERMS
    13. QUESTIONS
    14. EXERCISES
    15. MINICASES
  18. CHAPTER 9: OBJECT-ORIENTED DATABASE MANAGEMENT
    1. OBJECTIVES
    2. CHAPTER OUTLINE
    3. INTRODUCTION
    4. TERMINOLOGY
    5. COMPLEX RELATIONSHIPS
    6. ENCAPSULATION
    7. ABSTRACT DATA TYPES
    8. OBJECT/RELATIONAL DATABASE
    9. SUMMARY
    10. KEY TERMS
    11. QUESTIONS
    12. EXERCISES
    13. MINICASES
  19. CHAPTER 10: DATA ADMINISTRATION, DATABASE ADMINISTRATION, AND DATA DICTIONARIES
    1. OBJECTIVES
    2. CHAPTER OUTLINE
    3. INTRODUCTION
    4. THE ADVANTAGES OF DATA AND DATABASE ADMINISTRATION
    5. THE RESPONSIBILITIES OF DATA ADMINISTRATION
    6. THE RESPONSIBILITIES OF DATABASE ADMINISTRATION
    7. DATA DICTIONARIES
    8. SUMMARY
    9. KEY TERMS
    10. QUESTIONS
    11. EXERCISES
    12. MINICASES
  20. CHAPTER 11: DATABASE CONTROI ISSUES: SECURITY, BACKUP AND RECOVERY, CONCURRENCY
    1. OBJECTIVES
    2. CHAPTER OUTLINE
    3. INTRODUCTION
    4. DATA SECURITY
    5. BACKUP AND RECOVERY
    6. CONCURRENCY CONTROL
    7. SUMMARY
    8. KEY TERMS
    9. QUESTIONS
    10. EXERCISES
    11. MINICASES
  21. CHAPTER 12: CLIENT/SERVER DATABASE AND DISTRIBUTED DATABASIE
    1. OBJECTIVES
    2. CHAPTER OUTLINE
    3. INTRODUCTION
    4. CLIENT/SERVER DATABASES
    5. DISTRIBUTED DATABASE
    6. SUMMARY
    7. KEY TERMS
    8. QUESTIONS
    9. EXERCISES
    10. MINICASES
  22. CHAPTER 13: THE DATA WAREHOUSE
    1. OBJECTIVES
    2. CHAPTER OUTLINE
    3. INTRODUCTION
    4. THE DATA WAREHOUSE CONCEPT
    5. TYPES OF DATA WAREHOUSES
    6. DESIGNING A DATA WAREHOUSE
    7. BUILDING A DATA WAREHOUSE
    8. USING A DATA WAREHOUSE
    9. ADMINISTERING A DATA WAREHOUSE
    10. CHALLENGES IN DATA WAREHOUSING
    11. SUMMARY
    12. KEY TERMS
    13. QUESTIONS
    14. EXERCISES
    15. MINICASES
  23. CHAPTER 14: DATABASES AND THE INTERNET
    1. OBJECTIVES
    2. CHAPTER OUTLINE
    3. INTRODUCTION
    4. DATABASE CONNECTIVITY ISSUES
    5. EXPANDED SET OF DATA TYPES
    6. DATABASE CONTROL ISSUES
    7. DATA EXTRACTION INTO XML
    8. SUMMARY
    9. KEY TERMS
    10. QUESTIONS
    11. EXERCISES
    12. MINICASES
  24. INDEX