At 06:45 AM 3/8/2004, Charlie Smith wrote:
>What affect would it have if we were to allow active surveys to be modified in
>that we could add questions to the existing survey?
Off the top of my head...
If the question you add is not a required question, and you want to be able
to see how many people chose to answer that question, you would need an
"effective date" representing the date that the question was added, in
order to be able to distinguish non-responses from respondents who
submitted a survey before the question existed. Seems like that column
would need to be added to the 'question' table.You'd then need to modify
the Admin pages like "View Survey Responses" so that they take this into
account.
Brian Wood
Programmer/Analyst
UC Berkeley Human Resources
|