Physical Design   «Prev  Next»

 

Common database design mistakes - 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.