Data Management: Databases and Organizations, Fifth Edition > Data Modeling and SQL > One-to-One and Recursive Relationships

Table of Contents

Download Safari Books Online apps: Apple iOS | Android

Entire Site

Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

This Book

Data Management: Databases and Organizations, Fifth Edition

Search

Dedication

Preface

Section: 1 The Managerial Perspective

Section: 2 Data Modeling and SQL

Ch. 3. The Single Entity

Ch. 4. The One-to-Many Relationship

Ch. 5. The Many-to-Many Relationship

Ch. 6. One-to-One and Recursive Relationships

Modeling a one-to-one relationship

Mapping a one-to-one relationship

Mapping a one-to-many recursive relationship

Querying a one-to-one relationship

Querying a recursive relationship

Modeling a one-to-one recursive relationship

Mapping a one-to-one recursive relationship

Querying a one-to-one recursive relationship

Modeling a many-to-many recursive relationship

Mapping a many-to-many recursive relationship

Querying a many-to-many recursive relationship

Ch. 7. Data Modeling

Reference 1: Basic Structures

Ch. 8. Normalization and Other Data Modeling Methods

Ch. 9. The Relational Model and Relational Algebra

Ch. 10. SQL

Reference 2: SQL Playbook

Section: 3 Database Architectures and Implementations

Section: 4 Organizational Memory Technologies

Section: 5 Managing Organizational Memory

Index

Chapter 6. One-to-One and Recursive Relationships

Self-reflection is the school of wisdom.

Baltasar Gracián, The Art of Worldly Wisdom, 1647

You are currently reading a PREVIEW of this book.

Get instant access to over
$1 million worth of books and videos.

Start a Free Trial

Download Safari Books Online apps: Apple iOS | Android

This Book

Search

Contents

Section: 2 Data Modeling and SQL > One-to-One and Recursive Relationships

Chapter 6. One-to-One and Recursive Relationships