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



Depends on the length and type of material


Depends on location and square footage


Depends on the size


Depends on the material and labor involved


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.