What kind of queries are you planning to run on this data? Your answer will help us decide whether this is better to have in few or many tables.
Also of relevance are the normal forms (http://en.wikipedia.org/wiki/Database_normalization) On Tue, Jun 12, 2012 at 12:39 AM, Hassan Alnatour <halna...@gardeniatelco.com> wrote: > Dear ALL , > > I am creating an application with is a reference about some city's , so the > website has some city's , every city has some areas and every area has > some other stuff ,it all up to 6 levels , so what is the best was to do > that in the database ? > > i am thinking about making every level as a separate table.. > > > Best Regards, >
