I'm creating a normalized table for a questionnaire that the customers fill in and in one of the columns is a field called "extra comments". I realize that with the "extra comments" field, the data will not be atomic as the customers may be writing sentences or can the sentences be considered as atomic values? How do I keep the "extra comments" field and keep the table normalized?

  • Can you provide existing design? Does comment field relate to whole questionnaire or to each question? – Mladen Uzelac Dec 9 '14 at 11:55
  • Yes, sentence -- any text can be considered "atomic". The domain of that column is customer comment-- set of all possible customer comments.So, each row-column intersection contains exactly one customer comment. – Damir Sudarevic Dec 9 '14 at 13:15
  • So if the comments sections was like a list, would that still be considered atomic? For example, the "extra comments" was for extra suggestions, and the customer gave a list of suggestions, is that still atomic? – jellybean_232 Dec 9 '14 at 13:45
  • If the domain is customer comment than trying to insert more than one is not atomic. Google "What First Normal Form Really Means". You have to understand the concept of domain. – Damir Sudarevic Dec 9 '14 at 14:16
  • I understand that, but how do i go about putting multiple suggestions for one person into a normalised table? – jellybean_232 Dec 9 '14 at 17:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.