24. What is an ERD.

According to Brumm (2022) ERD which is known as Entity relationship diagram, is a type of diagram that shows you how different entities relate to each other in a database. Examples can be a data could be talking about people or customers. They are created in order to assist a developer in understanding how to structure the databases accordingly. ERD uses a specific set of symbols such as Arrows and shapes.

Here is an image to show an example of an entity relationship diagram.

                                                                                                                                                           

What are the components an ERD.

1. Entity. (uk.indeed.com)

A database of entities is a collection of data. Industries and administrators can sort, categorize, and organize this data. An entity is distinct from other objects in that it has its own existence. Entity sets are the foundation of any successful database management system and are used to create databases.

2.Relationship. (in.indeed.com)

It is a link between two tables. To retrieve data, those associations are created using join statements. It is a relationship between two database tables in which one table has a foreign key that references the primary key of the other tables. Relationships allow relational databases to separate and store data in different tables while connecting disparate data items.

3. Attributes. (Ben Brumm 2022)

A property of an entity or something that can be used to describe an entity is referred to as an attribute. They are frequently depicted as ovals or as entries within an entity.

 References.

1. BRUMM, B. (2022) A Guide to the Entity Relationship Diagram (ERD). [Online]. Available from: https://www.databasestar.com/entity-relationship-diagram. [Accessed date: 10/03/2023]

2. BRUMM, B. (2022) A Guide to the Entity Relationship Diagram (ERD). [Online]. Available from: https://www.databasestar.com/entity-relationship-diagram. [Accessed date: 10/03/2023]

3. UK.INDEED.COM. (2023) What is an entity in database management. [Online]. Available from:https://uk.indeed.com/career-entity. [Accessed date: 09/03/2023]

4. IN.INDEED.COM (2023) What are entities used for. [Online]. Available from: https://in.indeed.com/career/relationship. [Accessed date: 09/03/2023]