I'm working on a ERD with mysql workbench, and i have a little question.
I have a Database with this tables:
I want to store the address of the company with all the data (country, state, and cuty). The relation between thos tables are:
- country - id - name - state - country_id - name - city - state_id - name
My question is, what is better, put te relation of the company_addres just with the city?.
- company_address - city_id - company_name - more_fieds
Or put all FK of the location tables?
- company_address - city_id - state_id - country_id - company_name - more_fields
Wich one is the better way?. Or wich one will slow down the performance. Thanks!