[Solved] Relationship between tables in ms sql server [closed]

by


your table structure should be below

PatientTable
PatientId int Primary Key,
PatientName varchar(50),
EmailId varchar(50)
Password varchar(50)

TestTable
TestId int Primary key,
TestName varchar(50)

PatientTestTable
PatientId int FK(PatientTable)
TestId int FK (TestTable)

This way you can give relationship to two tables. you need to understand funamental of RDBMS.

1

solved Relationship between tables in ms sql server [closed]