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
CompTIA Project+ Study Guide: Exam PK0-003
IT Project+ Study Guide
Assessment Test
Answers to Assessment Test
Schedule Planning
Project Execution
Certified Ethical Hacker Exam Prep
Determining Assessment Scope
Study Strategies
Key Terms
Summary
Hacking Wireless Networks
Java How to Program (6th Edition) (How to Program (Deitel))
Introduction
Terminology
Introduction
Sandbox Security Model
Multithreading with GUI
Service-Oriented Architecture (SOA): Concepts, Technology, and Design
What this book does not cover
Common characteristics of contemporary SOA
Metadata exchange
Business service layer
Service layer configuration scenarios
Mapping Hacks: Tips & Tools for Electronic Cartography
Hack 8. Publish Maps of Your Photos on the Web
Hack 35. Search Local, Find Global
Hack 44. Plot Statistics Against Shapes
Hack 60. Improve the Accuracy of Your GPS with Differential GPS
Hack 80. Automatically Geocode U.S. Addresses
Introducing Microsoft ASP.NET AJAX (Pro - Developer)
The AJAX Revolution
The Microsoft Client Library for AJAX
The Pulsing Heart of ASP.NET AJAX
Remote Method Calls with ASP.NET AJAX
Building AJAX Applications with ASP.NET
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