Web Techniques: Table 1

Table 1

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

ATTRIBUTE	TYPE	FIELD SIZE	REQUIRED?	INDEXED?	COMMENTS
Index	Text	6	Yes	Yes (no duplicates)	Primary Key
MatchIndex	Text	6	Yes	Yes
Topic	Text	10	Yes	Yes
Qtype	Number	Integer	Yes	No
QuestionText	Text	250	No	No
CorrectResponse	Text	10	Yes	No
Explanation	Text	250	No	No
ATTRIBUTE	TYPE	FIELD	REQUIRED?	INDEXED?	COMMENT
Index	Text	6	Yes	Yes	Primary Key
Response	Text	1	Yes	Yes	Primary Key
ResponseText	Text	160	No	No	Primary Key
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.