Skip to content
Gallery
Case Studies [System Design Template]
Case Study #1: Spotify
Case Study #2: Ice Cream Shop
Client Project Database
Share
Explore
Case Study #2: Ice Cream Shop

icon picker
Part 2: Develop the database

megaphone

Your goal is to make a database for managing the ice cream orders.

By the end, you should be able to calculate the payment total for a customer (that may or may not get a membership discount!) with multiple orders.

Just like you learned in the Spotify Case Study, make sure that each table only has one object and its attributes being listed. Then you can join the tables together using relationships.

go

Ready, set, GO!

To make a table, just type /table. Or click the + button on the left side and select “table”.
Each table should have a very simple name.

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.