I have project on soundex to do for my study course submission. So if such project is already there with you then I will purchase outright. **Here programming language ,format of database doesn't matter**. But I was making in php/mysql. **But you can do anything you are comfortable with**.
The project is simple.
I have a database with 16 fields in each record (presently in mysql). The record contains soundexname1,soundexname2,soundexname3,soundexname4,soundexname5 ,name1,name2,name3,name4,name5,address1,address2,phone,date_of_birth,photograph,remarks.
Now I require to use an application to search the database on the soundex criteria of input either input by user manually, or multiple search names supplied in form csv or txt and bring out the match records on screen as well as could be saved in editable format. The names for search string has to be converted to soundex before matching database.
The matching criteria should be soundexname1 **OR** soundexname2 **OR** soundexname3 **AND** soundexname4 **OR** soundexname5 **AND** date_of_birth(in years)[if available] **AND** address2[if available]
following input can be made by user=>
1. name1,name2,name3,name4,name5,age_in_years,address2
2. name1,name2,name3,name4,name5,,address2
3. name1,name2,name3,name4,name5,,,
[login to view URL],name2,,name4,name5,age_in_years,address2
[login to view URL],,,name4,name5,age_in_years,address2
4 name1,name2,name3,name4,,age_in_years,address2
Output will be
name1,name2,name3(if available),
name4,name5(if available),
address1(if available),
address2(if available),
phone(if available),
date_of_birth(if available),
photograph(if available),
remarks(if available).
The output has to be formatted to look good on screen and print with an option to save the output.
The output should be most closed match on top to less close match at bottom