erDiagram COUNTRY ||..o{ CITY : contains COUNTRY { string(3) countrycode PK string name_country numeric population_country integer capital FK } CITY { integer id PK string(3) countrycode FK string name numeric population } CITY |o..o| COUNTRY : is-capital