There are many DBMS that can effectively support an EHR, I think the best DBMS will depend on the purpose of EHR, for open source system i recommend developer edition for example mysql, For commercial purpose Enterprise edition works well for example sql server