This tool for search the results in DB and give the output to front end.

There are lot of functionality!

1.Search(10 seperate search functionality) - can be done through 10 to 15 tables

2.Add - Can be done through near 20 tables

...

Def, I will go with different Stored procedure for each functionality

Please let me know if you can give more input.

REgards,

Tony