Search results

Guys, Many thanks for you replies, I have my data by country and region as well (I should have asked you for a help before I started doing the database ). Country and region are in the separate table (hopefully there should be no overlapping between the regions I selected, I used standard...

Thanks for your reply, I thought to use number in addition to the source column to avoid spelling mistakes in the key field. I agree that it makes sense to have a unique number for every source (thanks for this!), however it is probably better to restrict it to a particular country, thus not...

Dear All, I am developing a world energy database. All elements in the structure seem logical but one. I had to introduce two artificial columns to distinguish between sources, from which data come (I try to keep all the data in the raw format). This is how my table looks like (total of 8...