Overview

Fully revised, updated, and expanded, Relational Database Design and Implementation, Third Edition is the most lucid and effective introduction to the subject available for IT/IS professionals interested in honing their skills in database design, implementation, and administration. This book provides the conceptual and practical information necessary to develop a design and management scheme that ensures data accuracy and user satisfaction while optimizing performance, regardless of experience level or choice of DBMS. The book begins by reviewing basic concepts of databases and database design, then briefly reviews the SQL one would use to create databases. Topics such as the relational data model, normalization, data entities and Codd's Rules (and why they are important) are covered clearly and concisely but without resorting to Dummies -style talking down to the reader. Supporting the book's step-by-step instruction are three NEW case studies illustrating database planning, analysis, design, and management practices. In addition to these real-world examples, which include object-relational design techniques, an entirely NEW section consisting of three chapters is devoted to database implementation and management issues.

Full Product Details

Author:   Jan L. Harrington (Professor and Department Chair, Computer Science, Marist College, Hyde Park, NY, USA)
Publisher:   Elsevier Science & Technology
Imprint:   Morgan Kaufmann Publishers In
Edition:   3rd edition
Dimensions:   Width: 19.10cm , Height: 2.70cm , Length: 23.50cm
Weight:   0.890kg
ISBN:  

9780123747303

ISBN 10:   0123747309
Pages:   440
Publication Date:   02 September 2009
Audience:   Professional and scholarly ,  Professional & Vocational
Replaced By:   9780128043998
Format:   Paperback
Publisher's Status:   Out of Print
Availability:   In Print  
Limited stock is available. It will be ordered for you and shipped pending supplier's limited stock.

Table of Contents

Part One: Introduction Chapter 1: The Database Environment Chapter 2: Systems Analysis and Database Requirements Part Two: Database Design Theory Chapter 3: Why Good Design Matters Chapter 4: Entities and Relationships Chapter 5: The Relational Data Model Chapter 6: Normalization Chapter 7: Database Structure and Performance Tuning Chapter 8: Codd's Rules for Relational Database Design Part Three: Relational Design Practice Chapter 9: Using SQL to Implement a Relational Design Chapter 10: Using CASE Tools for Database Design Chapter 11: Database Design Case Study #1:Database Design Case Study #1: Mighty-Mite Motors Chapter 12: Database Design Case Study #2: East Coast Aquarium Chapter 13: Database Design Case Study #3: SmartMart Part Four: Database Implementation Issues Chapter 14: Concurrency Control Chapter 15: Database Security Chapter 16: Data Warehousing Chapter 17: Data Quality Chapter 18: XML Appendix A: Historical Antecedents

Reviews

I think this book addresses database designers and database professionals quite well. The book also is well-suited to be used for an introductory course on database management. -- Craig Mullins, Corporate Technologist, NEON Enterprise Software

Author Information

Jan L. Harrington, the author of 30 books, including SQL, Clearly Explained (Academic Press), has been writing about databases since 1984. She is a professor and chair of the department of computer science and information systems at Marist College, where she teaches database design and management, object-oriented programming, data communications, and computer architecture.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions