Database Design Using Entity-Relationship Diagrams

This book contains information obtained from authentic and highly regardedsources. Reprinted material is quoted with permission, and sources areindicated. A wide variety of references are listed. Reasonable efforts havebeen made to publish reliable data and information, but the author and thepublisher cannot assume responsibility for the validity of all materials or forthe consequences of their use.
Nội dung trích xuất từ tài liệu:
Database Design Using Entity-Relationship Diagrams Database Design Using Entity-Relationship Diagrams by Sikha Bagui and Richard Earp ISBN:0849315484 Auerbach Publications © 2003 (242 pages) With this comprehensive guide, database designers and developers can quickly learn all the ins and outs of E-R diagramming to become expert database designers. Table of Contents Back Cover CommentsTable of ContentsDatabase Design Using Entity-Relationship DiagramsPrefaceIntroductionChapter 1 - The Software Engineering Process and Relational DatabasesChapter 2 - The Basic ER Diagram—A Data Modeling SchemaChapter 3 - Beyond the First Entity DiagramChapter 4 - Extending Relationships/Structural ConstraintsChapter 5 - The Weak EntityChapter 6 - Further Extensions for ER Diagrams with Binary RelationshipsChapter 7 - Ternary and Higher-Order ER DiagramsChapter 8 - Generalizations and SpecializationsChapter 9 - Relational Mapping and Reverse-Engineering ER DiagramsChapter 10 - A Brief Overview of the Barker/Oracle-Like ModelGlossaryIndexList of FiguresList of ExamplesDatabase Design Using Entity-Relationship DiagramsSikha BaguiRichard EarpAUERBACH PUBLICATIONSA CRC Press CompanyLibrary of Congress Cataloging-in-Publication DataBagui, Sikha, 1964-Database design using entity-relationship diagrams / Sikha Bagui, RichardEarp.p. cm. – (Foundation of database design ; 1)Includes bibliographical references and index.0849315484(alk. paper)1. Database design. 2. Relational databases. I. Earp, Richard, 1940-II. Title.III. Series.QA76.9.D26B35 2003005.74–dc21 2003041804This book contains information obtained from authentic and highly regardedsources. Reprinted material is quoted with permission, and sources areindicated. A wide variety of references are listed. Reasonable efforts havebeen made to publish reliable data and information, but the author and thepublisher cannot assume responsibility for the validity of all materials or forthe consequences of their use.Neither this book nor any part may be reproduced or transmitted in any formor by any means, electronic or mechanical, including photocopying,microfilming, and recording, or by any information storage or retrievalsystem, without prior permission in writing from the publisher.The consent of CRC Press LLC does not extend to copying for generaldistribution, for promotion, for creating new works, or for resale. Specificpermission must be obtained in writing from CRC Press LLC for suchcopying.Direct all inquiries to CRC Press LLC, 2000 N.W. Corporate Blvd., BocaRaton, Florida 33431.Trademark Notice: Product or corporate names may be trademarks orregistered trademarks, and are used only for identification and explanation,without intent to infringe.Visit the Auerbach Web site at http://www.auerbach-publications.comCopyright © 2003 CRC Press LLCAuerbach is an imprint of CRC Press LLCNo claim to original U.S. Government worksInternational Standard Book Number 0-8493-1548-4Library of Congress Card Number 20030418041234567890DedicationDedicated to my father, Santosh Saha, and mother, Ranu Sahaandmy husband, Subhash Baguiandmy sons, Sumon and SudipandPradeep and Priyashi SahaS.B.To my wife, Brenda,andmy children: Beryl, Rich, Gen, and Mary JoR.E.PrefaceData modeling and database design have undergone significant evolution inrecent years. Today, the relational data model and the relational databasesystem dominate business applications. The relational model has allowedthe database designer to focus on the logical and physical characteristics ofa database separately. This book concentrates on techniques for databasedesign, with a very strong bias for relational database systems, using the ER(Entity Relationships) approach for conceptual modeling (solely a logicalimplementation).Intended AudienceThis book is intended to be used by database practitioners and students fordata modeling. It is also intended to be used as a supplemental text indatabase courses, systems analysis and design courses, and other coursesthat design and implement databases. Many present-day database andsystems analysis and design books limit their coverage of data modeling.This book not only increases the exposure to data modeling concepts, butalso presents a detailed, step-by-step approach to designing an ER diagramand developing the relational database from it.Book HighlightsThis book focuses on presenting: (1) an ER design methodology fordeveloping an ER diagram; (2) a grammar for the ER diagrams that can bepresented back to the user; and (3) mapping rules to map the ER diagramto a relational database. The steps for the ER design methodology, thegrammar for the ER diagrams, as well as the mapping rules are developedand presented in a systematic, step-by-step manner throughout the book.Also, several examples of sample data have been included with relationaldatabase mappings — all to give a realistic feeling.This book is divided into ten chapters. The first chapter gives the readersome background by introducing some relational database concepts such asfunctional dependencies and database normalization. The ER designmethod-ology and mapping rules are presented, starting in Chapter 2.Chapter 2 introduces the concepts of the entity, attributes, relationships, andthe one-entity ER diagram. Steps 1, 2, and 3 of the ER DesignMethodology are developed. The one-entity grammar and mapping rulesfor the one-entity diagram are presented.Chapter 3 extends the one-entity diagram to include a second entity. Theconcept of testing attributes for entities is discussed and relationshipsbetween the entities are developed. Steps 3a, 3b, 4, 5, and 6 of the ERdesign methodology are developed, ...