"cell_type": "markdown",
"metadata": {},
"source": [
- "A [relational database](../../gloss.html#relational-database)\n",
+ "A [relational database](https://github.com/swcarpentry/bc/blob/master/gloss.md#relational-database)\n",
"is a way to store and manipulate information\n",
- "that is arranged as [tables](../../gloss.html#table-database).\n",
- "Each table has columns (also known as [fields](../../gloss.html#field-database)) which describe the data,\n",
- "and rows (also known as [records](../../gloss.html#record-database)) which contain the data.\n",
+ "that is arranged as [tables](https://github.com/swcarpentry/bc/blob/master/gloss.md#table-database).\n",
+ "Each table has columns (also known as [fields](https://github.com/swcarpentry/bc/blob/master/gloss.md#field-database)) which describe the data,\n",
+ "and rows (also known as [records](https://github.com/swcarpentry/bc/blob/master/gloss.md#record-database)) which contain the data.\n",
" \n",
"When we are using a spreadsheet,\n",
"we put formulas into cells to calculate new values based on old ones.\n",
"When we are using a database,\n",
"we send commands\n",
- "(usually called [queries](../../gloss.html#query))\n",
- "to a [database manager](../../gloss.html#database-manager):\n",
+ "(usually called [queries](https://github.com/swcarpentry/bc/blob/master/gloss.md#query))\n",
+ "to a [database manager](https://github.com/swcarpentry/bc/blob/master/gloss.md#database-manager):\n",
"a program that manipulates the database for us.\n",
"The database manager does whatever lookups and calculations the query specifies,\n",
"returning the results in a tabular form\n",
"> every database manager can import and export data in a variety of formats,\n",
"> so it *is* possible to move information from one to another.\n",
"\n",
- "Queries are written in a language called [SQL](../../gloss.html#sql),\n",
+ "Queries are written in a language called [SQL](https://github.com/swcarpentry/bc/blob/master/gloss.md#sql),\n",
"which stands for \"Structured Query Language\".\n",
"SQL provides hundreds of different ways to analyze and recombine data;\n",
"we will only look at a handful,\n",
"and the table name in Title Case,\n",
"but we don't have to:\n",
"as the example below shows,\n",
- "SQL is [case insensitive](../../gloss.html#case-insensitive)."
+ "SQL is [case insensitive](https://github.com/swcarpentry/bc/blob/master/gloss.md#case-insensitive)."
]
},
{