ERD stands for Entity Relationship Diagram. What this diagram is used for is finding connection between data. ERD’s are visual representations of entities and how they are related. The three main things to know about ERD models, first is the entities which are nouns and are the data, people, buildings, orders, etc. Secondly, the attributes that are adjectives that describe or are involved in the entities. And lastly, the relationship or verbs that are used to connect the entities to one another, for example “created by”, “provides”, “contains”, etc. There are two notations for ERD models: Chen’s database notation or Crows Foot database notation. These ERD’s can be extremely useful in business to understand how things are connecting within the business and the most important entities that are in a database of a business. The goal of these diagrams are to show what logically is happening in the database.
Reader Interactions
Comments
Leave a Reply
You must be logged in to post a comment.
I like how you reiterated what each symbol means and gave examples. It definitely helped to be reminded of what everything is and what they entail. I think giving each item a part of speech, such as a noun, really helps my personal understanding of the material. Now that we have two diagrams that we’ve learned about, ERD’s and Swim lanes, I find that I like drawing ERD’s better, but I find the concept of swim lanes easier. Which did you find easier to draw and/or comprehend?
I really liked how you talked about every detail of ERD’s and how you noted the differences in the two notations.