AnsweredAssumed Answered

Creating a relational databse

Question asked by JoppeFierens on Feb 10, 2011
Latest reply on Feb 10, 2011 by JoppeFierens


Creating a relational databse


Good afternoon, 

I have a question about a specific database I need to create:

I will need :
a table with patients (patient number - initials - age )
a table with the medical history of each patient (patient number - additional data)
a table with the procedures (patient number - choice between 3 procedures - additional data)
a table which lists all the info from 1 specific procedure.

should I link the patient number of the patient table to all the other tables ? (one to many)
how do I create the link between procedure and patient (every procedure will be done once per patient)  ?

I appreciate your input,