i am desiging database and i need answer.
for example i am getting flat file ,which contains pharmacy into and patient info
pharmacyid primary key
patientid primary key
now they dont have any relation between them,
i can have multiple record of patients from same pharmacy, that i need to store, so if there is pharmacyid is primary key, how can i store tha record.
similarly i can have multiple records for same patient from different pharmacy.
what should i do
please help me with design, what kind of relation i need to make,do i need to create third table