What ia an ERD. Define the ERD related terms, including entities, attributes, cardinalities and relationships

 What is an ERD?


An Entity Relationship Diagram is a graphical representation that depicts relationships among different items within an IT system.


ERD diagrams include the following terms

1. Entities - A definable thing or concept within a system such as a person/role, object, concept, event

2. Attributes - features associated with entities 

3. Relationships - how one entity is related to another 

4. Cardinality ratio - how many instances of one entity is related with another (one-one , one-many)

(Veen, 2021)




References:

van der Veen, L. (2021) What is cardinality in data modeling? The theory and practice of database cardinalityVertabelo Data Modeler. Vertabelo. Available at: https://vertabelo.com/blog/cardinality-in-data-modeling/ (Accessed: March 6, 2023).

Entity Relationship Diagram (ERD) (no date) Smartdraw.com. Available at: https://www.smartdraw.com/entity-relationship-diagram/ (Accessed: March 6, 2023).


Comments