Tables as relations in ER diagrams
- by Richard Mar.
Assume I have the following tables (**bold** - primary key, *italics* - foreign key):
patient(**patient_id**, name)
disease(**disease_id**, name)
patient_disease(**p_d_id**, *patient_id*, *disease,_id* )
I want to draw the ER diagram for this. My idea is to make two entities, one for patient and one for disease, then make a n-to-n relation between them, with p_d_id as its attribute. Is that how it's supposed to be?
