472,145 Members | 1,555 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,145 software developers and data experts.

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.

Aug 6 '10 #1
2 1168
32,499 Expert Mod 16PB

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 :

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
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.