OK, like I said, for a given ER model is necessary to make a SQLServer db.
here we have two entities:
Person and City with attributes:
Person (personID, name, height)
City (CityID, zipcode, cityname, population)
and relationship:
person -> born in -> City
person -> live in-> City
Can this be done in next way:
Person (#personID, name, height, $CityID, $place_of_birth_ID, $place_of_residence_ID)
City (#CityID, zipcode, cityname, population, #place_of_birth_ID,#place_of_residence_ID )
# - primary key
$ - foreign key