web2.0 – Entity Relationship Diagrams (ERD)

client-side-scriptingHave you ever created a website using HTML, CSS and JavaScript? These three languages are client-side languages which run on your computer through the web-browser and are used to create static websites. HTML is used to add content to a webpage (text, headings, pictures etc.). CSS is used to update the look & feel and the layout of the page and JavaScript is often used to make the page more interactive.

In the early days of the Web (back in the 90s), the World Wide Web was only made of static websites. The pages of such websites were always displaynig the same content.

Web 2.0

server-side-scripting
Progressively, the internet evolved to more dynamic websites. We call this web2.0.

Web2.0 Websites such as Wikipedia, Twitter, Facebook, Amazon, Vinted etc. are database-driven dynamic websites. Their content changes constantly based on the user interactions with the site. They rely on storing information on back-end (server-side) relational databases. They use server-side technologies/languages such as PHP, ASP, .Net, C#, Python to process user requests and access or update data stored in the database.

Your Task…

In this challenge we are going to investigate the design of the relational databases that could be used by popular web2.0 websites such as:

  • E-commerce websites (e.g. Amazon)
  • Social networks (e.g. Twitter)
  • Auction Websites (e.g. eBay)

Our aim will be to try to recreate the Entity Relationship Diagrams (ERD) used by these types of websites. Your task is to use the following tabs to find out about the main characteristics of these different types of dynamic websites to then attempt to draw a relevant ERD for each type of websites.

Client/Server TechnologiesE-Commerce WebsitesAuction WebsitesTwitter vs Facebook
The following diagram summarises some of the key concepts of client-server web-based applications:

client-server-technologies

Most e-commerce websites use a similar database structure (ERD) in order to:

  • Store information about the products they sell,
  • Organise products into categories,
  • Store information about customers,
  • Store information about orders being raised by customers.
  • Store information about reviews left by customers on different products.

Use our online tool to design an ERD for a relational database that would meet the above requirements:
Design Your ERD Online

Most auction websites such as eBay use a similar database structure (ERD) in order to:

  • Store information about the members which can be buyers or sellers,
  • Store information about the products being sold,
  • Store information the bids being raised,
  • Store information about reviews left by buyers on different sellers.

Use our online tool to design an ERD for a relational database that would meet the above requirements:
Design Your ERD Online

We will now investigate the ERDs to be used to replicate the key functionalities of social networks like Facebook and Twitter. We will base our social network on a relational database to:

  • Store information about members,
  • Store information about friendship for Facebook (who is friend with who?) or Follows for Twitter (who follows who?),
  • Store information about posts/tweets,
  • Store information about likes (on posts/tweets).

Use our online tool to design an ERD for a relational database that would meet the above requirements:
Design Your ERD Online

Tagged with: , , ,