sql-novice-survey
sql-novice-survey copied to clipboard
Perhaps a diagram to illustrate database/table/rows/columns/fields
There is a nice diagram in
http://www.datacarpentry.org/R-ecology-lesson/02-starting-with-data.html
showing a dataframe.
In http://swcarpentry.github.io/sql-novice-survey/01-select/ a similar schematic diagram might help students to "Explain the difference between [a database,] a table, a record, and a field."
I am not much of a graphic designer but here is a suggestion:
Inkscape svg file is in this ZIP archive DatabaseDiagram.svg.zip
I think this is a good idea. How about replacing the fields with "date/string/integers" so we can show that columns are uniform types?