Home Page Icon
Home Page
Table of Contents for
Dedication
Close
Dedication
by MARK L. GILLENSON
Fundamentals of Database Management Systems, Second Edition
Cover Page
Title Page
Copyright
OTHER JOHN WILEY & SONS, INC. DATABASE BOOKS
Dedication
Brief Contents
Contents
PREFACE
PURPOSE OF THIS BOOK
NEW IN THE SECOND EDITION
ORGANIZATION OF THIS BOOK
SUPPLEMENTS
ACKNOWLEDGMENTS
ABOUT THE AUTHOR
CHAPTER 1: DATA: THE NEW CORPORATE RESOURCE
OBJECTIVES
CHAPTER OUTLINE
INTRODUCTION
THE HISTORY OF DATA
DATA IN TODAY'S INFORMATION SYSTEMS ENVIRONMENT
SUMMARY
KEY TERMS
QUESTIONS
EXERCISES
MINICASES
CHAPTER 2: DATA MODELING
OBJECTIVES
CHAPTER OUTLINE
INTRODUCTION
BINARY RELATIONSHIPS
UNARY RELATIONSHIPS
TERNARY RELATIONSHIPS
EXAMPLE: THE GENERAL HARDWARE COMPANY
EXAMPLE: GOOD READING BOOK STORES
EXAMPLE: WORLD MUSIC ASSOCIATION
EXAMPLE: LUCKY RENT-A-CAR
SUMMARY
KEY TERMS
QUESTIONS
EXERCISES
MINICASES
CHAPTER 3: THE DATABASE MANAGEMENT SYSTEM CONCEPT
OBJECTIVES
CHAPTER OUTLINE
INTRODUCTION
DATA BEFORE DATABASE MANAGEMENT
THE DATABASE CONCEPT
DBMS APPROACHES
SUMMARY
KEY TERMS
QUESTIONS
EXERCISES
MINICASES
CHAPTER 4: RELATIONAL DATA RETRIEVAL: SQL
OBJECTIVES
CHAPTER OUTLINE
INTRODUCTION
DATA RETRIEVAL WITH THE SQL SELECT COMMAND
EXAMPLE: GOOD READING BOOK STORES
EXAMPLE: WORLD MUSIC ASSOCIATION
EXAMPLE: LUCKY RENT-A-CAR
RELATIONAL QUERY OPTIMIZER
SUMMARY
KEY TERMS
QUESTIONS
EXERCISES
MINICASES
CHAPTER 5: THE RELATIONAL DATABASE MODEL: INTRODUCTION
OBJECTIVES
CHAPTER OUTLINE
INTRODUCTION
THE RELATIONAL DATABASE CONCEPT
DATA RETRIEVAL FROM A RELATIONAL DATABASE
EXAMPLE: GOOD READING BOOK STORES
EXAMPLE: WORLD MUSIC ASSOCIATION
EXAMPLE: LUCKY RENT-A-CAR
SUMMARY
KEY TERMS
QUESTIONS
EXERCISES
MINICASES
CHAPTER 6: THE RELATIONAL DATABASE MODEL: ADDITIONAL CONCEPTS
OBJECTIVES
CHAPTER OUTLINE
INTRODUCTION
RELATIONAL STRUCTURES FOR UNARY AND TERNARY RELATIONSHIPS
REFERENTIAL INTEGRITY
SUMMARY
KEY TERMS
QUESTIONS
EXERCISES
MINICASES
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
OBJECTIVES
CHAPTER OUTLINE
INTRODUCTION
TERMINOLOGY
COMPLEX RELATIONSHIPS
ENCAPSULATION
ABSTRACT DATA TYPES
OBJECT/RELATIONAL DATABASE
SUMMARY
KEY TERMS
QUESTIONS
EXERCISES
MINICASES
CHAPTER 10: DATA ADMINISTRATION, DATABASE ADMINISTRATION, AND DATA DICTIONARIES
OBJECTIVES
CHAPTER OUTLINE
INTRODUCTION
THE ADVANTAGES OF DATA AND DATABASE ADMINISTRATION
THE RESPONSIBILITIES OF DATA ADMINISTRATION
THE RESPONSIBILITIES OF DATABASE ADMINISTRATION
DATA DICTIONARIES
SUMMARY
KEY TERMS
QUESTIONS
EXERCISES
MINICASES
CHAPTER 11: DATABASE CONTROI ISSUES: SECURITY, BACKUP AND RECOVERY, CONCURRENCY
OBJECTIVES
CHAPTER OUTLINE
INTRODUCTION
DATA SECURITY
BACKUP AND RECOVERY
CONCURRENCY CONTROL
SUMMARY
KEY TERMS
QUESTIONS
EXERCISES
MINICASES
CHAPTER 12: CLIENT/SERVER DATABASE AND DISTRIBUTED DATABASIE
OBJECTIVES
CHAPTER OUTLINE
INTRODUCTION
CLIENT/SERVER DATABASES
DISTRIBUTED DATABASE
SUMMARY
KEY TERMS
QUESTIONS
EXERCISES
MINICASES
CHAPTER 13: THE DATA WAREHOUSE
OBJECTIVES
CHAPTER OUTLINE
INTRODUCTION
THE DATA WAREHOUSE CONCEPT
TYPES OF DATA WAREHOUSES
DESIGNING A DATA WAREHOUSE
BUILDING A DATA WAREHOUSE
USING A DATA WAREHOUSE
ADMINISTERING A DATA WAREHOUSE
CHALLENGES IN DATA WAREHOUSING
SUMMARY
KEY TERMS
QUESTIONS
EXERCISES
MINICASES
CHAPTER 14: DATABASES AND THE INTERNET
OBJECTIVES
CHAPTER OUTLINE
INTRODUCTION
DATABASE CONNECTIVITY ISSUES
EXPANDED SET OF DATA TYPES
DATABASE CONTROL ISSUES
DATA EXTRACTION INTO XML
SUMMARY
KEY TERMS
QUESTIONS
EXERCISES
MINICASES
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
OTHER JOHN WILEY & SONS, INC. DATABASE BOOKS
Next
Next Chapter
Brief Contents
To my mother Sunny's memory and to my favorite mother-in-law, Moo
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset