Tuesday 20 September 2022
#### **In-session activities:**
1. **Questions / admin (5 min)**\
\
2. **Lecture (40 min; Raymond Ng)**\
- Entity-relational models
- Cardinality and participation constraint\
See: [lessons 4-5 slides](https://canvas.ubc.ca/courses/97662/files/22309525?wrap=1 "LDP-SDM-2022-lessons4-5_lecture_slides.pdf")[Download lessons 4-5 slides](https://canvas.ubc.ca/courses/97662/files/22309525/download?download_frd=1)
3. **Break-out groups (20 min)**
- In your groups, work through the questions outlined in the [activity](https://canvas.ubc.ca/courses/97662/files/22361188?wrap=1 "LDP-SDM-2022-lesson5_activity.pdf")[Download activity](https://canvas.ubc.ca/courses/97662/files/22361188/download?download_frd=1)
4. **Whole-class discussion (20 min)\
\
**
#### **Homework:**
- **DMP Assignment ([midpoint submission](https://canvas.ubc.ca/courses/97662/assignments/1189489 "DMP Midpoint Submission"))**: Design an entity-relationship database structure for your data and submit it as part of the *Data Collection* section of your Data Management Plan. If your data will not require a database (i.e., because all information can be summarized in a single table), develop a clear plan for how your data will be structured.
- Submit the *Project Details*, *Data Collection*, and *Storage & Back-up*sections of your DMP to Canvas
- **Due**: Friday 23 September 2022 (midpoint feedback submission)
- See: [Data Management Plan Assignment](https://canvas.ubc.ca/courses/97662/assignments/1189491 "Data management plan") for instructions, rubric, and deadlines\
\
#### **Supporting materials:**
- Looking for more information on how to structure databases with entity-relationship diagrams? Check out this YouTube video: [Entity Relationship Diagrams (ERD) Tutorial - Part 1Links to an external site.](https://www.youtube.com/watch?v=QpdhBUYk7Kk)
```{=html}
<!-- -->
```
- Looking for more information on primary and foreign keys? Check out this youtube video: [Entity Relationship Diagram (ERD) Tutorial - Part 2 ](https://www.youtube.com/watch?v=-CuY5ADwn24)
