This is a maintenance project on an existing test database. I need a utility program that will clean up the database of duplicate values and test for relational integrity. I have provided a test database; however, this utility will be run against the production database after the program is verified.
The main table is the Drugs table. Every other table, with the exception of one, is related to it by the key GenericName. There is a total of 12 tables in this database.
The first task is to have each "child table's" Drug foriegn key tested to make sure that it exists in the parent table Drugs. If not, that record needs to be deleted.
The second task is to remove duplicate key values so if there is not a compound primary key defined in the table, this will be able to be accomplished.
The one table that is a little different is the Drug_Instructions table. It will be linked to from the Drug_StrengthVehicle table. Therefore, the same tasks are performed as before except using the Drug_StrengthVehicle table as the parent table.
I'll provide more information upon acceptance of the job.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).
This will need to run on a Win32 platform against an Access 2000/XP database. I STRONGLY prefer the program be coded in VB6. However, I will consider accepting a program in either VB.Net or C#.