Entity Relationship Diagram for my Website

By Chidiere Oluoma

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.




Comments

Post a Comment

Popular posts from this blog

Definition of Programming Languages

By Chidiere Oluoma
Image
                                                                                                                    Macrovector (2021) According to senior technology editor, Peter Loshin, a program is a set of ordered operations for a computer to perform. This usually does contain a one-at-a-time sequence of instructions that the computer carries out. (Loshin, 2021) Wikipedia defines Computer programming as "the process of performing a particular computation (or more generally, accomplishing a specific computing result), usually by designing and building an executable computer program." (Wikipedia, 2023) Below, we will be going through some of the ...
Read more

Analysis and Comparison of E-Commerce Websites

By Chidiere Oluoma
Image
                                                                                                  Starline (2021) In our recent updates, we have discussed the meanings , history , and properties of e-commerce websites. We shall however be evaluating the differences and similarities between the homepages of two notable e-commerce websites in this post. Our case studies will be Amazon and Jumia . Headers              Fig 1: Jumia        [Jumia (2023)]                               ...
Read more

What is SEO and how is SEO used?

By Chidiere Oluoma
Image
  Redgreystock (2022)                                                                                                                             According to Griffin LaFleur, "search engine optimization is the science of improving a website to increase its visibility when people search for products or services. The more visibility a website has on search engines, the more likely it is that brand captures business."  LaFleur, G. (2022) He also goes further to state that "website visibility is commonly measured by the placement -- or ranking -- of the site on search engine results pages (SERPs). And companie...
Read more