thank u all for your help...i have tried to create a relationship but have run into an error. please help. thank you.

k i have created two tables as shown in the image

each record in the 'institute table' will have multiple related records in the student.

the sql statment i used to create the foreign key relationship is this:

alter table student add constraint fk_student_institute foreign key (student_institute) references institute(institute_name)

and the error is this:

Msg 547, Level 16, State 0, Line 1

The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "fk_student_institute". The conflict occurred in database "sims", table "dbo.institute", column 'institute_name'.