Template Database

Template DB

Example table

Table Name: Temp1

(This table will be associated with the template with the corresponding digit key)

Example template: How much does a x cost?

Primary key Answer

stud	Depends on the length and type of material
house	Depends on location and square footage
nail	Depends on the size
roof	Depends on the material and labor involved
contractor	Depends on the type of project

Within the application each template will be stored in a hash with an associated digit. A corresponding table named by combining the prefix “Temp” and the key will be used to represent each template. Within the table the primary key will be the missing variable and be used to reference the answer to the question.

NOTES:

• I realize that it isn’t good to use a string as a primary key due to a slight performance issue.

• The structure of the table may not be optimal I have no formal database training. Taking a DB class and researching it next semester.

• Please remember this is the first cut solution and will evolve over time.

• Eventually want to add another variable to the templates would make it a lot more flexible. Give me 40 hours in a day and I would probably get it done.