At this point in the course, you know enough to translate much of what you have learned into an entity-relationship (ER) diagram
In this module, you will
- identify the conventions for diagramming entities and their attributes;
- identify the constructs used to diagram the three types of relationships (1:1, 1:N, and M:N), and
- identify the symbols used to indicate mandatory and optional participation in a relationship.
(Note: I use the term constructs
in its generic sense, referring to a collection of images or diagramming conventions.) Finally, you will complete the course project: creating an ER diagram for Stories on CD, Inc. After completing this module, you will be able to:
- Define the function of an entity-relationship (ER) diagram
- Describe the types of entity-relationship (ER) diagrams
- Identify conventions for diagramming entities and attributes
- Identify the constructs for diagramming types of relationships
- Identify the symbols for diagramming types of participation
- Revise an ER diagram based on a final review with users
- Describe how to verbalize an ER diagram
The next lesson defines the function of an ER diagram. entity-relationship (ER) diagram:
A diagram used during the design phase of database development to illustrate the organization of and relationships between data during database design.