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
AI_FUNCTION_SUBCATEGORY_MAPPER
COLUMN_NAME
|
DATA_TYPE
|
LENGTH
|
FID
|
numeric
|
NULL
|
FNAME
|
varchar
|
500
|
SID
|
numeric
|
NULL
|
SNAME
|
varchar
|
500
|
Hemen Parekh
