WHAT IA AN ERD. DEFINE THE ERD RELATED TERMS, INCLUDING ENTITIES, ATTRIBUTES, CARDINALITIES AND RELATIONSHIPS

 What is an ERD?

An entity relationship diagram (ERD), also known as an entity relationship model, is a graphical representation that depicts relationships among people, objects, places, concepts or events within an information technology (IT) system. (Biscobing, 2019)

ERD Terms:

-Entities: which are objects or concepts that can have data stored about them. Entities refer to tables used in databases.

-Attributes: which are properties or characteristics of entities. An ERD attribute can be denoted as a primary key, which identifies a unique attribute, or a foreign key, which can be assigned to multiple attributes.

-Relationship: the relationships between and among those entities.

-Cardinality ratio: how many instances of one entity is related with another, and there is three cardinalities:

1- one-to-one relationship (1:1). For example, if each customer in a database is associated with one mailing address.

2- one-to-many relationship (1:M). For example, a single customer might place an order for multiple products. The customer is associated with multiple entities, but all those entities have a single connection back to the same customer.

3- many-to-many relationship (M:N). For example, at a company where all call center agents work with multiple customers, each agent is associated with multiple customers, and multiple customers might also be associated with multiple agents.(Biscobing, 2019)

(Rodina, 2020)

References:

Rodina, D. (2020) Doctor and patient (Chen Er diagram), Software Ideas Modeler - diagramming case tool. Available at: https://www.softwareideas.net/a/1596/doctor-and-patient-chen-er-diagram- (Accessed: March 12, 2023).

Biscobing, J. (2019) What is entity relationship diagram (ERD)?: Definition from TechTarget, Data Management. TechTarget. Available at: https://www.techtarget.com/searchdatamanagement/definition/entity-relationship-diagram-ERD (Accessed: March 12, 2023).