I have three tables tblpatient, tblContacts, and tbltelephone. They are structured like this:
tblpatient tblcontact tbltelephone
patientID PK contactID PK phoneID PK
patient account number PatientID FK pateintID FK
patientfirstname Contactfirstname ConatctID FK
patientlastname ConatctLastName
DOB
address
city
state
zip
My question: Is there a more efficient way of doing this?
tblpatient tblcontact tbltelephone
patientID PK contactID PK phoneID PK
patient account number PatientID FK pateintID FK
patientfirstname Contactfirstname ConatctID FK
patientlastname ConatctLastName
DOB
address
city
state
zip
My question: Is there a more efficient way of doing this?
