Table 1


The Question table (top) and the Answer table (bottom) comprise the test database design.

ATTRIBUTETYPEFIELD SIZEREQUIRED?INDEXED?COMMENTS
IndexText6YesYes (no duplicates)Primary Key
MatchIndexText6YesYes
TopicText10YesYes
QtypeNumberIntegerYesNo
QuestionTextText250NoNo
CorrectResponseText10YesNo
ExplanationText250NoNo
ATTRIBUTETYPEFIELDREQUIRED?INDEXED?COMMENT
IndexText6YesYesPrimary Key
ResponseText1YesYesPrimary Key
ResponseTextText160NoNo

Note:

  • A one-to-many relationship between the tables is defined by matching values of the Index field. The Access relationship is used to define this association. Referential integrity, cascading updates, and cascading deletes should be enabled.
  • The 10-character length of the CorrectResponse field in the Question table allows multiple correct responses to be listed for the multiple-multiple-choice question type. These may be separated by spaces or any other nonalphanumeric character for readability.