Preface | |
Introduction | |
THE SOFTWARE ENGINEERING PROCESS AND RELATIONAL DATABASES | |
What is the software engineering process? | |
ER Diagrams and the Software Engineering Life Cycle | |
Data Models | |
Functional Dependencies | |
A Brief Look at Normal Forms | |
Summary of Chapter |
|
Exercises for Chapter 1 |
|
References | |
THE BASIC ER DIAGRAM ? A DATA MODELING SCHEMA | |
What is a data modeling schema? | |
Defining the database ? some definitions: entity, relationship, attribute | |
A Beginning Methodology | |
ER Design Methodology | |
A First "Entity only" ER Diagram | |
More about Attributes | |
English Description of the Entity | |
Mapping the Entity Diagram to a Relational Database | |
Summary of Chapter |
|
Exercises for Chapter 2 |
|
References | |
Case Study | |
BEYOND THE FIRST ENTITY DIAGRAM | |
Examining an Entity - Changing An Attribute to be an entity | |
Defining a relationship for our new entity | |
A Preliminary Grammar for the ER diagrams | |
Defining a Second Entity | |
Does a Relationship Exist? | |
Attribute or relationship? | |
Summary of Chapter |
|
Exercises for Chapter 3 |
|
References | |
Case Study | |
EXTENDING RELATIONSHIPS/STRUCTURAL CONSTRAINTS | |
The Cardinality Ratio of a Relationship | |
Participation - Full/Partial | |
English Descriptions | |
Tighter English | |
Some examples of other relationships | |
One Final Example | |
Exercises for Chapter 4 |
|
References | |
Case Study | |
THE WEAK ENTITY | |
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 | |
Summary of Chapter |
|
Exercises for Chapter 5 |
|
Reference | |
Case Study | |
Further Extensions for ER Diagrams with Binary Relationships | |
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 Relations | |
The Derived or Redundant Relation | |
An alternative ER Notation for specifying Structural Constraints on Relationships | |
Review of the Methodology | |
Mapping rules for Recursive Relationships | |
Summary of Chapter |
|
Exercises for Chapter 6 |
|
References | |
Case Study | |
TERNARY AND HIGHER ORDER ER DIAGRAMS | |
Binary or Ternary Relationship? | |
Ternary Relationships and Structural Constraints | |
n-ary Relations do not preclude binary relations | |
Methodology and Grammar for the n-ary Relationship | |
Ternary Relationships from relationship-relationship situations | |
n-ary Relationships May be Resolved into Binary Relationships | |
Mapping to ternary diagrams to a relational database | |
Summary of Chapter |
|
Exercises for Chapter 7 |
|
References | |
GENERALIZATIONS AND SPECIALIZATIONS | |
What is a Generalization or Specialization? | |
A Problem with Variants | |
Example of a Generalization/Specialization | |
Methodology and Grammar in Generalization/Specialization relationships | |
Mapping rules for EER Diagrams | |
Summary of Chapter |
|
Exercises for Chapter 8 |
|
References | |
Case Study | |
RELATIONAL MAPPING AND REVERSE ENGINEERING ER DIAGRAMS | |
Steps used to map an ER diagram to a Relational Database | |
Reverse Engineering | |
Summary of Chapter |
|
References | |
A BRIEF OVERVIEW OF THE BARKER/ORACLE-LIKE MODEL | |
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 | |
Treatment of Foreign keys | |
Recursive relationships in the Barker/Oracle-like model | |
Mapping M:N relations | |
Summary of Chapter |
|
Exercises for Chapter 10 |
|
References | |
Glossary | |
Index |