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