8 Week SQL Challenge - Case Study 6 (Enterprise Relationship Diagram)

UpdatedMarch 1, 2026

•1 min read

Mary has been writing about Data Science on her blog (http://maryjonah.me) for years. In her free time, she likes to read books and have a good rest.

We are on 6 out of 8 case studies. It has been a journeeeyyyyyy and boy ooo boy it has not been easy. This is not the time to give up I can smell the bouquet of flowers at the end of all of these (I should get myself Haagen-Dazs Strawberries&Cream Ice Cream 100ml) because I truly deserve this.

The task for this focus area is to draw an ERD diagram for all the tables that will help Danny in understanding user's interactions on his website.

Solution: Click on this link to see my ERD diagram for the focus area: 1. Enterprise Relationship Diagram

#8weeksqlchallenge #public-learning #sql

Comments

Join the discussion

No comments yet. Be the first to comment.

More from this blog

Let's have a summer sale ☀️🏖️😎🌴

In about a month's time, the summer begins and by now, most companies are already out with good deals on their products. Unfortunately, my fictional company was dealing with other issues, so they are

May 20, 20262 min read

Introducing "Four-Eyed Insights 🤓"

PS: Moved all articles in this series to Four-Eyed Insights Series' Articles - DEV Community as according to Hashnode 2 articles in these series are not technical and developer-focused enough. They ha

Apr 30, 20261 min read

In the beginning ...

Welcome to the first article in the series where I breakdown my thinking and working process for a data analysis project. In this article, I want to talk about the following: Why start with ecommerce

Apr 29, 20262 min read

The Silence

"Starting this new year, I am looking at getting involved with challenges." the first line typed on Wednesday, 4th February 2026. The goal then was simple, to get involved in challenges and I started

Apr 28, 20262 min read

8 Week SQL Challenge - Case Study 6 (Digital Analysis)

We are back on track and in the article we answer the questions for the 2. Digital Analysis focus area in the 6th case study: Case Study #6 - Clique Bait How many users are there? SELECT COUNT(DISTI

Mar 1, 20261 min read

Mary Jonah

27 posts