(See related pages)
This chapter explains the notation of entity relationship diagrams as a prerequisite to using entity relationship diagrams in the database development process. After this chapter, the student should have acquired the following knowledge and skills:
|
|
|
Know the symbols and vocabulary of the Crow's Foot notation for entity relationship diagrams. |
|
|
|
Use the cardinality symbols to represent 1-1, 1-M, and M-N relationships. |
|
|
|
Compare the Crow's Foot notation to the representation of relational tables. |
|
|
|
Understand important relationship patterns. |
|
|
|
Use generalization hierarchies to represent similar entity types. |
|
|
|
Detect notational errors in an entity relationship diagram. |
|
|
|
Understand the representation of business rules in an entity relationship diagram. |
|
|
|
Appreciate the diversity of notation for entity relationship diagrams. |