please suggest a design scheme for my problem

[hotmalepiyush]

there is a set of data (some 15 fields) related to some 250 co.s which NSE releases everyday. this data is contained in 3 different tables which is made available at the end of each working day.

i need to make a database from this. how can i incorporate all these data in three different table for 1 mnths period efficiently.

two ways i have thought is:
1. have different field names
2. have different tables for different days

is there any better way?

thanx for ur time,
piyush

 

[neileg]

It would have helped if you described the structure of the three tables. But creating new tables is almost certainly the wrong way to tackle this - you would use queries instead.

 

[georgedwilkinson]

Are you going to be using the data for processing real-time or just for reporting purposes. The answer will be different for each of those.

And, as Neil said, we'll need more information to answer.

 

[hotmalepiyush]

i won't be using any real time data.. this is just for reporting purpose.. plz help

 

[neileg]

As I said before:

It would have helped if you described the structure of the three tables.