PROC SQL, 3rd Edition

Chapter 1: Designing Database Tables

Introduction. 1

Database Design. 1

Conceptual View.. 2

Table Definitions. 2

Redundant Information. 3

Normalization. 3

Normalization Strategies. 4

Column Names and Reserved Words. 7

ANSI SQL Reserved Words. 7

SQL Code. 7

Data Integrity. 8

Referential Integrity. 8

Database Tables Used in This Book. 8

CUSTOMERS Table. 8

INVENTORY Table. 9

INVOICE Table. 9

MANUFACTURERS Table. 9

PRODUCTS Table. 10

PURCHASES Table. 10

Table Contents. 11

The Database Structure. 13

Sample Database Tables. 14

Summary. 20

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 ...