Introduction

Basics of Database Design and Implementation

Planning a Database

Building a Relational Data Model

In This Chapter

Building a Data Model

Overview of the Entity-Relationship Data Model

Identifying and Defining Principal Data Objects

Diagramming Data Objects

Translating E-R Data Objects into Relational Constructs

Resolving Relationships

Normalizing a Data Model

First Normal Form

Second Normal Form

Third Normal Form

Summary of Normalization Rules

Choosing Data Types

Implementing a Relational Data Model

Managing Databases

Table Fragmentation Strategies

Granting and Limiting Access to Your Database

Using Distributed Queries

Object-Relational Databases

Creating and Using Extended Data Types in Dynamic Server

Understanding Type and Table Inheritance in Dynamic Server

Creating and Using User-Defined Casts in Dynamic Server

Dimensional Databases

Building a Dimensional Data Model

Implementing a Dimensional Database (XPS)

Appendixes

Appendix. Accessibility

Notices

Index