1. Home
  2. SQL
  3. Database design for mere mortals

Elements of the Ideal Table

  Previous section   Next section

  • It represents a single subject, which can be an object or event.

  • It has a primary key.

  • It does not contain multipart or multivalued fields.

  • It does not contain calculated fields.

  • It does not contain unnecessary duplicate fields.

  • It contains only an absolute minimum amount of redundant data.

Top
Part I: Relational Database Design
Part II: The Design Process
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. Recommended Reading