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

My E-Commerce Website Research and Development Plans

By Chidiere Oluoma
Image
Storyset (2020) My E-Commerce website will be selling Musical Instruments and materials, including courses, and books.  The business model for my E-Commerce website is both  B2C and B2B. This is because I will offer sale not only to individual instrumentalists, musicians or music enthusiasts, but also to organizations such as churches, schools, theatres, concert halls and many more. These would make up my target market. The business name for my E-Commerce website is  Clef Musicals .  My tagline / slogan is :  "...w here sound meets soul". I researched the following competitor E-Commerce websites: https://www.intasound-music.co.uk/  https://www.techinabox.co.uk/  https://jordanguitars.co.uk/  https://just-music.edan.io/  https://iconmusicuk.com/ All of the aforementioned websites offer a unique range of products, however, lacking by way of product affordability, user-friendly design, and variety of products. These will be the points I will work on, and incorporate into my webs
Read more

E-Commerce: Types and Examples

By Chidiere Oluoma
Image
Macrovector (2020)                                                                                                     There are several types of e-commerce. In today's blog post we shall discuss these different types, as well as highlight a few examples. Business-to-Business (B2B)                                                                                                Rawpixel.com (2018)                                                                                                     This type of electronic commerce refers to "the electronic exchange of products, services or information between businesses rather than between businesses and consumers. Examples include online directories and product and supply exchange websites that let businesses search for products, services and information and initiate transactions through e-procurement interfaces. A Forrester report published in 2018 predicted that by 2023, B2B e-commerce will reach $1.8 trillion dollars and account
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 companies always vie for the first page, where they are most likely to garner the most attention."  LaFleur, G. (2022) LaFleur explains that "search engines use bots to crawl all website pages, downloading and storing that information into a collection known as an index. This index is like a library and when someone searches for something in it, the search engine a
Read more