emilybartholomew
Technical User
I was wondering if anyone could give me some general advice on this issue. I am creating a database to hold prices of electricity. The table I have so far is (basically) as follows:
Timestamp
Location
Price
However, these prices are given both by zone (geographical area) and by generator. Should I keep all these prices in ONE table (with fields Timestamp, Location_code, Price) or in TWO tables, to separate the zoanl and generator data?
Timestamp
Location
Price
However, these prices are given both by zone (geographical area) and by generator. Should I keep all these prices in ONE table (with fields Timestamp, Location_code, Price) or in TWO tables, to separate the zoanl and generator data?