Proposed changes for 00-sql-introduction.md

[mpfl]

Suggested corrections/clarifications

Relational databases

• Introduction should be fleshed out, include concept of the relationships between tables.

Dataset description

• Perhaps a diagram of how the three tables relate to each other.

Import

• Step 1: There are four CSV files at the target URL. The three to use (plots, species, surveys) should be explicitly named in step 1 (they appear again in step 5)
• Step 1: Link to Portal Project via DOI for long-term link stability: https://dx.doi.org/10.6084/m9.figshare.1314459.v5
• Step 2: Does not mention that SQLite will ask for a database name. Suggest "portal"
• Step 2: Does not mention that SQLite will want to save the database to a folder.
• Step 6: How do we know if the first row contains column headers?
• Step 10: INTEGER, not INT. What about the Primary Key? What about data types for columns not mentioned?

Data Types

• Some explanatory text required.

[michielcock]

Also, under 'Import' first column needs to be not empty, otherwise you can't use first row as title.