Repository navigation
Consider adding instructor notes for good db design/the quirks of the data #99
Description
@librarianlise is also interested in giving more context about the data (at least to instructors so they can use the information at their discretion). Examples include:
- certain results can look weird, but it's actually just the data set (i.e. there are many issues to one journal, and the other journals all have one issue)
- time permitting, how it could be valuable to talk about better ways the database could be structured (i.e. a separate subjects table)
Metadata
Metadata
Assignees
Labels
No labels
Activity
librarianlise commentedon Feb 5, 2020
I noticed that the possibility of a separate subjects table is brought up in section 9 (which we didn't teach) so something to consider when we get to this issue.
jyssy commentedon Aug 7, 2020
@JordanPedersen I like this idea. I think putting this at least here: https://librarycarpentry.org/lc-sql/guide/index.html, would be useful. Is that something you think makes sense? Sort of adding as FYI, as questions may arise?
librarianlise commentedon Aug 14, 2020
@jyssy that is indeed what Jordan and I were thinking. 👍
jyssy commentedon May 14, 2021
@kristindawn plans to work on this during May 14 2021 sprint.
jyssy commentedon Mar 18, 2022
@kristindawn just checking on this issue - finally getting into issues after a while. Still making progress. Do you need anything? thank you