469,317 Members | 2,033 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,317 developers. It's quick & easy.

Help with database validation for electronic medical record

Our group purchased the code of an "EMR" program that was a flat file database in access.
We contracted with a company to make make the database relational (SQL) and to add a few features. We now have our contractor saying the database/program is ready to go, but our IT department (which was hired just recently as this process if "finished" says it has not been validated. I am an MD with minimal database experience. What questions should I be asking. I do no want to throw our new product away, but I also can't use it if it is not structurally sound.

Thanks,
Mark
Aug 6 '10 #1
2 1129
NeoPa
32,173 Expert Mod 16PB
Mark,

I can only suggest that you test the solution against your own specification. If no official specification was shared then determine what you were expecting from the product, including the extra bells and whistles requested specifically, and ensure that the software does what you expect.

Your testing is unlikely to find all the bugs straight off. Go as far as you can in the time allowed. If you find any bugs, be very clear when speaking to the developers which category the problem falls within :
Bug
Enhancement

If it's something you wish you'd asked for then it's the latter. If it's something specified, then it's the former.

Good luck and welcome to Bytes!
Aug 6 '10 #2
Jerry Winston
145 Expert 100+
I know you came to this site for technical advice and I don't want you to think I'm trying to send you away empty handed when I say this. You don't need to ask the technical questions, I'm sure your techs are chomping at the bit to get a hold of this new app and see if it's up to snuff. I agree with NeoPa, I'd advise you to make sure the application meets the requirements for your industry such as data retention, HIPPA, or not storing Credit card information. I would suggest you ensure it does what you need it to do from a business stand point.

However, if you just want to ask good tech questions, ask about security/authentication, data encryption and protective measures against SQL injection attacks.
Aug 10 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by rrohithr | last post: by
1 post views Thread by Skully Matjas | last post: by
2 posts views Thread by Electricsuit | last post: by
3 posts views Thread by \Jane higgs via AccessMonster.com\ | last post: by
5 posts views Thread by Don Sealer | last post: by
1 post views Thread by Roberto La Forgia | last post: by
6 posts views Thread by serge calderara | last post: by
2 posts views Thread by Chad Lupkes | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.