Flylib.com
Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design
Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design
ISBN: 0201694719
EAN: 2147483647
Year: 2002
Pages: 203
Authors:
Michael J. Hernandez
BUY ON AMAZON
Copyright
Praise for Database Design for Mere Mortals, Second Edition
Praise for the First Edition
About the Author
Foreword
From the First Edition . . .
Preface (Second Edition)
Acknowledgments
Preface (First Edition)
Acknowledgments
Introduction
What s New in the Second Edition
Who Should Read This Book
The Purpose of This Book
How to Read This Book
How This Book Is Organized
A Word About the Examples and Techniques in This Book
Part I: Relational Database Design
Chapter 1. The Relational Database
Topics Covered in This Chapter
Types of Databases
Early Database Models
The Relational Database Model
Relational Database Management Systems
Beyond the Relational Model
What the Future Holds
Summary
Review Questions
Chapter 2. Design Objectives
Topics Covered in This Chapter
Why Should You Be Concerned with Database Design?
The Importance of Theory
The Advantage of Learning a Good Design Methodology
Objectives of Good Design
Benefits of Good Design
Database-Design Methods
Summary
Review Questions
Chapter 3. Terminology
Topics Covered in This Chapter
Why This Terminology Is Important
Value-Related Terms
Structure-Related Terms
Relationship-Related Terms
Integrity-Related Terms
Summary
Review Questions
Part II: The Design Process
Chapter 4. Conceptual Overview
Topics Covered in This Chapter
The Importance of Completing the Design Process
Defining a Mission Statement and Mission Objectives
Analyzing the Current Database
Creating the Data Structures
Determining and Establishing Table Relationships
Determining and Defining Business Rules
Determining and Defining Views
Reviewing Data Integrity
Summary
Review Questions
Chapter 5. Starting the Process
Topics Covered in This Chapter
Conducting Interviews
The Case Study: Mike s Bikes
Defining the Mission Statement
Defining the Mission Objectives
Summary
Review Questions
Chapter 6. Analyzing the Current Database
Topics Covered in This Chapter
Getting to Know the Current Database
Conducting the Analysis
Looking at How Data Is Collected
Looking at How Information Is Presented
Conducting Interviews
Interviewing Users
Interviewing Management
Compiling a Complete List of Fields
Summary
Review Questions
Chapter 7. Establishing Table Structures
Topics Covered in This Chapter
Defining the Preliminary Table List
Defining the Final Table List
Associating Fields with Each Table
Refining the Fields
Refining the Table Structures
Summary
Review Questions
Chapter 8. Keys
Topics Covered in This Chapter
Why Keys Are Important
Establishing Keys for Each Table
Table-Level Integrity
Reviewing the Initial Table Structures
Summary
Review Questions
Chapter 9. Field Specifications
Topics Covered in This Chapter
Why Field Specifications Are Important
Field-Level Integrity
Anatomy of a Field Specification
Using Unique, Generic, and Replica Field Specifications
Defining Field Specifications for Each Field in the Database
Summary
Review Questions
Chapter 10. Table Relationships
Topics Covered in This Chapter
Why Relationships Are Important
Types of Relationships
Identifying Existing Relationships
Establishing Each Relationship
Refining All Foreign Keys
Establishing Relationship Characteristics
Relationship-Level Integrity
Summary
Review Questions
Chapter 11. Business Rules
Topics Covered in This Chapter
What Are Business Rules?
Categories of Business Rules
Defining and Establishing Business Rules
Validation Tables
Reviewing the Business Rule Specifications Sheets
Summary
Review Questions
Chapter 12. Views
Topics Covered in This Chapter
What Are Views?
Anatomy of a View
Determining and Defining Views
Summary
Review Questions
Chapter 13. Reviewing Data Integrity
Topics Covered in This Chapter
Why You Should Review Data Integrity
Reviewing and Refining Data Integrity
Assembling the Database Documentation
Done at Last
Summary
Part III: Other Database-Design Issues
Chapter 14. Bad Design-What Not to Do
Topics Covered in This Chapter
Flat-File Design
Spreadsheet Design
Database Design Based on the Database Software
A Final Thought
Summary
Chapter 15. Bending or Breaking the Rules
Topics Covered in This Chapter
When May You Bend or Break the Rules?
Documenting Your Actions
Summary
Part I: Relational Database Design
In Closing
Part IV: Appendixes
Appendix A. Answers to Review Questions
Chapter 1
Chapter 2
Chapter 3
Chapter 4
Chapter 5
Chapter 6
Chapter 7
Chapter 8
Chapter 9
Chapter 10
Chapter 11
Chapter 12
Appendix B. Diagram of the Database-Design Process
Appendix C. Design Guidelines
Defining and Establishing Field Specific Business Rules
Defining and Establishing Relationship Specific Business Rules
Elements of a Candidate Key
Elements of a Foreign Key
Elements of a Primary Key
Elements of the Ideal Field
Elements of the Ideal Table
Field-Level Integrity
Guidelines for Composing a Field Description
Guidelines for Composing a Table Description
Guidelines for Creating Field Names
Guidelines for Creating Table Names
Identifying Relationships
Identifying View Requirements
Interview Guidelines
Mission Statements
Mission Objectives
Relationship-Level Integrity
Resolving a Multivalued Field
Table-Level Integrity
Appendix D. Documentation Forms
Appendix E. Database-Design Diagram Symbols
Appendix F. Sample Designs
Appendix G. Recommended Reading
Glossary
References
References
Index
TOC
C
H
R
Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design
ISBN: 0201694719
EAN: 2147483647
Year: 2002
Pages: 203
Authors:
Michael J. Hernandez
BUY ON AMAZON
ERP and Data Warehousing in Organizations: Issues and Challenges
Enterprise Application Integration: New Solutions for a Solved Problem or a Challenging Research Field?
Data Mining for Business Process Reengineering
Intrinsic and Contextual Data Quality: The Effect of Media and Personal Involvement
A Hybrid Clustering Technique to Improve Patient Data Quality
Relevance and Micro-Relevance for the Professional as Determinants of IT-Diffusion and IT-Use in Healthcare
CISSP Exam Cram 2
Introduction
Equipment Life Cycle
Penetration Testing
Operational Security
Public Key Infrastructure (PKI)
Practical Intrusion Analysis: Prevention and Detection for the Twenty-First Century: Prevention and Detection for the Twenty-First Century
Unauthorized Activity I
Tcpdump
IDS and IPS Architecture
Security Business Issues
The Future of Intrusion Detection and Prevention
Service-Oriented Architecture (SOA): Concepts, Technology, and Design
How this book is organized
Messaging (with SOAP)
Native Web service support for service-orientation principles
Part IV: Building SOA (Planning and Analysis)
Appendix B. Service Models Reference
Java Concurrency in Practice
Composing Objects
Implicit Couplings Between Tasks and Execution Policies
Costs Introduced by Threads
Example: Comparing Map Performance
AbstractQueuedSynchronizer
Understanding Digital Signal Processing (2nd Edition)
THE DFT SINGLE-BIN FREQUENCY RESPONSE TO A REAL COSINE INPUT
AN INTRODUCTION TO INFINITE IMPULSE RESPONSE FILTERS
REFERENCES
Chapter Nine. The Discrete Hilbert Transform
COMPARING ANALYTIC SIGNAL GENERATION METHODS
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies