And there's another table for locations.
Note that they are categorized according to districts. (CO, GQ, KT) Each district has multiple towns/cities.
A taxi service may be providing their service in multiple districts. And one district may have multiple taxi services. Its sort of a many to many scenario.
I'm trying to connect the cab_services table with the locations table. But I can't figure out how to.
I would have done something like this if only one service was in on district.
But like I said before, a service can have many districts.
This would violate the 1NF.
I would want to be able to get results in a situation like say, if a user search using a Location name, he should get the cab services in that area.
What changes do I have to do in my database, table structure to accomplish this?
Please let me know if some part is confusing, I'll try my best to clarify it further. I'm pretty bad at explaining things. Thank you.
This post has been edited by nK0de: 24 June 2012 - 06:54 AM