Re: table design structure

sorry for being a bit of novice in design here but this is that data as i receive (in text) . what i am trying to figure out is what type of table varible etc a database should use to store data like this., there is no ddl, no constraints and i can do anythng i want (at the moment). The issue of getting the data into a database, i will resolve later probubly with sed, awketc.

it is a design theroy question , ie how to design a database to store data in this format.I personally would use oracle table with a varray for data3/4 columns, but not a designer or a developer so no idea if theat is the correct way to go.

i added some sample data try and to simplify my problem:

Maths , 2005 , sue, 95%

,john, 87%
,peter, 62%
,kate, 53%

english , 2005 , john, 85%

,paul, 43%
,kelly, 62%
Received on Mon Dec 19 2005 - 07:46:52 CST