Detailing the ins and outs of entity-relationship (E-R) diagramming, this comprehensive guide is an indispensable text for learning the basics of database development. This second edition features more examples throughout the text, more focused exercises, as well as more coverage of ternary and higher-order ERdiagrams, generalizations, and specializations. In addition, the authors provide a new in-depth chapter on reverse engineering along with a new, detailed look at functional dependencies and normal forms. INDICE: Data, Databases, and the Software Engineering Process IntroductionData Building a Database What is the Software Engineering Process? Entity Relationship Diagrams and the Software Engineering Life Cycle Phase 1: Get the Requirements for the Database Phase 2: Specify the Database Phase 3: Design the Database Chapter Summary Exercises Bibliography Data and Data Models Introduction Files, Records, and Data Items Moving from 3 A - 5 Cards to Computers Database Models The Hierarchical Model The Network Model The Relational Model Chapter Summary The Relational Model and Functional Dependencies Introduction Fundamental Relational Database Relational Database and Sets Functional DependencyNon-1NF to 1NF The Second Normal Form Anomalies Non-2NF to 2NF The Third Normal Form The Equijoin Operation Some Functional Dependency Rules The Boyce CoddNormal Form Chapter Summary Exercises Bibliography The Basic ER Diagram: A Data Modeling Schema Introduction What Is a Data Modeling Schema? So, What Is anEntity Relationship Diagram? Defining a Database-- Some Definitions: Entity, Relationship, Attribute A Beginning Methodology ER Design Methodology A First "Entity-Only" ER Diagram: An Entity with Attributes More about Attributes The Simple or Atomic Attribute The Composite Attribute The Multivalued Attribute The Derived Attribute Keys English Description of the Entity The Method ER Design Methodology Examples Mapping the Entity Diagram to a Relational Database Chapter Summary Exercises Bibliography Case Study Beyond the First Entity Diagram Introduction Examining an Entity: Changing an Attribute to Be an Entity Defining a Relationship for Our New Entity ER Design Methodology A Preliminary Grammar for the ER Diagrams The Relationship Defining a Second Entity Does a Relationship Exist? Attribute or Relationship? ER Design Methodology Chapter Summary Exercises Bibliography Case Study Extending Relationships/Structural Constraints Introduction The Cardinality Ratio of a Relationship One to One (1:1) Many to One (M:1) One to Many (1:M) Many to Many (M:N) Participation: Full/Partial English Descriptions Tighter English Pattern 1--x:y::k:1 Pattern 2--x:y::k:1 Pattern 3--x:y::k:M Pattern 4--x:y::k:M Summary of the Patterns and Relationships ER Design Methodology Some Examples of Other Relationships An Example ofthe One-to-Many Relationship An Example of the Many-to-One Relationship An Example of the Many-to-Many Relationship One Final Example ER Design MethodologyPattern 1--M:1, from the M Side, Full Participation Pattern 3--1:M, from the 1 Side, Full Participation Mapping Relationships to a Relational Database Mapping Binary M:N Relationships Mapping Binary 1:1 Relationships Mapping Binary 1:N Relationships Chapter Summary Exercises Bibliography Case Study The Weak Entity Introduction Strong and Weak Entities Weak Entities and Structural Constraints Weak Entities and the Identifying Owner Another Example of a Weak Entityand the Identifying Owner Weak Entities Connected to Other Weak Entities Revisiting the Methodology Weak Entity Grammar The Keys Mapping Weak Entities to aRelational Database Chapter Summary Exercises Bibliography Case Study FurtherExtensions for ER Diagrams with Binary Relationships Introduction Attributes of Relationships The Attributes Relationships Developing into Entities: The M:N Relationship Revisited The Entity More Entities and Relationships More than Two Entities More Evolution of the Database Attributes that Evolve into Entities Recursive Relationships Recursive Relationships and Structural Constraints Multiple Relationships The Derived or Redundant Relationship Optional: An Alternative ER Notation for Specifying Structural Constraints on Relationships Review of the Methodology ER Design Methodology The Entity The Attributes The Keys Mapping Rules for Recursive Relationships Chapter Summary Exercises Bibliography Case Study Ternary and Higher-Order ER Diagrams Introduction Binary or Ternary Relationship? Structural Constraints for Ternary Relationships Many to Many to Many (M:M:M) An Example of an n-ary Relationship n-ary Relationships DoNot Preclude Binary Relationships Methodology and Grammar for the n-ary Relationship A More Exact Grammar Grammar in a Partial Participation, Ternary Relationship with an M:1:M Relationship Ternary Relationships from Relationship-Relationship Situations n-ary Relationships that May Be Resolved into Binary Relationships Mapping n-ary Relationships to a Relational Database Review of the Methodology ER Design Methodology Chapter Summary Exercises Bibliography The Enhanced Entity Relationship (EER) Model Introduction What Is a Generalization or Specialization? Variants Examples of Generalizations or Specializations Methodology and Grammar for Generalization/Specialization Relationships Mapping Rules for Generalizations and Specializations Mapping Rule 15 Mapping Rule 16 Mapping Rule 17 Mapping Rule 18 Subclasses of Subclasses Mapping Rule 19 Categories or Union Types Participation Ratios in Categories or Union Types Mapping Categories or Union Types When Superclasses Have the Same Primary Keys Mapping Categories or Union Types When Superclasse Final ER Design Methodology ER Design Methodology Chapter Summary Exercises Bibliography Case Study Relational Mapping and Reverse Engineering ER/EER Diagrams Introduction Steps Used to Map ER/EER Diagrams to Relational Databases Reverse Engineering Reverse EngineeringRule 1. Develop Strong Entities Reverse Engineering Rule 2. Look for 1:1 and 1:N (1:x) Relationships Reverse Engineering Rule 2a. Check for Attributes of the 1:x Relationship Reverse Engineering Rule 3. Look for Weak Entities and Multivalued Attributes Reverse Engineering Rule 3a. Checking for Weak Entities Reverse Engineering Rule 3b. Checking for Multivalued Attributes Reverse Engineering Rule 4. Check for M:N and n-ary Relationships Reverse Engineering Rule 4a. Check for the Binary Case Reverse Engineering Rule 4b. Check for the n-ary Case Reverse Engineering Rule 5. Check for Generalization/Specialization Relationships Have Different Primary Keys Reverse Engineering Rule 5a. Check for Generalization/Specialization Relationships with Disjoint or Overlap Relationships with Total or Partial Participation Constraints Reverse Engineering Rule 5b.Check for Disjoint Generalization/ Specialization Relationships with Single-Predicate-Defined Attributes Reverse Engineering Rule 5c. Check for Overlap Generalization/Specialization Relationship with More than One Flag Reverse Engineering Rule 6. Check for Shared Subclasses Reverse Engineering Rule 7. Check for Categories or Union Types Chapter Summary Exercises Bibliography A Brief Overview of the Barker/Oracle-Like Model Introduction A First "Entity-Only" ER Diagram: An Entity with Attributes Attributes in the Barker/Oracle-Like Model Optional versus Mandatory Attributes Relationships in the Barker/Oracle-Like Model Structural Constraints in the Barker/Oracle-Like Model Dealing with the Concept of the Weak Entity in the Barker/Oracle-Like Model Dealing with the Concept of Multivalued Attributes in the Barker/Oracle-Like Model Treatment of Foreign Keys Recursive Relationships in the Barker/Oracle-Like Model Mapping M:N Relationships Chapter Summary Exercises Bibliography Glossary Index
- ISBN: 978-1-4398-6176-9
- Editorial: Auerbach
- Encuadernacion: Cartoné
- Páginas: 376
- Fecha Publicación: 08/09/2011
- Nº Volúmenes: 1
- Idioma: Inglés