Intro to SQL

Keys

To uniquely identify the data in a table row, have one column be a key.

Example: a Customer Table for a Sales database.

Keys should be unique; you should not be able to do:

   INSERT INTO customer
          VALUES (3,  'Britney Spears',  'Lost in CA',  -1234);