O'Reilly logo

PROC SQL: Beyond the Basics Using SAS, Second Edition by Kirk Paul Lafler

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required