» Entity Relationship Diagrams / Teachbook Blog

Entity Relationship Diagrams

What are Entity Relationship Diagrams?

Entity Relationship Diagrams (ERDs) illustrate the logical structure of databases.

An ER Diagram

Entity Relationship Diagram Notations

Peter Chen developed ERDs in 1976. Since then Charles Bachman and James Martin have added some sligh refinements to the basic ERD principles.

Entity		An entity is an object or concept about which you want to store infomration.
Weak Entity		A weak entity is an entity that must defined by a foreign key relationship with another entity as it canot be uniquely identified by its own attributes alone.
Key Attribute		A key attribute is the unique, distinguishing characteristic of the entity. For example an employee’s social security number mightbe the employee’s key attribute
Multivalued Attribute		A multivalued attribute can have more than one value. For example, an employee entity can have multiple skill values.
Derived Attribute		A derived attribute is based on another attribute. For example, an employee’s monthly salary is based on the employee’s annual salary.
Relationship		Relationships illustrate how two entities share information in the database strucutre.
Cardinality		Cardinality specifies how many instances of an entity relate to one instance of another entity. Ordinality is also closely linked to cardinality. While cardinality specifies the occurences of a relationship, or
Recursive Relationship		In some cases, entities can be self-linked. For example, employees can supervise other employees.

The above information has been adapted from SmartDraw Website