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