Database Design For Mere Mortals®: A Hands On Guide To Relational Michael J. Hernandez Mortals D
User Manual:
Open the PDF directly: View PDF
Page Count: 660 [warning: Documents this large are best viewed by clicking the View PDF Link!]
- Contents
- Foreword
- Preface
- Acknowledgments
- Introduction
- PART I: RELATIONAL DATABASE DESIGN
- 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
- Chapter 6: Analyzing the Current Database
- Chapter 7: Establishing Table Structures
- Chapter 8: Keys
- Chapter 9: Field Specifications
- Chapter 10: Table Relationships
- Chapter 11: Business Rules
- Chapter 12: Views
- Chapter 13: Reviewing Data Integrity
- Chapter 4: Conceptual Overview
- PART III: OTHER DATABASE DESIGN ISSUES
- PART IV: APPENDIXES
- Appendix A: Answers to Review Questions
- 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: On Normalization
- Appendix H: Recommended Reading
- Glossary
- References
- Index