To Gain the better Performance of Sql Server.Generally we Go for the data to be Normalized means that splitting up the tables into several tables with some specific rules like primary key and foreign key references.
To find out the Foreign key relationships in between the tables of a database
Open the QueryEditor
---> use [database]
select * from sys.foreign_key_columns