Yiannis_cy
Registered User.
- Local time
- Yesterday, 20:06
- Joined
- Jul 29, 2010
- Messages
- 16
Guys....i need help
I am building a database for a doctor and i have the following tables
- Basic Patient information
- Patient's mother history
- Patient's father history
- Patient's brother history
- Patient's sister history
- Patient's children history
I use the above tables because the doctor wants to complete a form asking the patient if he had any previous problems in the family and who had the problems.
My problem is that i am confused on building the relationships between these tables.
can someone help me as to the primary and foreign keys i need to use and also how to build the relationships.
As a newbie i will need detailed steps
thank you people
I am building a database for a doctor and i have the following tables
- Basic Patient information
- Patient's mother history
- Patient's father history
- Patient's brother history
- Patient's sister history
- Patient's children history
I use the above tables because the doctor wants to complete a form asking the patient if he had any previous problems in the family and who had the problems.
My problem is that i am confused on building the relationships between these tables.
can someone help me as to the primary and foreign keys i need to use and also how to build the relationships.
As a newbie i will need detailed steps
thank you people