JavaScript required
We’re sorry, but Coda doesn’t work properly without JavaScript enabled.
Skip to content
Gallery
Case Studies [System Design Template]
Case Study #1: Spotify
Case Study #2: Ice Cream Shop
Client Project Database
More
Share
Explore
Case Study #1: Spotify
Case Study #1: Part 2
Now what if we wanted to put all your data together in one big table?
There’s probably a lot of differences between your song table, and your partners’ song tables. So it might be difficult...
That’s where the
schema
comes in!
We want to have a standardized way to
label
all this information.
It will make it...
Easier for our users to understand
Allow our developers to make fewer mistakes, and
Make everything more efficient and easy to calculate things from
Fill in the information from your 7 songs from Part 1.
Use the assigned rows for each team member to keep things organized:
Team Member #1
,
Team Member #2
,
Team Member #3
You might not have some of those information yet. Go ahead and fill it in :)
Open me for Video Instructions:
Songs
Songs
1
Name
Album
Artist
Album Cover
i
Number of Plays
Bio
Release Date
Name
Album
Artist
Album Cover
i
Number of Plays
Bio
Release Date
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
There are no rows in this table
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
Ctrl
P
) instead.