database design help needed!!
I'm designing a dbase using SQL server and using VB.Net. i have a form (paper
form ) where the user is required to answer some questions and for some questions
he has to select more than one answer
What are your favorite colours?
Should i create a table only for that question and have my columns as checkbox1
to checkbox4 ? If that's the case if i have 50-100 questions similar to this
does it means i need to have 50-100 tables? i'm not really sure whether i'm
on the right path or if there are better solutions. Please let me know.
Thanks in advance for ur help..
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL