## Chapter Summary

1. RDB stores information in tables. Each column has a datatype and unique name
2. SQL - command language for interacting w/the DB
3. `CREATE TABLE` and `INSERT` commands to add to a DB. `SELECT` to query. `UPDATE` and `DELETE` to modify the data
4. Do not replicate data among rows. Distribute over multiple tables
5. Primary key - column(s) that uniquely identify a record
   Foreign key - reference to primary key in linked table
6. A join is a query that involves multiple tables
7. Use an API to access a DB from a C++ program
8. Transaction - set of updates that should succeed entirely, or not at all

prev |top