I would like it linked so everything ties into each other.
patient table links to mother table and death table
death table not sure if it needs to link to mother table as the death relates to the patient and not the mother.
mother table links to lifestyles.
Do I need a FK of patientID in every table to link it all back to the master table of patient or will having the following be ok...
patient ID
-----
motherID
patientID
-----
deathID
patientID
-----
lifestyleID
motherID
Then you can link togehter in a query to pull results out?
patient table links to mother table and death table
death table not sure if it needs to link to mother table as the death relates to the patient and not the mother.
mother table links to lifestyles.
Do I need a FK of patientID in every table to link it all back to the master table of patient or will having the following be ok...
patient ID
-----
motherID
patientID
-----
deathID
patientID
-----
lifestyleID
motherID
Then you can link togehter in a query to pull results out?