Database Design

Topics: Database, Relational model, SQL Pages: 872 (149940 words) Published: October 5, 2013
Database Design
Ryan K. Stephens
Ronald R. Plew

800 East 96th St., Indianapolis, Indiana, 46240 USA

Database Design

ASSOCIATE PUBLISHER

Copyright  2001 by Sams Publishing

EXECUTIVE EDITOR

Bradley L. Jones

All rights reserved. No part of this book shall be reproduced, stored in a retrieval system, or transmitted by any means, electronic, mechanical, photocopying, recording, or otherwise, without written permission from the publisher. No patent liability is assumed with respect to the use of the information contained herein. Although every precaution has been taken in the preparation of this book, the publisher and author assume no responsibility for errors or omissions. Nor is any liability assumed for damages resulting from the use of the information contained herein.

DEVELOPMENT EDITOR
Songlin Qiu

MANAGING EDITOR

Carol Bowers

Printed in the United States of America

COPY EDITORS

First Printing: November 2000
01

Geoff Mukhtar

PROJECT EDITOR

Library of Congress Catalog Card Number: 99-63863

02

ACQUISITIONS EDITOR

Charlotte Clapp

International Standard Book Number: 0-672-31758-3

03

Rosemarie Graham

00

4

3

2

1

Trademarks
All terms mentioned in this book that are known to be trademarks or service marks have been appropriately capitalized. Sams cannot attest to the accuracy of this information. Use of a term in this book should not be regarded as affecting the validity of any trademark or service mark.

Rhonda Tinch-Mize
Bart Reed
Mary Ellen Stephenson

INDEXER
Bill Meyers

PROOFREADER
Katherin Bidwell

TECHNICAL EDITORS

Warning and Disclaimer
Every effort has been made to make this book as complete and as accurate as possible, but no warranty or fitness is implied. The information provided is on an “as is” basis. The author and the publisher shall have neither liability nor responsibility to any person or entity with respect to any loss or damages arising from the information contained in this book.

James Drover
Beth Boal
Kai Soder

TECHNICAL REVIEWERS
Baya Pavliashvili
Rafe Colburn

MEDIA DEVELOPER
J.G. Moore

INTERIOR DESIGNER
Anne Jones

COVER DESIGNER
Anne Jones

PRODUCTION
Gloria Schurick

Overview
Introduction 1
PART I

Overview of Database Design

1

Understanding Database Fundamentals 9

2

Exploration of Database Models 37

3

Database Design Planning 57

4

The Database Design Life Cycle 79

PART II

Analyzing and Modeling Business Requirements

5

Gathering Business and System Requirements 113

6

Establishing a Business Model 149

7

Understanding Entities and Relationships 161

8

Normalization: Eliminating Redundant Data 185

9

Entity Relationship Modeling 209

10

Modeling Business Processes 235

PART III

Designing the Database

11

Designing Tables 259

12

Integrating Business Rules and Data Integrity 295

13

Designing Views 319

14

Applying Database Design Concepts 345

PART IV

Life After Design

15

Implementing Database Security 383

16

Change Control 407

17

Analyzing Legacy Databases for Redesign 427
Appendixes

A

Sample Physical Database Implementation 447

B

Popular Database Design Tools 463

C

Database Design Checklists 465

D

Sample Database Designs 475

E

Sample Table Sizing Worksheet 487
Glossary 491
Index 497

Contents
Introduction 1
Who Should Read This Book? ..............................................................1 What Makes This Book Different? ........................................................2 Table Conventions Used in This Book ..................................................4 How This Book Is Organized ................................................................5 What’s on the Web Site? ........................................................................6

PART I
1

Overview of Database Design

7

Understanding...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Essay on Comparative analysis of database design
  • Database Design Process Essay
  • The Difference Between Logical and Physical Network Design Essay
  • Why Good Database Design Is Important in Performing Data Operation? Essay
  • Database Design Essay
  • Database Design: Notes Essay
  • Database Research Paper
  • Determining Databases Essay

Become a StudyMode Member

Sign Up - It's Free