Database Design Using Entity-Relationship Diagrams

Introduction

• THE ER MODELS WE CHOSE
• COURSE HIGHLIGHTS
• BIBLIOGRAPHY

Data, Databases, and the Software Engineering Process

• INTRODUCTION
• DATA
• BUILDING A DATABASE
• WHAT IS THE SOFTWARE ENGINEERING PROCESS?
• ENTITY-RELATIONSHIP DIAGRAMS AND THE SOFTWARE ENGINEERING LIFE CYCLE
• LESSON SUMMARY
• EXERCISES
• BIBLIOGRAPHY

Data and Data Models

• INTRODUCTION
• FILES, RECORDS, AND DATA ITEMS
• MOVING FROM 3 × 5 CARDS TO COMPUTERS
• DATABASE MODELS
• THE NETWORK MODEL
• THE RELATIONAL MODEL
• LESSON SUMMARY
• BIBLIOGRAPHY

The Relational Model and Functional Dependencies

• INTRODUCTION
• FUNDAMENTALS OF RELATIONAL DATABASE
• RELATIONAL DATABASE AND SETS
• FUNCTIONAL DEPENDENCY
• NON-1NF TO 1NF
• THE SECOND NORMAL FORM
• THE THIRD NORMAL FORM
• THE EQUIJOIN OPERATION
• SOME FUNCTIONAL DEPENDENCY RULES
• THE BOYCE–CODD NORMAL FORM
• LESSON SUMMARY
• EXERCISES
• BIBLIOGRAPHY

The Basic ER Diagram: A Data Modeling Schema

• INTRODUCTION
• WHAT IS A DATA MODELING SCHEMA?
• DEFINING A DATABASE—SOME DEFINITIONS: ENTITY, RELATIONSHIP, AND ATTRIBUTE
• A FIRST “ENTITY-ONLY” ER DIAGRAM: AN ENTITY WITH ATTRIBUTES
• MORE ABOUT ATTRIBUTES
• ENGLISH DESCRIPTION OF THE ENTITY
• MAPPING THE ENTITY DIAGRAM TO A RELATIONAL DATABASE
• LESSON SUMMARY
• EXERCISES
• CASE STUDY
• BIBLIOGRAPHY

Beyond the First Entity Diagram

• INTRODUCTION
• EXAMINING AN ENTITY: CHANGING AN ATTRIBUTE TO BE AN ENTITY
• DEFINING A RELATIONSHIP FOR OUR NEW ENTITY
• A PRELIMINARY GRAMMAR FOR ER DIAGRAMS
• DEFINING A SECOND ENTITY
• DOES A RELATIONSHIP EXIST?
• ATTRIBUTE OR RELATIONSHIP?
• LESSON SUMMARY
• EXERCISES
• CASE STUDY
• BIBLIOGRAPHY

Extending Relationships/Structural Constraints

• INTRODUCTION
• THE CARDINALITY RATIO OF A RELATIONSHIP
• PARTICIPATION: FULL/PARTIAL
• ENGLISH DESCRIPTIONS
• TIGHTER ENGLISH
• SOME EXAMPLES OF OTHER RELATIONSHIPS
• ONE FINAL EXAMPLE
• MAPPING RELATIONSHIPS TO A RELATIONAL DATABASE
• LESSON SUMMARY
• EXERCISES
• CASE STUDY
• BIBLIOGRAPHY

The Weak Entity

• INTRODUCTION
• STRONG AND WEAK ENTITIES
• WEAK ENTITIES AND STRUCTURAL CONSTRAINTS
• WEAK ENTITIES AND THE IDENTIFYING OWNER
• WEAK ENTITIES CONNECTED TO OTHER WEAK ENTITIES
• REVISITING THE METHODOLOGY
• WEAK ENTITY GRAMMAR
• MAPPING WEAK ENTITIES TO A RELATIONAL DATABASE
• LESSON SUMMARY
• EXERCISES
• CASE STUDY
• BIBLIOGRAPHY

Further Extensions for ER Diagrams with Binary Relationships

• INTRODUCTION
• ATTRIBUTES OF RELATIONSHIPS
• RELATIONSHIPS DEVELOPING INTO ENTITIES: THE M:N RELATIONSHIP REVISITED
• MORE ENTITIES AND RELATIONSHIPS
• MORE EVOLUTION OF THE DATABASE
• ATTRIBUTES THAT EVOLVE INTO ENTITIES
• RECURSIVE RELATIONSHIPS
• MULTIPLE RELATIONSHIPS
• THE DERIVED OR REDUNDANT RELATIONSHIP
• OPTIONAL: AN ALTERNATIVE ER NOTATION FOR SPECIFYING STRUCTURAL CONSTRAINTS ON RELATIONSHIPS
• REVIEW OF THE METHODOLOGY
• MAPPING RULES FOR RECURSIVE RELATIONSHIPS
• LESSON SUMMARY
• EXERCISES
• CASE STUDY
• BIBLIOGRAPHY

Ternary and Higher-Order ER Diagrams

• INTRODUCTION
• BINARY OR TERNARY RELATIONSHIP?
• STRUCTURAL CONSTRAINTS FOR TERNARY RELATIONSHIPS
• AN EXAMPLE OF AN N-ARY RELATIONSHIP
• N-ARY RELATIONSHIPS DO NOT PRECLUDE BINARY RELATIONSHIPS
• METHODOLOGY AND GRAMMAR FOR THE N-ARY 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
• LESSON 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
• SUBCLASSES OF SUBCLASSES
• CATEGORIES OR UNION TYPES
• FINAL ER DESIGN METHODOLOGY
• LESSON SUMMARY
• EXERCISES
• CASE STUDY
• BIBLIOGRAPHY

Relational Mapping and Reverse Engineering ER/EER Diagrams

• INTRODUCTION
• STEPS USED TO MAP ER/EER DIAGRAMS TO RELATIONAL DATABASES
• REVERSE ENGINEERING
• LESSON 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
• 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
• RECURSIVE RELATIONSHIPS IN THE BARKER/ORACLE-LIKE MODEL
• MAPPING M:N RELATIONSHIPS
• LESSON SUMMARY
• EXERCISES
• BIBLIOGRAPHY

Glossary