I need a table City for my database model, I have two possible designs:
City:
id_city PK
city
country
City:
city
country
PRIMARY KEY(city, country)
I am wondering what would be more appropriate. In case 1 I could insert a city twice with a different primary key...Right? The case two appears to be more correct...isn't? What you recommend me?