Intro to Database
Design
April 2018
Please go to:
bit.ly/databasedesign
To give us your email
and collaborate on
workshop materials
Slide 2
Slide 2 text
Goals + Agenda
9:00 - 9:30: Introductions + Housekeeping
9:30 - 10:00: Overview of Database and Database Design
10:00 - 11:00 Make a Database in Airtable
11:00 - 12:00 Design your own database + Share
Slide 3
Slide 3 text
What is a Database?
Slide 4
Slide 4 text
A database is an organized collection of
data that can be accessed, managed, and
updated.
Slide 5
Slide 5 text
Why Database?
Slide 6
Slide 6 text
No content
Slide 7
Slide 7 text
Meta Data - Name, Type, Size, and Description of Data
Name Type Description
Student Name Text Student’s Name
Student ID Number Unique identification
number for each student
Date of Birth Date Student’s Date of Birth in
the Format “01/01/1990”
Vaccination Boolean Whether or not a student is
vaccinated - T or F.
Photo Image Student’s photo for ID.
Address ??? Student’s Home Address
Slide 8
Slide 8 text
Address
Name Type Description
Street Number + Text Street address in the format
1234 Adams Street.
Apartment or Suite Number Number Optional apartment or Suite
number.
City Text Name of the City.
State Characters One of 50 U.S. States in the
format ‘AB’.
Zip Code Number Zip code number 12345.
Slide 9
Slide 9 text
Books
Name Type
Title Text
Year Published Number
Price Currency
On Loan True or False
ISBN Some complicated number
Author Own set of data
Slide 10
Slide 10 text
Define Data and Metadata about one of the
Following. You have 5 minutes.
You are: City of Houston.
Keeping track of Potholes in
Houston.
You are: Fashion editor of a
magazine.
Editorial Calendar for your
writers.
You are: Fantasy Baseball
Fanatic.
Baseball Teams in MLB.
You are: Entrepreneur.
Parts inventory of a Drone
startup.
Slide 11
Slide 11 text
Do any of those data have more data?
Trade with a neighbor.
Define and see if their data has more data.
Work with your neighbors.
Take 5 Minutes.
Slide 12
Slide 12 text
Let’s put one of the
databases you designed
in Airtable
Slide 13
Slide 13 text
guide.airtable.com
Slide 14
Slide 14 text
Create a
Database
Slide 15
Slide 15 text
Collab with a Team
Slide 16
Slide 16 text
Filtering and Sorting
Slide 17
Slide 17 text
Publishing
Views
Slide 18
Slide 18 text
Let’s build our own
database!
Slide 19
Slide 19 text
Consider:
What information might you want to ask your
database? -> Tables, Linking to Tables, Field
Types
Who are the users? -> Share Views, Filtering
and Sorting
How are you getting data? -> Collaborators,
Forms
Slide 20
Slide 20 text
Yelp Database Schema
Slide 21
Slide 21 text
Please share your
Databases at:
bit.ly/sharedatabases
Slide 22
Slide 22 text
No content
Slide 23
Slide 23 text
Please complete an anonymous
post-workshop survey at:
bit.ly/endfeedback