Consider adding instructor notes for good db design/the quirks of the data

[JordanPedersen]

@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)

[librarianlise]

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]

@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]

@jyssy that is indeed what Jordan and I were thinking. 👍

[jyssy]

@kristindawn plans to work on this during May 14 2021 sprint.

[jyssy]

@kristindawn just checking on this issue - finally getting into issues after a while. Still making progress. Do you need anything? thank you