Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.cw.net!cw.net!news-FFM2.ecrc.de!newsfeed.vmunix.org!news.cs.univ-paris8.fr!proxad.net!216.239.36.134.MISMATCH!postnews.google.com!g47g2000cwa.googlegroups.com!not-for-mail
From: doug.fulton@gmail.com
Newsgroups: comp.databases.theory
Subject: table design structure
Date: 16 Dec 2005 07:01:29 -0800
Organization: http://groups.google.com
Lines: 38
Message-ID: <1134745289.403813.324450@g47g2000cwa.googlegroups.com>
NNTP-Posting-Host: 213.205.154.20
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1134745296 30338 127.0.0.1 (16 Dec 2005 15:01:36 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 16 Dec 2005 15:01:36 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8) Gecko/20051111 Firefox/1.5,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: g47g2000cwa.googlegroups.com; posting-host=213.205.154.20;
   posting-account=MfPTpwwAAABfJdNjbJLyh1RW_yBSJ8xJ
Xref: dp-news.maxwell.syr.edu comp.databases.theory:35216

(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