PROC SQL: Beyond the Basics Using SAS, Second Edition

Chapter 1: Designing Database Tables

Introduction

Database Design

Conceptual View

Table Definitions

Redundant Information

Normalization

Normalization Strategies

Column Names and Reserved Words

ANSI SQL Reserved Words

SQL Code

Data Integrity

Referential Integrity

Database Tables Used in This Book

CUSTOMERS Table

INVENTORY Table

INVOICE Table

MANUFACTURERS Table

PRODUCTS Table

PURCHASES Table

Table Contents

The Database Structure

Sample Database Tables

Summary

 

Introduction

The area of database design is very important in relational processes. Much has been written on this subject, including entire textbooks and thousands of technical papers. No pretenses are made about the thoroughness of this very important subject in these pages. Rather, an ...