This is the first Topic I've posted at (the cool) daniweb site so go easy on me.
I want to put the cities of England with all their districts in a database. I can think of the following two ways to do this:
cities (cityID, cityName)
districts (districtID, cityID, districtName)
london (districtID, districtName)
manchester (districtID, districtName)
liverpool (districtID, districtName)
If I go with the 1st way - the districts table will have a lot of records/rows. If I go with the 2nd - I'll have to create a table for each city. I have very little experience with databases so I'd want to ask you which way is better.
Any help would be fantastic.