Entity Relationship Diagram (ERD) Training Video

This is an excellent demonstration of entity relationship diagrams. I strongly encourage all of you to pay close attention to this video as there will be several questions about ERD on the midterm exam.

A couple things to note: in class we started working with entity relationship modeling (using rectangles for entities, diamonds for relationships, and ellipses for attributes). This is the technique used to conceptually model entity relationships, which then leads to the formal diagrams you see in this video. There are various diagramming methods. This video shows Crow’s Foot notation. For more information about entity relationship modeling and entity relationship diagrams, read the Wikipedia article on the subject.