Chidi's Hub: The Computing Blog

In the previous blog, we discussed the  Entity Relationship Diagrams . In this post, however, I will be giving an Entity Relationship Diagram (ERD) made with Draw.io that reflects the content of my website. fig: Entity Relationship Diagram From the illustration above, it can be deduced that the Entities are: Customer Music Course Music Equipment, and Musical Instrument Each of these aforementioned entities have attributes, represented in an oval shape. Viz: Name ID Address Brand Price There are also relationships, which are represented by a "diamond shape". Lastly, I have also made use of the 1 to 1 cardinality ratio, and the 1 to many ratio as well.

(Freepik, 2020) Bis cobing defines Entity Relationship Diagram (ERD) as "a graphical representation that depicts relationships among people, objects, places, concepts or events within an information technology (IT) system. An ERD uses data modeling techniques that can help define business processes and serve as the foundation for a relational database." ( Biscobing, 2019) The ERD comprises of certain terminologies used in relation to the items on the diagram. These are: Entity "An entity may be any object, class, person or place. In the ER diagram, an entity can be represented as rectangles.  Consider an organization as an example- manager, product, employee, department etc. can be taken as an entity." (Javapoint, no date) Attribute "The attribute is used to describe the property of an entity. Eclipse is used to represent an attribute. For example, id, age, contact number, name, etc. can be attributes of a student." (Javapoint, no date) Relationship The re...