Designing Relational Survey Questionnaires Database
Posted
by
user1213055
on Stack Overflow
See other posts from Stack Overflow
or by user1213055
Published on 2012-04-13T05:25:20Z
Indexed on
2012/04/13
5:28 UTC
Read the original article
Hit count: 170
I'm trying to build a simple sql database for following access database. Currently there is no relationship and I just have two tables male and female with 6 sections in each form. How can I design it a better way so end user can connect to the database and analyze using STATA or SPSS ?
I'm really confused whether I should create one table with all fields or break down into different tables. The database is specific to this study only so I'm not looking for a generic survey database where user can create surveys and capture them. Any feedback or suggestion is much appreciated.
© Stack Overflow or respective owner