Relational Database Design and Implementation: Clearly Explained
- ISBN-10
- 0080885012
- ISBN-13
- 9780080885018
- Category
- Computers
- Pages
- 440
- Language
- English
- Published
- 2009-09-02
- Publisher
- Morgan Kaufmann
- Author
- Jan L. Harrington
Description
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. * Principles needed to understand the basis of good relational database design and implementation practices. * Examples to illustrate core concepts for enhanced comprehension and to put the book's practical instruction to work. * Methods for tailoring DB design to the environment in which the database will run and the uses to which it will be put. * Design approaches that ensure data accuracy and consistency. * Examples of how design can inhibit or boost database application performance. * Object-relational design techniques, benefits, and examples. * Instructions on how to choose and use a normalization technique. * Guidelines for understanding and applying Codd's rules. * Tools to implement a relational design using SQL. * Techniques for using CASE tools for database design.
Get the book
Other editions
-
- 2016-05-06
- 712 pages
- Paperback
- Morgan Kaufmann
Similar books
-
Pro SQL Server Relational Database Design and Implementation
By Jessica Moss, Louis DavidsonThis book is revised to cover in-memory online transaction processing, temporal data storage, row-level security, durability enhancements, and other design-related features that are new or changed in SQL Server 2016.
-
Relational Database Design Clearly Explained
By Jan L. HarringtonSupporting the book's step-by-step instruction are three case studies illustrating the planning, analysis, and design steps involved in arriving at a sound design.
-
Pro SQL Server Relational Database Design and Implementation
By Jessica Moss, Louis DavidsonThis book is revised to cover in-memory online transaction processing, temporal data storage, row-level security, durability enhancements, and other design-related features that are new or changed in SQL Server 2016.
-
Database Design and Implementation: Second Edition
By Edward ScioreTopics include indexing, sorting, intelligent buffer usage, and query optimization. This text is intended for upper-level undergraduate or beginning graduate courses in Computer Science.
-
Pro SQL Server Relational Database Design and Implementation: Best Practices for Scalability and Performance
By Louis DavidsonThis book is revised to cover additions to SQL Server that include SQL graph enhancements, in-memory online transaction processing, temporal data storage, row-level security, and other design-related features.
-
Six-Step Relational Database Design: A Step by Step Approach to Relational Database Design and Development
By Fidel A. CaptainThe technique described in this book can be used by students for quickly developing relational databases for their applications, and by professionals for developing sturdy, reliable, and accurate relational database models for their ...
-
Pro SQL Server Relational Database Design and Implementation: Best Practices for Scalability and Performance
By Louis DavidsonThis book is revised to cover additions to SQL Server that include SQL graph enhancements, in-memory online transaction processing, temporal data storage, row-level security, and other design-related features.
-
Pro SQL Server 2008 Relational Database Design and Implementation
By Scott Klein, Louis Davidson, Kevin KlinePro SQL Server 2008 Relational Database Design and Implementation covers everything from design logic that business users will understand, all the way to the physical implementation of the design in a SQL Server database.
-
Database Design for Mere Mortals: A Hands-on Guide to Relational Database Design
By Michael James Hernandez"This book takes the somewhat daunting process of database design and breaks it into completely manageable and understandable components.
-
Access Database Design & Programming
By Steven RomanFor programmers who prefer content to frills, this guide has succinct and straightforward information for putting Access to its full, individually tailored use.