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
- Cover Page
- Title Page
- Copyright
- OTHER JOHN WILEY & SONS, INC. DATABASE BOOKS
- Dedication
- Brief Contents
- Contents
- PREFACE
- ABOUT THE AUTHOR
- CHAPTER 1: DATA: THE NEW CORPORATE RESOURCE
- CHAPTER 2: DATA MODELING
- CHAPTER 3: THE DATABASE MANAGEMENT SYSTEM CONCEPT
- CHAPTER 4: RELATIONAL DATA RETRIEVAL: SQL
- CHAPTER 5: THE RELATIONAL DATABASE MODEL: INTRODUCTION
- CHAPTER 6: THE RELATIONAL DATABASE MODEL: ADDITIONAL CONCEPTS
-
CHAPTER 7: LOGICAL DATABASE DESIGN
- OBJECTIVES
- CHAPTER OUTLINE
- INTRODUCTION
- CONVERTING E-R DIAGRAMS INTO RELATIONAL TABLES
- THE DATA NORMALIZATION PROCESS
- TESTING TABLES CONVERTED FROM E-R DIAGRAMS WITH DATA NORMALIZATION
- BUILDING THE DATA STRUCTURE WITH SQL
- MANIPULATING THE DATA WITH SQL
- SUMMARY
- KEY TERMS
- QUESTIONS
- EXERCISES
- MINICASES
-
CHAPTER 8: PHYSICAL DATABASE DESIGN
- OBJECTIVES
- CHAPTER OUTLINE
- INTRODUCTION
- DISK STORAGE
- FILE ORGANIZATIONS AND ACCESS METHODS
- INPUTS TO PHYSICAL DATABASE DESIGN
- PHYSICAL DATABASE DESIGN TECHNIQUES
- EXAMPLE: GOOD READING BOOK STORES
- EXAMPLE: WORLD MUSIC ASSOCIATION
- EXAMPLE: LUCKY RENT-A-CAR
- SUMMARY
- KEY TERMS
- QUESTIONS
- EXERCISES
- MINICASES
- CHAPTER 9: OBJECT-ORIENTED DATABASE MANAGEMENT
- CHAPTER 10: DATA ADMINISTRATION, DATABASE ADMINISTRATION, AND DATA DICTIONARIES
- CHAPTER 11: DATABASE CONTROI ISSUES: SECURITY, BACKUP AND RECOVERY, CONCURRENCY
- CHAPTER 12: CLIENT/SERVER DATABASE AND DISTRIBUTED DATABASIE
- CHAPTER 13: THE DATA WAREHOUSE
- CHAPTER 14: DATABASES AND THE INTERNET
- INDEX
Product information
- Title: Fundamentals of Database Management Systems, Second Edition
- Author(s):
- Release date: December 2011
- Publisher(s): Wiley
- ISBN: 9780470624708
You might also like
book
Introduction to Database Management Systems
Introduction to Database Management Systems is designed specifically for a single semester, namely, the first course …
book
Database Administration: The Complete Guide to Practices and Procedures
"One of Craig's hallmarks is his ability to write in a clear, easy-to-read fashion. The main …
book
Concepts of Database Management System
Concepts of Database Management System is designed to meet the syllabi requirements of undergraduate students of …
book
Database Systems
Database Systems: A Pragmatic Approach provides a comprehensive, yet concise introduction to database systems. It discusses …