Re: storing survey answers of different data types

Bob Badour wrote:
> paul c wrote:
>

>> Bob Badour wrote:
>>
>>> Joe Thurbon wrote:
>>
>> ...
>>
>>>> Just wondering, if one of the requirements for a system included
>>>> something like 'Be able to list all questionnaires', would
>>>> you still consider one-table-per-questionairre a reasonable design?
>>>
>>>
>>> Absolutely. It's a simple query from the system catalog.
>>> ...
>>
>> How do you tell the 'questionnaire' tables from the other tables?

Well, it's not me, the part-time mystic, I'd like to know how a system catalog/catalogue can signify the difference. Seems to me that the system becomes the app, which would be okay by me. 'Catlog', all due respect to Codd, is not a very useful word. What's the point of ddl when dml could suffice? I think it is baggage, mostly due to the physical limits of thirty or more years ago. DBMS's would be different today if not for those, and thirty years from now, most developers won't even know and a few might start to think like the Mott's Clamato man. So there! Received on Fri Apr 24 2009 - 06:05:00 CEST