473,396 Members | 1,789 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 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.

Thanks,
Mark
Aug 6 '10 #1
2 1227
NeoPa
32,556 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

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

Similar topics

1
by: rrohithr | last post by:
Hi programmers, Im new to this group and i am a beginner in c++ programming I need to get information about modifying a simple record in Turbo C++ with the usage of files.Hope you people can...
4
by: Skully Matjas | last post by:
I am using the following code (created by the wizard) to allow to bring my form to a particular entery. But when I edit the entery (ex: put new information into a blank cell), it puts that record...
1
by: Skully Matjas | last post by:
Thank you for getting back to me. I am very new at this so i didnot understand what you said, here i will give as much cetails as possible: 1) The combo box i am using is combox39 2) I imported...
2
by: Electricsuit | last post by:
I have a database that I use to track odometre readings. Several vehicles are tracked. As you can imagine, if the wrong vehicle is entered for the given mileage, it will through off reporting. I...
3
by: \Jane higgs via AccessMonster.com\ | last post by:
I have a database that gives me an error message everytime I get to a certain record. I tried going into the table and deleting that record, but it still errors out. I get the "Microsoft Office...
5
by: Don Sealer | last post by:
I've got a validation rule that says something like =xx or xxx or zzzz. Though I may not have described it well it does work fine and that is really not my question. Here's what I'd like to do....
1
by: Roberto La Forgia | last post by:
Hi all, there is a utility o procedure to recovery deleted record from a Access table (versione 2002/2003) ? Thanks in advance Roberto
6
by: serge calderara | last post by:
Dear all, I have read that ASP.NET does double user input validation of control when they are place on the page. Once on teh client side and again from server side right ? Could explain how...
4
by: AMBLY | last post by:
Hi Hope you can help me with this I run Access2000 on XP Form has 3 fields: cboSTATUS - which can be set via Limited value List A B or Complete. Default is set as A. cboTHIS - which can...
2
by: Chad Lupkes | last post by:
Hi everyone, I need help with a simple form validation. The form I'm using has been the target of some spammers, and I'm wondering what else I can do. I have a very simple validation, checking...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

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.