Project Name: MEDICAL SURVEY QUESTIONNAIRE MEMBERSHIP DATABASE
Individual Assignment
Client Tools: Visual Basic 6.0, Oracle, Developer 2K, 8i, SQL & PL/SQL, Access VBA
Role: Client/ Server Software Developer
Duration:
Project Description: Developed a Windows based database application that accepts answers from 30 survey questions and stores them into database. Users will be able to search on 10 provinces in Canada and use an active X control to search on 10 provinces in Canada and query system and extract statistical report data and e-mail to a list of recipients in a pre-selected province at pre-determined intervals without user selection or intervention. Since there are over 50,000 members in all 10 provinces, automatic selection and e-mailing of current statistics is critical in the success of the system performance. Designed physical and data migration structure of database. Developed client side end-user interfaces and reporting and statistical presentation gr