Does this medical database look correct? I'm pretty new to databases and I'm trying to create some schemas.

I've been working away at this one for a while, but I can't help feeling that it doesn't look right.

Essentially I have the following situation:


A given medical trial (of which there can be many) takes place in a varying number of medical centres.
Each centre has patients and practitioners.
Practitioners and patients have a consultation, and data is created.


It seems simple enough, but I've a feeling I've made a mess of it. The resultant database will be MySQL if that's relevant.



Does that look right?
As a very basic structure it is close.

The one glaring issue is that the relationship between trial and centre is the wrong way around.  You should have a CentreId on the Trial table, as I believe there can by multiple trials from 1 centre and not vice versa.

Also you may want to consider adding some extra details to Centre like name etc.

Lastly, the Patient -> Trial relationship may well be a many-to-many relationship and thus you  would need to add a table to encapsulate this relationship.