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 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. 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 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". 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
Archived
This topic is now archived and is closed to further replies.