Sale!

(Ebook PDF) Relational Database Design Clearly Explained 2nd edition by Jan harington 0080516068 9780080516066 Full chapter

Original price was: $50.00.Current price is: $35.00.

Relational Database Design Clearly Explained 2nd edition Edition Jan Lharington Digital Instant Download

Author(s): Jan LHarington
ISBN(s): 9781558608207, 1558608206
Edition: 2nd edition
File Details: PDF, 18.57 MB
Year: 2002
Language: english
SKU: EB-976982 Category: Tag:

Relational Database Design Clearly Explained 2nd edition by Jan L harington – Ebook PDF Instant Download/Delivery: 0080516068, 978-0080516066
Full dowload Relational Database Design Clearly Explained 2nd Edition after payment

 

Product details:

ISBN 10:         0080516068
ISBN 13: 978-0080516066
Author:          Jan L harington

Fully revised and updated, Relational Database Design, Second Edition is the most lucid and effective introduction to relational database design available. Here, you’ll find the conceptual and practical information you need to develop a design that ensures data accuracy and user satisfaction while optimizing performance, regardless of your experience level or choice of DBMS.Supporting 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. These real-world examples include object-relational design techniques, which are addressed in greater detail in a new chapter devoted entirely to this timely subject.* Concepts you need to master to put the book’s practical instruction to work.* Methods for tailoring your 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.
 

Relational Database Design Clearly Explained 2nd Table of contents:

Part One: Theory

  • Chapter 1: Introduction

    • Effects of Poor Database Design
    • What You Will Find in This Book

  • Chapter 2: Entities and Data Relationships

    • Entities and Their Attributes
    • Domains
    • Basic Data Relationships
    • Dealing with Many-to-Many Relationships
    • Relationships and Business Rules
    • Data Modeling versus Data Flow
    • Schemas
    • For Further Reading

  • Chapter 3: Historical Antecedents

    • File Processing Systems
    • The Hierarchical Data Model
    • The Simple Network Data Model
    • The Complex Network Data Model

  • Chapter 4: The Relational Data Model

    • Understanding Relations
    • Primary Keys
    • Representing Data Relationships
    • Views
    • The Data Dictionary
    • A Bit of History
    • For Further Reading

  • Chapter 5: Normalization

    • Translating an ER Diagram into Relations
    • Normal Forms
      • First Normal Form
      • Second Normal Form
      • Third Normal Form
      • Boyce–Codd Normal Form
      • Fourth Normal Form
    • Normalized Relations and Database Performance
    • For Further Reading

  • Chapter 6: Database Structure and Performance Tuning

    • Indexing
    • Clustering
    • Partitioning
    • For Further Reference

  • Chapter 7: Codd’s Rules

    • Rule 1: The Information Rule
    • Rule 2: The Guaranteed Access Rule
    • Rule 3: Systematic Treatment of Null Values
    • Rule 4: Dynamic Online Catalog Based on the Relational Model
    • Rule 5: The Comprehensive Data Sublanguage Rule
    • Rule 6: The View Updating Rule
    • Rule 7: High-Level Insert, Update, and Delete
    • Rule 8: Physical Data Independence
    • Rule 9: Logical Data Independence
    • Rule 10: Integrity Independence
    • Rule 11: Distribution Independence
    • Rule 12: Nonsubversion Rule

  • Chapter 8: Integrating Objects

    • An Introduction to Object-Oriented Concepts
    • Integrating Objects into a Relational Database
    • ER Diagrams for Object-Relational Designs
    • For Further Reading

Part Two: Practice

  • Chapter 9: Using SQL to Implement a Relational Design

    • Database Object Hierarchy
    • Schemas
    • Domains
    • Tables
    • Views
    • Temporary Tables
    • Creating Indexes
    • Modifying Database Elements
    • Deleting Database Elements
    • Granting and Revoking Access Rights
    • Object-Relational Extensions

  • Chapter 10: Using CASE Tools for Database Design

    • CASE Capabilities
    • ER Diagram Reports
    • Data Flow Diagrams
    • The Data Dictionary
    • Code Generation
    • Sample Input and Output Designs
    • The Drawing Environment
    • For Further Reading

  • Chapter 11: Database Design Case Study #1: Mighty-Mite Motors

    • Corporate Overview
    • Designing the Database
    • The Object-Relational Design

  • Chapter 12: Database Design Case Study #2: East Coast Aquarium

    • Organizational Overview
    • The Volunteers Database
    • The Animal Tracking Database
    • The Object-Relational Design

  • Chapter 13: Database Design Case Study #3: Independent Intelligence Agency

    • Organizational Overview
    • Designing the Database
    • The Object-Relational Design

People also search for Relational Database Design Clearly Explained 2nd:

relational database design and implementation clearly explained
what is relational database design
a relational database consists of one or more what
design relational database
unary relationship database

Tags:

Jan harington,Relational,Database,Design,Clearly Explained 2nd