table design structure

(i am not a developer so excuse me if this obvious)

i have data in the form

<foriegn_key> ,<data1>, <data2>, (<data3>, <data4>)

(<data3>, <data4>)
(<data3>, <data4>)
(<data3>, <data4>)
(<data3>, <data4>)
(<data3>, <data4>)
(<data3>, <data4>)

<foriegn_key> ,<data1>, <data2>, (<data3>, <data4>)

(<data3>, <data4>)
(<data3>, <data4>)

<foriegn_key> ,<data1>, <data2>, (<data3>, <data4>)

(<data3>, <data4>)

ie the amount of (<data3>, <data4>) can be anywhere between 2 and 30. most of the reports etc will be generte from the data 3 column.

what i am trying to figure is how to store these dataforms.

i am have some exposure to oracle and i think a nested table per foriegn_key or varrays are to possible solutions but what i should use

cheers

Nug Received on Fri Dec 16 2005 - 09:01:29 CST