Efficient method of storing many database records with usually short strings but still need to accomodate long ones
I run across this issue occasionally and am curious if there are better design methods to use that would work better than the ones I’ve used.
Need to determine whether different question types for a questionnatire are many to many or one to many
We need to survey our contacts by asking them various questions and recording their responses. Some questions are standard and must be included in every survey (default questions), while others are specific to individual surveys and created as needed.