Database Design for Mere Mortals

A Hands-On Guide to Relational Database Design

Michael J. Hernandez

612 pages, parution le 19/03/2003

Ajouter à une liste

Indisponible

Résumé

Sound database design can save hours of development time and ensure functionality and reliability. Database Design for Mere Mortals™, Second Edition, is a straightforward, platform-independent tutorial on the basic principles of relational database design. It provides a commonsense design methodology for developing databases that work.

Database design expert Michael J. Hernandez has expanded his best-selling first edition, maintaining its hands-on approach and accessibility while updating its coverage and including even more examples and illustrations.

This edition features a CD-ROM that includes diagrams of sample databases, as well as design guidelines, documentation forms, and examples of the database design process.

This book will give you the knowledge and tools you need to create efficient and effective relational databases.

Contents

I. RELATIONAL DATABASE DESIGN.
1. What Is a Relational Database.
2. Design Objectives.
3. Terminology.
II. THE DESIGN PROCESS.
4. Conceptual Overview.
5. Starting the Process.
6. Analyzing the Current Database.
7. Establishing Table Structures.
8. Keys.
9. Field Specifications.
10. Table Relationships.
12. Views.
13. Reviewing Data Integrity.
III. OTHER DATABASE DESIGN ISSUES.
14. Bad Design—What Not To Do.
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: Recommended Reading.
Glossary.

L'auteur - Michael J. Hernandez

Michael J. Hernandez is a well-known relational database consultant, and is the owner of DataTex Consulting Group in Seattle. He has been a featured speaker at a variety of database conferences and is the author of Database Design for Mere Mortals.

Caractéristiques techniques

	PAPIER
Éditeur(s)	Addison Wesley
Auteur(s)	Michael J. Hernandez
Parution	19/03/2003
Nb. de pages	612
Format	18,5 x 23
Couverture	Broché
Poids	1025g
Intérieur	Noir et Blanc
EAN13	9780201752847
ISBN13	978-0-2017-5284-7