"and all our queries assume there will be a row in the latter\n",
"matching every value in the former.\n",
" \n",
- "This problem is called [referential integrity](../../gloss.html#referential-integrity):\n",
+ "This problem is called [referential integrity](https://github.com/swcarpentry/bc/blob/master/gloss.md#referential-integrity):\n",
"we need to ensure that all references between tables can always be resolved correctly.\n",
"One way to do this is to delete all the records\n",
"that use `'lake'` as a foreign key\n",
"before deleting the record that uses it as a primary key.\n",
"If our database manager supports it,\n",
"we can automate this\n",
- "using [cascading delete](../../gloss.html#cascading-delete).\n",
+ "using [cascading delete](https://github.com/swcarpentry/bc/blob/master/gloss.md#cascading-delete).\n",
"However,\n",
"this technique is outside the scope of this chapter.\n",
"\n",
" in `Survey.person`\n",
" with the string `'unknown'`.\n",
"\n",
- "2. One of our colleagues has sent us a [CSV](../../gloss.html#csv) file\n",
+ "2. One of our colleagues has sent us a [CSV](https://github.com/swcarpentry/bc/blob/master/gloss.md#csv) file\n",
" containing temperature readings by Robert Olmstead,\n",
" which is formatted like this:\n",
"\n",