Hey Gene,

Not only can you accomplish this with DNN, you can probably accomplish it without any custom development. While there are many solutions to a given problem (and everyone else - feel free to chime in with your thoughts) my first thought is that a module by DataSprings called Dynamic forms has the functionality that you need.

With it you could set up one or more forms that show and hide questions based on the user's role. Then you can define custom events that happen when the user submits the form and use SQL to insert the data into the database.

Their module is very flexible and I've had good experience with it (although I've only used it for one project). But, because there are so many options, setting the module up can be a little overwhelming, but from what I can tell they have pretty good documentation and support. Check out their website for more information.

Hope that helps,
Take care,

Ian