YMYL Posted January 1, 2013 Share Posted January 1, 2013 Hi all I'm a newbie working on my first decently sized project. Right now I'm trying to build a hosted poll script. Visitors to the site would be able to signup and build polls. I can user registration down, it's just that I have no idea how to structure the database. I was thinking about doing one table for each poll, but that would soon be unwieldy. Any help would be greatly appreciated. Thanks Quote Link to comment https://forums.phpfreaks.com/topic/272585-how-to-structure-the-db-for-this-particular-script/ Share on other sites More sharing options...
Jessica Posted January 1, 2013 Share Posted January 1, 2013 You would have a table each for: polls, questions, possible answers, visitors/users, answers given. Quote Link to comment https://forums.phpfreaks.com/topic/272585-how-to-structure-the-db-for-this-particular-script/#findComment-1402607 Share on other sites More sharing options...
YMYL Posted January 1, 2013 Author Share Posted January 1, 2013 why not combine a table for possible answers and answers given? also what would a table for polls look like? I understand a table for questions Thanks Quote Link to comment https://forums.phpfreaks.com/topic/272585-how-to-structure-the-db-for-this-particular-script/#findComment-1402615 Share on other sites More sharing options...
Jessica Posted January 1, 2013 Share Posted January 1, 2013 Google "normalization". Quote Link to comment https://forums.phpfreaks.com/topic/272585-how-to-structure-the-db-for-this-particular-script/#findComment-1402617 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.