Hi Friends,
                                              Even as I launch this today ( my 80th Birthday ), I realize that there is yet so much to say and do.
                                                  There is just no time to look back, no time to wonder,"Will anyone read these pages?"
                                       With regards,
                                       Hemen Parekh
                                       27 June 2013

Tuesday, 26 June 2007

QUESTION_BANK_TOOL

26 June 2007

QUESTION_BANK_TOOL

ONE TIME USE TOOL

this tool was created to analyze the question that were downloaded from all interview website

the SQL database is "INTERVIEW_QUESTIONS "
to refer to their database diagram go to the "INTERVIEW_QUESTIONS_DATABASE_DIAGRAM" FILE

MODULE 1

THE TOP TEXTBOX KEEPS TRACK OF THE LAST FUNCTION WORKED UPON

IT SAVES THE LAST FUNCTION WORKED UPON IN A STATUS FILE (TEXT FILE)

ON STARTING THE TOOL AGAIN - THE STATUS FILE IS READ AND THE SPECIFIC FUNCTION CAN BE OPENED BY THE USER

Y - ACCEPT

D - REJECT

M - MODIFY (ROUND TWO)

THE RELATED TABLE IS - AIQUESTIONS

AIQUESTIONS

 

COLUMN_NAME
DATA_TYPE
LENGTH
FID
numeric
NULL
SID
numeric
NULL
TID
numeric
NULL
TNAME
varchar
500
QID
numeric
NULL
QUESTION
varchar
500
UPDATED
varchar
1

CHANGES MADE TO THE SPECIFIC QUESTIONS ARE REFLECTED IN THE SQL DATABASE

MODULE 2

MAPPER-ADD/DELETE

THE MAPPER FUNCTIONALITY IS TO CONNECT THE PRIMARY FUNCTIONS TO THE SUB CATEGORIES

THE MAPPING IS DONE ON THE TABLE  

AI_FUNCTION_SUBCATEGORY_MAPPER


AI_FUNCTION_SUBCATEGORY_MAPPER


COLUMN_NAME
DATA_TYPE
LENGTH
FID
numeric
NULL
FNAME
varchar
500
SID
numeric
NULL
SNAME
varchar
500


Hemen Parekh

No comments:

Post a Comment