{"product_id":"database-design-for-mere-mortals-9780136788041","title":"Database Design for Mere Mortals","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e\u003cdiv\u003e  \u003cb\u003eMichael J. Hernandez\u003c\/b\u003e is a man with many talents and has done quite a bit in his life, and he continues to do many things to keep him busy. You could say he's a modern-day Renaissance Man. \u003c\/div\u003e \u003cdiv\u003e  \u003cbr\u003e \u003c\/div\u003e \u003cdiv\u003e  \u003cbr\u003e \u003c\/div\u003e \u003cdiv\u003e  For instance, he has been an independent database consultant with more than 25 years of experience in the technology industry, and has been a contributing author to a wide variety of magazine articles, white papers, books, and periodicals. Mike has also been a top-rated and noted technical instructor for two national training organizations, the government, the military, the private sector, and companies throughout the United States, and he has been a top-rated speaker and presenter at numerous national and international conferences. He also worked full-time at Microsoft for seven years as a program manager, product manager, and marketing manager in the Visual Studio Group. \u003c\/div\u003e \u003cdiv\u003e  \u003cbr\u003e \u003c\/div\u003e \u003cdiv\u003e  \u003cbr\u003e \u003c\/div\u003e \u003cdiv\u003e  Mike is main\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003eForeword     xix    \u003cbr\u003e    Preface     xxi    \u003cbr\u003e    \u003cb\u003eIntroduction xxix\u003c\/b\u003e    \u003cbr\u003e    What's New in the Fourth Edition     xxxi    \u003cbr\u003e    Who Should Read This Book     xxxii    \u003cbr\u003e    The Purpose of This Book     xxxiii    \u003cbr\u003e    How to Read This Book     xxxvi    \u003cbr\u003e    How This Book Is Organized     xxxvii    \u003cbr\u003e    A Word about the Examples and Techniques in This Book     xl    \u003cbr\u003e    \u003cb\u003ePART I:  RELATIONAL DATA BASE DESIGN     1\u003c\/b\u003e    \u003cb\u003e\u003cbr\u003e\u003c\/b\u003e    \u003cb\u003eChapter 1:  The Relational Database     3\u003c\/b\u003e    \u003cbr\u003e    Topics Covered in This Chapter     3    \u003cbr\u003e    What Is a Database?     3    \u003cbr\u003e    The Relational Database     5    \u003cbr\u003e        Retrieving Data     7    \u003cbr\u003e        Advantages of a Relational Database     9    \u003cbr\u003e        Relational Database Management Systems     10    \u003cbr\u003e    What's Next?     11    \u003cbr\u003e    Summary     13    \u003cbr\u003e    Review Questions     14    \u003cbr\u003e    \u003cb\u003eChapter 2:  Design Objectives     17\u003c\/b\u003e    \u003cbr\u003e    Topics Covered in This Chapter     17    \u003cbr\u003e    Why Should You Be Concerned with Database Design?     17    \u003cbr\u003e    The Importance of Theory     19    \u003cbr\u003e    The Advantage of Learning a Good Design Methodology     21    \u003cbr\u003e    Objectives of Good Design     22    \u003cbr\u003e    Benefits of Good Design     23    \u003cbr\u003e    Database-Design Methods     24    \u003cbr\u003e        Traditional Design Methods     24    \u003cbr\u003e        The Design Method Presented in This Book     26    \u003cbr\u003e    Normalization     27    \u003cbr\u003e    Summary     30    \u003cbr\u003e    Review Questions     31    \u003cbr\u003e    \u003cb\u003eChapter 3:  Terminology     33\u003c\/b\u003e    \u003cbr\u003e    Topics Covered in This Chapter     33    \u003cbr\u003e    Why This Terminology Is Important     33    \u003cbr\u003e    Value-Related Terms     35    \u003cbr\u003e        Data     35    \u003cbr\u003e        Information     35    \u003cbr\u003e        Null     37    \u003cbr\u003e        The Value of Null     38    \u003cbr\u003e        The Problem with Null     39    \u003cbr\u003e    Structure-Related Terms     41    \u003cbr\u003e        Table     41    \u003cbr\u003e        Field     44    \u003cbr\u003e        Record     45    \u003cbr\u003e        View     46    \u003cbr\u003e        Keys     48    \u003cbr\u003e        Index     50    \u003cbr\u003e    Relationship-Related Terms     50    \u003cbr\u003e        Relationships     50    \u003cbr\u003e        Types of Relationships     52    \u003cbr\u003e        Types of Participation     57    \u003cbr\u003e        Degree of Participation     57    \u003cbr\u003e    Integrity-Related Terms     59    \u003cbr\u003e        Field Specification     59    \u003cbr\u003e        Data Integrity     59    \u003cbr\u003e    Summary     61    \u003cbr\u003e    Review Questions     62    \u003cbr\u003e    \u003cb\u003ePART II:  THE DESIGN PROCESS     65\u003c\/b\u003e    \u003cb\u003e\u003cbr\u003e\u003c\/b\u003e    \u003cb\u003eChapter 4:  Conceptual Overview     67\u003c\/b\u003e    \u003cbr\u003e    Topics Covered in This Chapter     67    \u003cbr\u003e    The Importance of Completing the Design Process     68    \u003cbr\u003e    Defining a Mission Statement and Mission Objectives     69    \u003cbr\u003e    Analyzing the Current Database     70    \u003cbr\u003e    Creating the Data Structures     72    \u003cbr\u003e    Determining and Establishing Table Relationships     73    \u003cbr\u003e    Determining and Defining Business Rules     74    \u003cbr\u003e    Determining and Defining Views     75    \u003cbr\u003e    Reviewing Data Integrity     75    \u003cbr\u003e    Summary     77    \u003cbr\u003e    Review Questions     78    \u003cbr\u003e    \u003cb\u003eChapter 5:  Starting the Process     81\u003c\/b\u003e    \u003cbr\u003e    Topics Covered in This Chapter     81    \u003cbr\u003e    Conducting Interviews     82    \u003cbr\u003e        Participant Guidelines     84    \u003cbr\u003e        Interviewer Guidelines (These Are for You)     86    \u003cbr\u003e    Defining the Mission Statement     91    \u003cbr\u003e        The Well-Written Mission Statement     91    \u003cbr\u003e        Composing a Mission Statement     93    \u003cbr\u003e    Defining the Mission Objectives     96    \u003cbr\u003e        Well-Written Mission Objectives     97    \u003cbr\u003e        Composing Mission Objectives     99    \u003cbr\u003e    Summary     103    \u003cbr\u003e    Review Questions     104    \u003cbr\u003e    \u003cb\u003eChapter 6:  Analyzing the Current Database     107\u003c\/b\u003e    \u003cbr\u003e    Topics Covered in This Chapter     107    \u003cbr\u003e    Getting to Know the Current Database     107    \u003cbr\u003e        Paper-Based Databases     111    \u003cbr\u003e        Legacy Databases     111    \u003cbr\u003e    Conducting the Analysis     113    \u003cbr\u003e    Looking at How Data Is Collected     113    \u003cbr\u003e    Looking at How Information Is Presented     116    \u003cbr\u003e    Conducting Interviews     120    \u003cbr\u003e        Basic Interview Techniques     121    \u003cbr\u003e        Before You Begin the Interview Process     128    \u003cbr\u003e    Interviewing Users     128    \u003cbr\u003e        Reviewing Data Type and Usage     129    \u003cbr\u003e        Reviewing the Samples     131    \u003cbr\u003e        Reviewing Information Requirements     135    \u003cbr\u003e    Interviewing Management     143    \u003cbr\u003e        Reviewing Current Information Requirements     144    \u003cbr\u003e        Reviewing Additional Information Requirements     145    \u003cbr\u003e        Reviewing Future Information Requirements     146    \u003cbr\u003e        Reviewing Overall Information Requirements     147    \u003cbr\u003e    Compiling a Complete List of Fields     148    \u003cbr\u003e        The Preliminary Field List     148    \u003cbr\u003e        The Calculated Field List     156    \u003cbr\u003e        Reviewing Both Lists with Users and Management     156    \u003cbr\u003e    Summary     162    \u003cbr\u003e    Review Questions     164    \u003cbr\u003e    \u003cb\u003eChapter 7:  Establishing Table Structures     165\u003c\/b\u003e    \u003cbr\u003e    Topics Covered in This Chapter     165    \u003cbr\u003e    Defining the Preliminary Table List     166    \u003cbr\u003e        Identifying Implied Subjects     166    \u003cbr\u003e        Using the List of Subjects     168    \u003cbr\u003e        Using the Mission Objectives     172    \u003cbr\u003e    Defining the Final Table List     174    \u003cbr\u003e        Refining the Table Names     176    \u003cbr\u003e        Indicating the Table Types     182    \u003cbr\u003e        Composing the Table Descriptions     182    \u003cbr\u003e    Associating Fields with Each Table     189    \u003cbr\u003e    Refining the Fields     191    \u003cbr\u003e        Improving the Field Names     191    \u003cbr\u003e        Using an Ideal Field to Resolve Anomalies     196    \u003cbr\u003e        Resolving Multipart Fields     199    \u003cbr\u003e        Resolving Multivalued Fields     201    \u003cbr\u003e    Refining the Table Structures     208    \u003cbr\u003e        A Word about Redundant Data and Duplicate Fields     208    \u003cbr\u003e        Using an Ideal Table to Refine Table Structures     209    \u003cbr\u003e        Establishing Subset Tables     216    \u003cbr\u003e    Summary     229    \u003cbr\u003e    Review Questions     231    \u003cbr\u003e    \u003cb\u003eChapter 8:  Keys     233\u003c\/b\u003e    \u003cbr\u003e    Topics Covered in This Chapter     233    \u003cbr\u003e    Why Keys Are Important     234    \u003cbr\u003e    Establishing Keys for Each Table     234    \u003cbr\u003e        Candidate Keys     235    \u003cbr\u003e        Primary Keys     243    \u003cbr\u003e        Alternate Keys     249    \u003cbr\u003e        Non-keys     250    \u003cbr\u003e    Table-Level Integrity     251    \u003cbr\u003e    Reviewing the Initial Table Structures     251    \u003cbr\u003e    Summary     259    \u003cbr\u003e    Review Questions     260    \u003cbr\u003e    \u003cb\u003eChapter 9:  Field Specifications     263\u003c\/b\u003e    \u003cbr\u003e    Topics Covered in This Chapter     263    \u003cbr\u003e    Why Field Specifications Are Important     264    \u003cbr\u003e    Field-Level Integrity     266    \u003cbr\u003e    Anatomy of a Field Specification     267    \u003cbr\u003e        General Elements     267    \u003cbr\u003e        Physical Elements     275    \u003cbr\u003e        Logical Elements     278    \u003cbr\u003e    Using Unique, Generic, and Replica Field Specifications     283    \u003cbr\u003e    Defining Field Specifications for Each Field in the Database     287    \u003cbr\u003e    Summary     291    \u003cbr\u003e    Review Questions     292    \u003cbr\u003e    \u003cb\u003eChapter 10:  Table Relationships     293\u003c\/b\u003e    \u003cbr\u003e    Topics Covered in This Chapter     293    \u003cbr\u003e    Why Relationships Are Important     294    \u003cbr\u003e    Types of Relationships     295    \u003cbr\u003e        One-to-One Relationships     296    \u003cbr\u003e        One-to-Many Relationships     298    \u003cbr\u003e        Many-to-Many Relationships     301    \u003cbr\u003e        Self-Referencing Relationships     308    \u003cbr\u003e    Identifying Existing Relationships     312    \u003cbr\u003e    Establishing Each Relationship     323    \u003cbr\u003e        One-to-One and One-to-Many Relationships     323    \u003cbr\u003e        The Many-to-Many Relationship     331    \u003cbr\u003e        Self-Referencing Relationships     337    \u003cbr\u003e        Reviewing the Structure of Each Table     342    \u003cbr\u003e    Refining All Foreign Keys     343    \u003cbr\u003e        Elements of a Foreign Key     343    \u003cbr\u003e    Establishing Relationship Characteristics     349    \u003cbr\u003e        Defining a Deletion Rule for Each Relationship     349    \u003cbr\u003e        Identifying the Type of Participation for Each Table     354    \u003cbr\u003e        Identifying the Degree of Participation for Each Table     357    \u003cbr\u003e        Verifying Table Relationships with Users and Management     360    \u003cbr\u003e        A Final Note     360    \u003cbr\u003e    Relationship-Level Integrity     361    \u003cbr\u003e    Summary     366    \u003cbr\u003e    Review Questions     368    \u003cbr\u003e    \u003cb\u003eChapter 11:  Business Rules     369\u003c\/b\u003e    \u003cbr\u003e    Topics Covered in This Chapter     369    \u003cbr\u003e    What Are Business Rules?     370    \u003cbr\u003e        Types of Business Rules     373    \u003cbr\u003e    Categories of Business Rules     375    \u003cbr\u003e        Field-Specific Business Rules     375    \u003cbr\u003e        Relationship-Specific Business Rules     376    \u003cbr\u003e    Defining and Establishing Business Rules     378    \u003cbr\u003e        Working with Users and Management     378    \u003cbr\u003e        Defining and Establishing Field-Specific Business Rules     379    \u003cbr\u003e        Defining and Establishing Relationship-Specific Business Rules     386    \u003cbr\u003e    Validation Tables     394    \u003cbr\u003e        What Are Validation Tables?     394    \u003cbr\u003e        Using Validation Tables to Support Business Rules     395    \u003cbr\u003e    Reviewing the Business Rule Specifications Sheets     400    \u003cbr\u003e    Summary     408    \u003cbr\u003e    Review Questions     409    \u003cbr\u003e    \u003cb\u003eChapter 12:  Views     411\u003c\/b\u003e    \u003cbr\u003e    Topics Covered in This Chapter     411    \u003cbr\u003e    What Are Views?     411    \u003cbr\u003e    Anatomy of a View     413    \u003cbr\u003e        Data View     413    \u003cbr\u003e        Aggregate View     418    \u003cbr\u003e        Validation View     422    \u003cbr\u003e    Determining and Defining Views     424    \u003cbr\u003e        Working with Users and Management     425    \u003cbr\u003e        Defining Views     426    \u003cbr\u003e        Reviewing the Documentation for Each View     434    \u003cbr\u003e    Summary     441    \u003cbr\u003e    Review Questions     442    \u003cbr\u003e    \u003cb\u003eChapter 13:  Reviewing Data Integrity     445\u003c\/b\u003e    \u003cbr\u003e    Topics Covered in This Chapter     445    \u003cbr\u003e    Why You Should Review Data Integrity     446    \u003cbr\u003e    Reviewing and Refining Data Integrity     446    \u003cbr\u003e        Table-Level Integrity     447    \u003cbr\u003e        Field-Level Integrity     447    \u003cbr\u003e        Relationship-Level Integrity     448    \u003cbr\u003e        Business Rules     448    \u003cbr\u003e        Views     448    \u003cbr\u003e    Assembling the Database Documentation     449    \u003cbr\u003e    Done at Last!     451    \u003cbr\u003e    Summary     452    \u003cbr\u003e    \u003cb\u003ePART III:  OTHER DATA BASE DESIGN ISSUES     453\u003c\/b\u003e    \u003cb\u003e\u003cbr\u003e\u003c\/b\u003e    \u003cb\u003eChapter 14:  Bad Design—What Not to Do     455\u003c\/b\u003e    \u003cbr\u003e    Topics Covered in This Chapter     455    \u003cbr\u003e    “Flat-File” Design     456    \u003cbr\u003e    Spreadsheet Design     457    \u003cbr\u003e        Dealing with the Spreadsheet View Mindset     459    \u003cbr\u003e    Database Design Based on the Database Software     461    \u003cbr\u003e    A Final Thought     463    \u003cbr\u003e    Summary     463    \u003cbr\u003e    \u003cb\u003eChapter 15:  Bending or Breaking the Rules     465\u003c\/b\u003e    \u003cbr\u003e    Topics Covered in This Chapter     465    \u003cbr\u003e    When May You Bend or Break the Rules?     465    \u003cbr\u003e        Designing an Analytical Database     465    \u003cbr\u003e        Improving Processing Performance     466    \u003cbr\u003e    Documenting Your Actions     469    \u003cbr\u003e    Summary     471    \u003cbr\u003e    \u003cb\u003eChapter 16:  In Closing     473\u003c\/b\u003e    \u003cbr\u003e    \u003cb\u003e\u003cbr\u003e\u003c\/b\u003e    \u003cb\u003ePART IV:  APPENDIXES     475\u003c\/b\u003e    \u003cbr\u003e    \u003cb\u003eAppendix A:  Answers to Review Questions     477\u003c\/b\u003e    \u003cb\u003e\u003cbr\u003e\u003c\/b\u003e    \u003cb\u003eAppendix B:  Diagram of the Database Design Process     501\u003c\/b\u003e    \u003cb\u003e\u003cbr\u003e\u003c\/b\u003e    \u003cb\u003eAppendix C:  Design Guidelines     519\u003c\/b\u003e    \u003cb\u003e\u003cbr\u003e\u003c\/b\u003e    \u003cb\u003eAppendix D:  Documentation Forms     529\u003c\/b\u003e    \u003cb\u003e\u003cbr\u003e\u003c\/b\u003e    \u003cb\u003eAppendix E:  Database-Design Diagram Symbols     533\u003c\/b\u003e    \u003cb\u003e\u003cbr\u003e\u003c\/b\u003e    \u003cb\u003eAppendix F:  Sample Designs     535\u003c\/b\u003e    \u003cb\u003e\u003cbr\u003e\u003c\/b\u003e    \u003cb\u003eAppendix G:  On Normalization     541\u003c\/b\u003e    \u003cb\u003e\u003cbr\u003e\u003c\/b\u003e    \u003cb\u003eAppendix H:  Recommended Reading     551\u003c\/b\u003e    \u003cb\u003e\u003cbr\u003e\u003c\/b\u003e    \u003cb\u003eGlossary     553\u003c\/b\u003e    \u003cb\u003e\u003cbr\u003e\u003c\/b\u003e    \u003cb\u003eReferences     567\u003c\/b\u003e    \u003cb\u003e\u003cbr\u003e\u003c\/b\u003e    \u003cb\u003eIndex     569\u003c\/b\u003e    \u003cbr\u003e\n\u003c\/div\u003e","brand":"Pearson Education (US)","offers":[{"title":"Default Title","offer_id":48883799064919,"sku":"9780136788041","price":36.89,"currency_code":"GBP","in_stock":false}],"url":"https:\/\/bookcurl.com\/products\/database-design-for-mere-mortals-9780136788041","provider":"Book Curl","version":"1.0","type":"link"}