Relational Databases & Goal Setting
- A spreadsheet is a database
- Relational databases = relationships between databases
- Content model = how data is organized
- Object model = how a single "thing" is organized
- Relational databases have many object models within their content model
- There must be a key relating two object models
| 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
Project Planning Advice
| Family Self care Mental/Physical health Short-term due dates |
Finishing the diss 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
- Fossieck lunch in lieu of class Monday April 10
- Design for accessibility
- DH on a CV/resume
- Learning to teach yourself & troubleshooting
- Email me if there's anything you want to know more about or make sure we cover before the end of the semester!
Suggested planning
- Do a data critique
- Clean your data
- Make a long-term to do list
- First draft of 1 visualization
Relational Databases & Goal Setting
By mkane
Relational Databases & Goal Setting
- 145
