• While interesting conceptually I think this approach creates more problems than it solves.

    Here are some of the drawbacks I see:

    1. Conceptually complicated - a junior person may not know how to generate a simple report

    2. Very hard to query - requires verbose and complex bitwise logic

    3. What happens if some of the options - say option 3 and 4 - are removed later on but the rest are kept?

    4. What happens if new options must be added in the middle? Sure we can position it as option3 on the form but in reality it's option9 in the database. Becomes confusing when querying.

    I'd love see your thoughts on these. Been looking myself for a good way to store questionnaires/surveys data.