Creating a relational databse
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,