文档介绍:Relational
Database Design
Clearly
xolained
Second Edition
This Page Intentionally Left Blank
Relational
DatabaseDes n
Clea
xplained
Second Edition
Jan L. Harrington
Morgan Kaufmann Publishers
An Imprint of Elsevier
Amsterdam London New York Oxford Paris Tokyo
Boston San Diego San Francisco Singapore Sydney
This book is printed on acid-free paper.
Copyright
9 2002, 1999, Elsevier.
All rights reserved.
No part of this publication may be reproduced or transmitted in any form or by any means, electronic
or mechanical, including photocopy, recording, or any information storage and retrieval system,
without permission in writing from the publisher.
Permissions may be sought directly from Elsevier's Science and Technology Rights Department in
Oxford, UK. Phone: (44) 1865 843830, Fax: (44) 1865 853333, e-mail: ******@.
You may plete your request on-line via the Elsevier homepage:
selecting "Customer Support" and then "Obtaining Permissions".
All brand names and product names mentioned in this book are trademarks or registered trademarks
of their panies.
Academic Press
An Imprint of Elsevier
525 B Street, Suite 1900, San Diego, California 92101-4495, USA
Academic Press
32 Jamestown Road, London NW1 7BY, UK
Morgan Kaufmann
An Imprint of Elsevier
340 Pine Street, Sixth Floor, San Francisco, California 94104-3205, USA
Library of Congress Catalog Card Number: 2002101250
ISBN-10:1-55860-820-6
ISBN-13:978-1-55860-820-7
Printed in the United States of America
05 06 07 MV 9 8 7 6 5 4
Contents
Preface to the Second Edition xiii
What You Need to Know xv
Acknowledgments xv
Part One: Theory
Chapter 1"Introduction 3
Effects of Poor Database Design 4
Unnecessary Duplicated Data and Data Consistency 6
Data Insertion Problems 7
Data Deletion Problems 8
Meaningful Identifiers 9
What You Will Find in This Book 9
vi CONTENTS
Chapter 2: Entit