Thursday 15 September 2022\
#### **Optional pre-session readings:**
- Céréghino, R., Pillar, V.D., Srivastava, D.S., de Omena, P.M., Macdonald, A.A.M., Barberis, I.M., Corbara, B., et al. (2018). Constraints on the functional space of aquatic invertebrates in bromeliads. *Functional Ecology*, 32, 2435-2447. [https://doi.org/10.1111/1365-2435.13141 Links to an external site.](https://doi.org/10.1111/1365-2435.13141)[**PDF**](https://canvas.ubc.ca/courses/97662/files/19784398?wrap=1 "Céréghino et al. 2018 Funct. Ecol.pdf")[ Download PDF](https://canvas.ubc.ca/courses/97662/files/19784398/download?download_frd=1) \
\
#### **In-session activities:**
1. **Questions / admin (5 min)**\
\
2. **Lecture (50 min; Raymond Ng)**
- Using relational databases: joins, primary keys and foreign keys\
See: [lesson 4-5 slides](https://canvas.ubc.ca/courses/97662/files/22309525?wrap=1 "LDP-SDM-2022-lessons4-5_lecture_slides.pdf")[Download lesson 4-5 slides](https://canvas.ubc.ca/courses/97662/files/22309525/download?download_frd=1)
3. **Break (10 min)\
**
4. **Whole-class Activity and Discussion (15 min)**
- Poll questions
#### **Homework:**
- [**Data cleaning assignment**](https://canvas.ubc.ca/courses/97662/assignments/1189490 "Data Cleaning and Standards (individual/group assignment)") **- due Friday 16 September 2022**
