I'm working with XML extnder..and am storing data throught XColumn.
It seems it is impossible to store a documnet which has a DTD like

<!ELEMENT ARTICLE (CHAPTER+)>
<!ATTLIST ARTICLE ARTICLE-ID KEY #REQUIRED>

<!ELEMENT CHAPTER (SECTION+)>
<!ATTLIST CHAPTER CHAPTER-ID KEY #REQUIRED>

<!ELEMET SECTION (TEXT+)>
<!ATTLIST SECTION SECTION-ID KEY #REQUIRED>

<!ELEMENT TEXT (#PCDATA)>

I need to store all the elements and attributes in side-tables(I can very
well do it with XCollection, but I need to do with XColumn becuase of
some reasons.


Now multi_occurence attribute in DAD file will have value "YES" for
CHAPTER-ID as well as for SEcTION-ID. so I cannot store both of these
together in the same tables. Thus it is a lossy decomposition, as I cannot
know after decomposition which section belong to which chapters. becuase I
need to have a table in which there are columns for both chapter-id and
section-id telling which sections occur in which chapter. I don't think it
is possible because multi-occurence attribute for both of these is "YES".

Is there a way out, so that it is a lossless decomposition.
Thanks in advance...

p.s: I think I'm somewhat misinterpreting multi-occurence attribute. Can
anyone clarify how it is used.

Sincerely
-Nitin Khandelwal
Computer Science and Engineering
University of Waterloo