Lab 1

EDS 213 | Spring Quarter

Overview

The goal of our weekly discussion sections is to answer an analytical question of your choosing using a database. You will create this database yourself, and then use it to answer your question. In Week 7, we will have a database showcase where you get to teach your classmates about the database you created!

View Slides

---

Week 1 Objectives

This week, your goal is to select a dataset and start thinking about its structure.

Specifically, you should:

1. Choose a dataset — You can pick one from the suggested dataset list, or find your own!
2. Understand the relationships among the different tables in your dataset.
3. Define a schema — think about how the tables connect, what the primary and foreign keys might be, and what data types you’re working with.

TipNot sure where to start?

Browse the suggested datasets for inspiration. Look for something that genuinely interests you — you’ll be spending several weeks with this data!