Note: Supplemental materials are not guaranteed with Rental or Used book purchases.
What is included with this book?
Michael J Hernandez has been an independent relational database consultant specializing relational database design. He has over 20 years of experience in the technology industry, developing database application for a wide variety of clients. He’s been a contributing author to wide variety of magazine columns, white papers, books and periodicals, and is co-author of the best-selling SQL Queries for Mere Mortals. Mike has been a top-rated and noted technical trainer for the government, the military, the private sector and companies throughout the United States. He has spoken at numerous national and international conferences, and has consistently been a top-rated speaker and presenter.
Aside from his technical background, Mike has a diverse set of skills and interests that he also pursues, ranging from the artisitc to the metaphysical. His greatest interest is still the guitar, as he’s been a practicing guitarist for over 40 years and once played professionally for 15 years. He’s a great cook, loves to teach (writing, public speaking, music), has a gift for bad puns, and even reads Tarot cards.
He says he’s never going to retire, per se, but rather just change whatever it is he’s doing whenever he finally gets tired of it and move on to something else that interests him.
I. RELATIONAL DATABASE DESIGN
Chapter 1: The Relational Database
Chapter 2: Design Objectives
Chapter 3: Terminology
II. THE DESIGN PROCESS
Chapter 4: Conceptual Overview
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
III. OTHER DATABASE DESIGN ISSUES
Chapter 14: Bad Design-What Not To Do
Chapter 15: Bending or Breaking the Rules
Appendix A: Answers to Review Questions
Appendix B: Diagram of the Database Design Process
Appendix C: Design Guidelines
Appendix D: Documentation Forms
Appendix E: Database Design Diagram Symbols
Appendix F: Sample Designs
Appendix G: On Normalization
Appendix H: Recommended Reading