Database Design for Mortals - A Guide to Relational Database Design (Second Edition)

Author: MICHAEL
Publisher:
Publish Date: 2005-04-01
Features: A robust database design can save a significant amount of development time and ensure functionality and reliability. This book provides a direct, platform-independent guide to relational database design, as well as general methodologies for database development. Additionally, reading this book does not require a background in database design, as it explains how to design databases correctly. If you are just beginning to take an interest in database management, this book will be very useful to you, as it is easier to read than other books on the subject. Many books on database design on the market are highly technical and may be difficult to digest, but the design principles you will learn in this book are easy to understand and remember, and the examples provided are universally applicable. Therefore, this book can indeed serve as an introductory guide to the field of database specialization.
Key Features of the Book:
■ Strict focus on database logical design;
■ Review questions at the end of each chapter from Chapter 1 to Chapter 12, with answers provided in Appendix A;
■ Flowcharts of the design process in Appendix B for quick reference;
■ All design guidelines are compiled in Appendix C;
■ Access the author's website at http://www.formeremortals.com to explore other recommended resources;
■ To contact the author, send an email to mihernandez@msn.com.
This book primarily focuses on the logical design of databases, discussing how to establish table structures, determine primary keys, set field descriptions, create table relationships, establish views, and enforce data integrity at various levels. It also covers how to avoid poor design and when to follow or break rules during the design process. The logical design of a database is the key to the entire database design process. Compared to most similar books, this book has two distinctive features: First, the author uses fewer technical terms, explaining the design process of relational databases as clearly and comprehensively as possible without resorting to the advanced, traditional methodologies commonly found in most database design books. Second, the author strictly focuses on database logical design, adhering to the separation of logical design and implementation stages to ensure an efficient database design process.
This book is suitable for undergraduate and graduate students in computer science and related fields, as well as professionals in the database-related field for reference.