Create multiple tables or just one

Question

What is the best approach in this case:
Create a single address table (id, country, city, boulevard, street)

or do 3 as follows:

country (id, country)
cities (id, city, id_country)
address (id, id_country, id_city, boulevard, street)

or

country (id, country)
cities (id, city, id_country)
address (id, id_city, boulevard, street)

-1

Youssef Jun 12 '14 at 11:51

2 answers

, , . . .

, . E- . .

, , , , , , . , .

, .

+1

Gangnus 13 . '14 8:12

Aleks · Accepted Answer · 2014-06-12T12:09:21+0000

It is not possible to answer reliably since there is not enough information. The answer depends on your requirements.

, , / -, .

"" ( , ..) , . ( , , , , ).

- . , , (, ) .

, /. , .