Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

A better way to set up tables

Status
Not open for further replies.

augie0216

Technical User
Jul 30, 2006
1
US
I have a table consisting of patient information I have a separate table with the patient contact in case of emergency names I have a third table called telephone which is set up like this:

phoneID is the PK for tbltelephone
patientID is the PK for tblPatient and FK for tblcontact and tbltelephone
contactID is the Pk for tblContacts and FK for tbltelephones.

I was wondering if in someone's opinion there is a better way to structure these tables.
 
Why not store everything on a single table? The only reason I wouldn't would be if multiple patients have the same emergency contact and phone number, which would probably be unlinkely.

Also, check out the naming conventions faq:
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top