Database Design for Mere Mortals� A Hands-On Guide to Relational Database Design

ISBN-10: 0201752840

ISBN-13: 9780201752847

Edition: 2nd 2003 (Revised)

List price: $74.99
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

Description: Sound database design can save hours of development time and result in a database which is more functional and easier to use. This book is a straightforward, platform-independent tutorial on the basic principles of relational database design, based on the author's years of experience teaching this material. Hernandez introduces the core concepts of design theory and method without the technical jargon. His use of hands-on examples and a wealth of practical examples made the first edition of this book the bestselling book on database design. Now the author has made a great book even better. He has rewritten much of the text, clarifyied old examples and added new ones, incorporated advances in database design, and added a CD-ROM. As Ken Getz says in his foreword to the second edition, "No matter what specific database package you're using, the concepts in this book will make sense, and will apply to your database design projects."

what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!

Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
Periodic Table Online content $4.95 $1.99
Add to cart
Study Briefs
SQL Online content $4.95 $1.99
Add to cart
Study Briefs
MS Excel® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS Word® 2010 Online content $4.95 $1.99

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $74.99
Edition: 2nd
Copyright year: 2003
Publisher: Addison Wesley Professional
Publication date: 3/3/2003
Binding: Paperback
Pages: 672
Size: 7.25" wide x 9.00" long x 1.25" tall
Weight: 2.552
Language: English

Foreword
Preface (Second Edition)
Preface (First Edition)
Introduction
What's New in the Second Edition
Who Should Read This Book
The Purpose of This Book
How to Read This Book
How This Book Is Organized
A Word About the Examples and Techniques in This Book
Relational Database Design
The Relational Database
Topics Covered in This Chapter
Types of Databases
Early Database Models
The Relational Database Model
Relational Database Management Systems
Beyond the Relational Model
What the Future Holds
Summary
Review Questions
Design Objectives
Topics Covered in This Chapter
Why Should You Be Concerned with Database Design?
The Importance of Theory
The Advantage of Learning a Good Design Methodology
Objectives of Good Design
Benefits of Good Design
Database-Design Methods
Summary
Review Questions
Terminology
Topics Covered in This Chapter
Why This Terminology Is Important
Value-Related Terms
Structure-Related Terms
Relationship-Related Terms
Integrity-Related Terms
Summary
Review Questions
The Design Process
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
Starting the Process
Topics Covered in This Chapter
Conducting Interviews
The Case Study: Mike's Bikes
Defining the Mission Statement
Defining the Mission Objectives
Summary
Review Questions
Analyzing the Current Database
Topics Covered in This Chapter
Getting to Know the Current Database
Conducting the Analysis
Looking at How Data Is Collected
Looking at How Information Is Presented
Conducting Interviews
Interviewing Users
Interviewing Management
Compiling a Complete List of Fields
Summary
Review Questions
Establishing Table Structures
Topics Covered in This Chapter
Defining the Preliminary Table List
Defining the Final Table List
Associating Fields with Each Table
Refining the Fields
Refining the Table Structures
Summary
Review Questions
Keys
Topics Covered in This Chapter
Why Keys Are Important
Establishing Keys for Each Table
Table-Level Integrity
Reviewing the Initial Table Structures
Summary
Review Questions
Field Specifications
Topics Covered in This Chapter
Why Field Specifications Are Important
Field-Level Integrity
Anatomy of a Field Specification
Using Unique, Generic, and Replica Field Specifications
Defining Field Specifications for Each Field in the Database
Summary
Review Questions
Table Relationships
Topics Covered in This Chapter
Why Relationships Are Important
Types of Relationships
Identifying Existing Relationships
Establishing Each Relationship
Refining All Foreign Keys
Establishing Relationship Characteristics
Relationship-Level Integrity
Summary
Review Questions
Business Rules
Topics Covered in This Chapter
What Are Business Rules?
Categories of Business Rules
Defining and Establishing Business Rules
Validation Tables
Reviewing the Business Rule Specifications Sheets
Summary
Review Questions
Views
Topics Covered in This Chapter
What Are Views?
Anatomy of a View
Determining and Defining Views
Summary
Review Questions
Reviewing Data Integrity
Topics Covered in This Chapter
Why You Should Review Data Integrity
Reviewing and Refining Data Integrity
Assembling the Database Documentation
Done at Last!
Summary
Other Database-Design Issues
Bad Design--What Not to Do
Topics Covered in This Chapter
Flat-File Design
Spreadsheet Design
Database Design Based on the Database Software
A Final Thought
Summary
Bending or Breaking the Rules
Topics Covered in This Chapter
When May You Bend or Break the Rules?
Documenting Your Actions
Summary
In Closing
Appendixes
Answers to Review Questions
Chapter 1
Chapter 2
Chapter 3
Chapter 4
Chapter 5
Chapter 6
Chapter 7
Chapter 8
Chapter 9
Chapter 10
Chapter 11
Chapter 12
Diagram of the Database-Design Process
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
Documentation Forms
Database-Design Diagram Symbols
Sample Designs
Recommended Reading
Glossary
References
Index
×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×