# Database: Misc Problems

Name: _________________________________

One point for each possible correct answer unless otherwise indicated. CLOSED BOOK/NOTES.

1. Which terms have the same meaning as table? Circle all that are correct.
   a. column, b. tuple, c. field, d. record, e. row, f. attribute, g. file
2. Which terms have the same meaning as row? Circle all that are correct.
   a. column, b. tuple, c. field, d. record, e. table, f. attribute, g. file
3. Which terms have the same meaning as field? Circle all that are correct.
   a. column, b. tuple, c. row, d. record, e. table, f. attribute, g. file
4. What do the following terms mean?

   DBA | __________________________________________________
   SQL | __________________________________________________

5. Which of the following are true of referential integrity?
   1. For every (non-null) primary key there is a foreign key with that value.
   2. For every (non-null) foreign key there is a primary key with that value.
   3. There must be no foreign keys.
   4. All primary keys must be non-null.
   5. All foreign keys must be non-null.
6. What is the relationship between the attribute domains of a foreign key and the primary key it references?
   1. They must be the same (or "compatible") type.
   2. They do not need to be the same type because they are fields in different tables.
7. Name two commercial DBMSs.
   __________________________________________
   __________________________________________
8. A bridge table is necessary in a relational database to implement.
   1. Any foreign key to primary key relationship.
   2. An optional relationship.
   3. A supertype-subtype (eg, Pilot-Employee) relationship.
   4. A one-to-many relationship.
   5. A many-to-many relationship.
   6. None of the above.