Star Wars Sale
 
 

Special Offers see all

Enter to WIN!

Weekly drawing for $100 credit. Subscribe to PowellsBooks.news for a chance to win.
Privacy Policy

More at Powell's


Recently Viewed clear list


Original Essays | June 20, 2014

Lauren Owen: IMG The Other Vampire



It's a wild and thundery night. Inside a ramshackle old manor house, a beautiful young girl lies asleep in bed. At the window, a figure watches... Continue »
  1. $18.90 Sale Hardcover add to wish list

    The Quick

    Lauren Owen 9780812993271

spacer
Qualifying orders ship free.
$49.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Beaverton Database- General
2 Burnside - Bldg. 2 Database- Design
20 Local Warehouse Database- Design
25 Remote Warehouse Database- Design

Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design (For Mere Mortals)

by

Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design (For Mere Mortals) Cover

 

Out of Print

Synopses & Reviews

Publisher Comments:

The #1 easy, common-sense guide to database design: now updated for the latest databases and applications!

 

Michael J. Hernandez’s best-selling Database Design for Mere Mortals® has earned worldwide respect as the clearest, simplest way to learn relational database design. Now, he’s made this hands-on, software-independent tutorial even easier, while updating it for the latest databases, applications, and best practices.

 

Step by step, Database Design for Mere Mortals®, Third Edition will show you how to design databases that offer superior performance, reliability, and flexibility, even in modern web applications. Hernandez guides you through everything from database planning to defining tables, fields, keys, table relationships, business rules, and views. You’ll learn practical ways to improve data integrity, how to avoid common mistakes … and even when to break the rules.

 

This edition offers an all-new introductory chapter, and text and images are revised throughout to be even clearer and simpler. Updates also include a new guide to normalization, and improved coverage of data types.

Coverage includes

 

·      Understanding database types, models, and design terminology

·      Discovering what good database design can do for you – and why bad design can make your life miserable

·      Setting objectives for your database and transforming them into real designs

·      Analyzing a current database so you can identify ways to improve it

·      Establishing table structures and relationships, assigning primary keys, setting field specifications, and setting up views

·      Ensuring the right levels of data integrity for each application

 

Whatever relational database systems you use, Hernandez will help you design databases that are robust, trustworthy, and solve the right problems. Never designed a database before? Start here. Settling for inadequate generic designs? Start here. Running existing databases that need improvement? Again: start right here.

 

 

 

Synopsis:

 

The #1 Easy, Commonsense Guide to Database Design! Michael J. Hernandez’s best-selling Database Design for Mere Mortals® has earned worldwide respect as the clearest, simplest way to learn relational database design. Now, he’s made this hands-on, software-independent tutorial even easier, while ensuring that his design methodology is still relevant to the latest databases, applications, and best practices. Step by step, Database Design for Mere Mortals ® , Third Edition, shows you how to design databases that are soundly structured, reliable, and flexible, even in modern web applications. Hernandez guides you through everything from database planning to defining tables, fields, keys, table relationships, business rules, and views. You’ll learn practical ways to improve data integrity, how to avoid common mistakes, and when to break the rules.

 

Coverage includes

Understanding database types, models, and design terminology

Discovering what good database design can do for you—and why bad design can make your life miserable

Setting objectives for your database, and transforming those objectives into real designs

Analyzing a current database so you can identify ways to improve it

Establishing table structures and relationships, assigning primary keys, setting field specifications, and setting up views

Ensuring the appropriate level of data integrity for each application

Identifying and establishing business rules

Whatever relational database systems you use, Hernandez will help you design databases that are robust and trustworthy. Never designed a database before? Settling for inadequate generic designs? Running existing databases that need improvement? Start here.

Synopsis:

 

The #1 Easy, Commonsense Guide to Database Design!

 

Michael J. Hernandez’s best-selling Database Design for Mere Mortals® has earned worldwide respect as the clearest, simplest way to learn relational database design. Now, he’s made this hands-on, software-independent tutorial even easier, while ensuring that his design methodology is still relevant to the latest databases, applications, and best practices.

 

Step by step, Database Design for Mere Mortals®, Third Edition, shows you how to design databases that are soundly-structured, reliable and flexible, even in modern web applications. Hernandez guides you through everything from database planning to defining tables, fields, keys, table relationships, business rules, and views. You’ll learn practical ways to improve data integrity, how to avoid common mistakes, and when to break the rules.

 

Coverage includes

 

·      Learning about data types

·      Understanding database types, models, and design terminology

·      Discovering what good database design can do for you—and why bad design can make your life miserable

·      Setting objectives for your database, and transforming those objectives into real designs

·      Analyzing a current database so you can identify ways to improve it

·      Establishing table structures and relationships, assigning primary keys, setting field specifications, and setting up views

·      Ensuring the appropriate level of data integrity for each application

 

Whatever relational database systems you use, Hernandez will help you design databases that are robust and trustworthy. Never designed a database before? Settling for inadequate generic designs? Running existing databases that need improvement? Start here.

 

Instructors: New instructional resources available for this edition include Microsoft Word templates, Microsoft PowerPoint slide decks, and test questions.

 

About the Author

Michael J. Hernandez, a relational database developer with more than twenty years of experience, was a program manager and product manager for Microsoft’s Visual Studio group. He has been a premier instructor with organizations such as AppDev Training Co., Focal Point, Inc., and Deep Training, and was a top-rated speaker at technical conferences across the United States, Europe, and South America. With John L. Viescas, he coauthored SQL Queries for Mere Mortals®, Second Edition (Addison-Wesley, 2008).

Table of Contents

Preface

Introduction

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

IV. APPENDIXES

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

Product Details

ISBN:
9780321884497
Subtitle:
A Hands-On Guide to Relational Database Design
Author:
Hernandez, Michael
Author:
Hernandez, Michael J.
Publisher:
Addison-Wesley Professional
Subject:
Database design
Subject:
Data Modeling & Design
Subject:
Database Management - General
Copyright:
Edition Description:
Trade paper
Series:
For Mere Mortals
Publication Date:
20130214
Binding:
Paperback
Language:
English
Pages:
672
Dimensions:
9 x 7.43 x 1.321 in 1077 gr

Related Subjects

Children's » Action and Adventure » Adventure Stories
Computers and Internet » Artificial Intelligence » General
Computers and Internet » Database » Design
Computers and Internet » Database » General
Computers and Internet » Software Engineering » Software Management
History and Social Science » Politics » General
Science and Mathematics » Materials Science » General
Science and Mathematics » Mathematics » General
Science and Mathematics » Nature Studies » General

Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design (For Mere Mortals) New Trade Paper
0 stars - 0 reviews
$49.99 In Stock
Product details 672 pages Addison-Wesley Professional - English 9780321884497 Reviews:
"Synopsis" by ,

 

The #1 Easy, Commonsense Guide to Database Design! Michael J. Hernandez’s best-selling Database Design for Mere Mortals® has earned worldwide respect as the clearest, simplest way to learn relational database design. Now, he’s made this hands-on, software-independent tutorial even easier, while ensuring that his design methodology is still relevant to the latest databases, applications, and best practices. Step by step, Database Design for Mere Mortals ® , Third Edition, shows you how to design databases that are soundly structured, reliable, and flexible, even in modern web applications. Hernandez guides you through everything from database planning to defining tables, fields, keys, table relationships, business rules, and views. You’ll learn practical ways to improve data integrity, how to avoid common mistakes, and when to break the rules.

 

Coverage includes

Understanding database types, models, and design terminology

Discovering what good database design can do for you—and why bad design can make your life miserable

Setting objectives for your database, and transforming those objectives into real designs

Analyzing a current database so you can identify ways to improve it

Establishing table structures and relationships, assigning primary keys, setting field specifications, and setting up views

Ensuring the appropriate level of data integrity for each application

Identifying and establishing business rules

Whatever relational database systems you use, Hernandez will help you design databases that are robust and trustworthy. Never designed a database before? Settling for inadequate generic designs? Running existing databases that need improvement? Start here.

"Synopsis" by ,  

The #1 Easy, Commonsense Guide to Database Design!

 

Michael J. Hernandez’s best-selling Database Design for Mere Mortals® has earned worldwide respect as the clearest, simplest way to learn relational database design. Now, he’s made this hands-on, software-independent tutorial even easier, while ensuring that his design methodology is still relevant to the latest databases, applications, and best practices.

 

Step by step, Database Design for Mere Mortals®, Third Edition, shows you how to design databases that are soundly-structured, reliable and flexible, even in modern web applications. Hernandez guides you through everything from database planning to defining tables, fields, keys, table relationships, business rules, and views. You’ll learn practical ways to improve data integrity, how to avoid common mistakes, and when to break the rules.

 

Coverage includes

 

·      Learning about data types

·      Understanding database types, models, and design terminology

·      Discovering what good database design can do for you—and why bad design can make your life miserable

·      Setting objectives for your database, and transforming those objectives into real designs

·      Analyzing a current database so you can identify ways to improve it

·      Establishing table structures and relationships, assigning primary keys, setting field specifications, and setting up views

·      Ensuring the appropriate level of data integrity for each application

 

Whatever relational database systems you use, Hernandez will help you design databases that are robust and trustworthy. Never designed a database before? Settling for inadequate generic designs? Running existing databases that need improvement? Start here.

 

Instructors: New instructional resources available for this edition include Microsoft Word templates, Microsoft PowerPoint slide decks, and test questions.

 

spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.