replicating master tables mapping in transaction tables

Posted by NoDisplay on Stack Overflow See other posts from Stack Overflow or by NoDisplay
Published on 2012-04-11T05:07:47Z Indexed on 2012/04/11 5:28 UTC
Read the original article Hit count: 132

I have three master tables for location information

  1. Country {ID, Name}
  2. State {ID, Name, CountryID}
  3. City {ID, Name, StateID}

Now I have one transcation table called Person which hold the person name and his location information.

My Question is shall I have only CityID in the Person table like this:

Person {ID, Name, CityID}'

And have view of join query which give me detail like "Person{ID,Name,City,State,Country}"

or Shall I replicate the mapping

Person {ID, Name, CityID, StateID, CountryID}

Please suggest which do you feel is to be selected and why? if there is any other option available, please suggest.

Thanks in advance.

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about database