The one big flat (sparse) table might be handy for reporting, but since you're worried about scale you might want to avoid a sparse table for physical storage. Note that this physical arrangement could be flattened out using a view to look like the one big table with sparse columns that you want to avoid. The multiple choice table will have multiple records pointing to QUESTION whereas the other tables will have one - depending on how you model binary choices. So far you have three tables: MULTIPLE_CHOICE, BINARY_CHOICE, and FREE_TEXT (although you might consider binary choice to be a special case of multiple choice).Įach of these tables is a child of your QUESTION table, i.e. It indicates what type of child table is applicable. Your field choice_type_id is essentially a kind of partitioning attribute. Simply include in your model a choice table for each type of choice that your What would be the best schema design considering I want fast reads and the question types will keep increasing further. This would be a very sparse representation and I'm not sure how this will scale. I can model the question_choice table as a big table which can have all the three types and based on the type certain columns can have values and all other remain null. the user chose which choices or entered what text for the given question)
#Dbschema key crack
I would further want to see user interactions with each of these questions and choices within that question ( i.e. SQL Editor: DbSchema Hack Report Builder: key Features: DbSchema DBSchemaDBSchema 9.0.4 Crack Supports: Import Database Schemas: Edit Database Schema. How do I populate a question's choices based on its type and model this in a sql like db. For binary choice, I want to store two choices against a question and for freetext, I have no choices. On the other hand, DbSchema provides the following key features: ER diagrams Reverse engineer schema from database Relational data.
Now all the different choice types have a different schema.įor multiple choice, I want to store multiple choice fields against a question. Now, the question table (which has question_id, question_text, choice_type_id) has a foreign key to the choice type table ( choice_type_id, choice_type_desc). I have a question table which contains question_id, question_text and choice_type_id ( say freetext, binary choice and multiple choices )
0 kommentar(er)
