In one address I have more values: city, street, civic number, postal code, province, common code. Many data. In a masterpiece how best to handle them? Some recommend putting all the caps in a separate table with id_cap, all the ways, and all the cities ... so many separate tables joined at a later time. It would be nice that by entering an address I would suggest possible combinations or inserting the city to automatically populate the possible fields. Certainly a way can be common to more cities ... so how do you suggest tackling the issue?