Physical Design   «Prev  Next»

Database Table Modeling - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. To link two tables in a one-to-many relationship, you need:
Please select the best answer.
  A. The primary key of the "one" table as the primary key of the "many" table
  B. The primary key of the "one" table as a foreign key of the "many" table
  C. The primary key of the "many" table as a foreign key of the "one" table
  D. The primary key of the "one" table as a foreign key of the "many" table and the primary key of the "many" table as a foreign key of the "one" table

2. Excluding different writing systems and alphabets, which of the following types of information may need to be accounted for when examining "international issues"?
Please select all the correct answers.
  A. Business names
  B. Addresses
  C. Phone numbers
  D. Postal codes

3. The statement "There are no wrong databases, just useless ones," is best interpreted to mean:
Please select the best answer.
  A. A database that is not in 3NF will run too slowly to be useful.
  B. You should denormalize tables whenever possible.
  C. You can use views to derive whatever information is needed from a database.
  D. Regardless of design, a database must give its users useful information.

4. When resolving a many-to-many relationship using a junction (linking) table, what should serve as that table's primary key?
Please select the best answer.
  A. A single new surrogate key, unrelated to either parent table
  B. The primary key of just one of the two parent tables
  C. A composite key made up of the primary keys from both parent tables
  D. A junction table does not need a primary key

5. A team builds a database with a flawlessly normalized schema and correctly enforced constraints, but the data users actually enter into it is frequently duplicated, inaccurate, or stale. What does this module say about that database?
Please select the best answer.
  A. The database is poorly designed and should be re-architected.
  B. The database is functioning exactly as designed, but is still useless because the data itself can't be trusted.
  C. The database should be denormalized to fix the problem.
  D. This scenario violates referential integrity.