My First Database part II

Hackney

Registered User.
Local time
Today, 14:35
Joined
Mar 1, 2006
Messages
12
I am having more trouble with the old database I am trying to make.

Can someone have a look if I attach it?

I don't think the ID fields in each of the three tables are working togehter.

Shouldnt they be the same ID number of each record for that person across the three tables?

Thanks.
 

Attachments

Do you think there is any need to have seperate table when the relation ship is 1:1?
 
Not the right way, as I think you realise. The current set up could all be in one table but it would still be wrong.

The diagnosis table is not right. I see you have a many to many relationship between diagnosis and client. You need a table that lists all the potential diagnoses with a DiagnosisID. Then you need a junction table. For each diagnosis for a client you need a record in this table that holds the ClientID and the DiagnosisID. Do a search in these forums for many to many and junction tables.

You could do the same for the co-morbidity, or I suspect you could you could combine the co-morbidity categories with the diagnoses table with an extra field to indicate co-morbidity or diagnosis. You'd just need one junction table then.
 

Users who are viewing this thread

Back
Top Bottom