Survey module in ASP.NET

[cyberdeminout]

Hi,
We are going to implement a survey module in asp.net (Create Surveys, Sections, Questions, Display Survey Results).
Can any body help me, how to design db for this complicated module.

Any help highly appreicated.

Thanks in Advance

 

[jmeckley]

first thing I would start with. The GUI is decoupled from the database. on shouldn't know about the other.

1. determine what you want the GUI to look like.
2. create a service layer to provide the information required by the GUI
3. Implement a domain model to fulfill the requirements of the service layer.
4. Once needed, create repositories which will ultimately map the domain objects the database. I recommend a framework like ActiveRecord or NHibernate.

Check out the book Domain Driven Design by Eric Evans. this will set the foundation on how the code is structured into layers (not physical layers, but logical layers) and objects.

Jason Meckley
Programmer
Specialty Bakers, Inc.