This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: or more doctors. A doctor can only work in one hospital. Doctor is the parent and Patient is the child: One-to-many relationship. A doctor can have zero or more patients. A patient can only have one primary doctor. HOSPITAL HospitalID (Primary Key) HospitalName HospitalAddress HospitalPhone PATIENT PatientID (Primary key) PatientName PatientAddress PatientPhone DocID (Foreign key to Doctor) HospID (Foreign key to Hospital) DOCTOR DocID (Primary key) DocName DocAddress DocPhone HospID (Foreign key to Hospital)...
View Full Document
- Spring '10
- Physician, one-to-many relationship, primary doctor, Hospital Project Solution