I am working on a scenario like this : I have an employee table which has columns like this
Also I have a Joining_Vital table
How can I link this two tables ? As I guess it would be a many-to-one relationship(as one joining_vital can contain many employees) from Employee table to Joining_Vital table
I cannot establish the foreign key on the Employee_ID column of the Employee table. I am naive to Database thing Could you guys please help me out how to do it? I cannot figure out the scenario Please explain me out. Am I missing anything here?