| Instructor | Course | Student |
|---|---|---|
| Kane | DH Practicum | E Tatum |
| Kane | DH Practicum | R Vivas |
| Kane | DH Practicum | A Smith |
| Kane | DH Practicum | H Doyle |
| Kane | US Survey | H Doyle |
| Kane | US Survey | T Laduke |
| Kane | US Survey | C Chadwick |
| Irwin | US Survey | C Chadwick |
| Irwin | War on Terror | H Doyle |
Non-relational database
Relational database
| Instructor | instructor_id |
|---|---|
| Kane | 1 |
| Irwin | 2 |
| Course | course_id |
|---|---|
| DH Practicum | 1 |
| US Survey | 2 |
| War on Terror | 2 |
| Student | student_id |
|---|---|
| E Tatum | 1 |
| R Vivas | 2 |
| H Doyle | 3 |
| T Laduke | 4 |
| C Chadwick | 5 |
| A Smith | 6 |
| student_id | course_id |
|---|---|
| 1 | 1 |
| 2 | 1 |
| 3 | 1 |
| 3 | 2 |
| 3 | 3 |
SQL = Structured Query Language
SELECT * FROM Students WHERE Course="DH Practicum"
Basically a facet or filter that can work on multiple tables
Inner
Left
Joins: Find the intersection of two object models
| Family Self care Mental/Physical health Short-term due dates |
Finishing the diss/thesis Comps Long term personal plans (wedding, travel, etc) Long-term due dates |
| Grading In-person teaching texting about lunch plans, etc |
Your friends complaining about their professors/students Dicking around on the internet |
Urgent
Not Urgent
Important
Not
Important
Small
Measurable
Achievable
Relevant
Time-Bound
Yes "I will spend one hour on Tuesday cleaning the Occupation and Birthplace columns in my data"
No "I will clean all of my data"
Yes "I will have a first draft of a line chart and a chloropleth map by Friday"
No "I will start my data visualizations"
Coming Attractions
Suggested planning