- List the characteristics that a table must have to be considered a relation.
- List two synonyms for “file,” two for “record,” and two for “field.”
- What are the four uses of a primary key?
- What are the desirable characteristics of a primary key?
- What is a surrogate key and when do you use them?
- What is a foreign key?
- What is referential integrity and why is it important?
- What are the three possible interpretations of a null value?
- What is normalization? Why is it important?
