I am trying to make some health-related survey for my personal research project. I am using oracle database, ASP and other web related tools. I appreciate if you can suggest me
I have this database-driven Health survey. In short, this survey starts with 2-3 Questions, based on how they answer I will display the next set of questions just like tree-branching logic. The next set of questions will depend on how they answer previous questions. I can not make database call everytime, when the application starts i want to load all this 50-100 questions in some temporary data structure and use it through out the application, once they are done, i will insert the responses in the database. Please suggest me any ideas / points that will help in this design
Survey_Num Integer NUMBER(8)
Survey_Desc String VARCHAR2(100). The description is a longer text that contains, for instance, instructions on how to fill the survey and is presented to the user taking the survey.
User_ID String (Foreign Key) NUMBER(30)