Regarding the tables, you would define how you would want the survey to work in terms of the data your were collecting. It's your app, so design it as you see fit.
Something along the lines of:
Or maybe you just need Questions and Responses if your answers aren't dynamic.
It all depends on how you want to model your app.
Your results would be done by queries with joins so that the answers relate to the questions. You might also want to consider things like:
- Do you want to be able to report on the dates that the questions were answered
- etc etc etc
My advice when designing any development project is sit down and plan it on paper, and then build around your plan. Don't dive into the application straight away and build it as you go along. You can run into no end of issues.