I have a very simple Question and i know experts here will give me an instant reply.
I have a table UserInfo withe the following columns
And an another Table Country with the following columns
Will it be advisable to add a foreign key constraint to UserInfo table On (CountryID) column which points to CountryID of Country table
If Yes , why?
If Not , Why not? and what is the alternate way, or there should be no relation between the two.
All replies are deeply appreciated
New SQL Server Programmer