- primary keys
- as defined in table creation
- unique, unique to database--NOT overloaded
- foreign keys
- ALTER TABLE class_student ADD FOREIGN KEY (studentid) REFERENCES student (id);
- Why? avoid dangling references
- Good news, bad news
NEXT
INDEX
Master Index