JOBGUIDEDISPLAY

29 June 2007

JOBGUIDEDISPLAY

DATABASE : INTERVIEW_QUESTIONS

TABLE: JOBDESCRIPTION

WEBSITE : http://jobguide.thegoodguides.com.au/

THE JOB DESCRIPTIONS WERE DOWNLOADED FROM THE WEBSITE

INSERT A STAR IN THE TOP TEXTBOX AND PRESS THE ADJOINING BUTTON

SELECTING THE RESPECTIVE JOB-DESCRIPTIONS WILL 

REVEAL THE DETAILS

Hemen Parekh

IT-KEYWORDS-FINALIZE

29 June 2007

IT-KEYWORDS-FINALIZE

DATABASE :

SQL

INTERVIEW_QUESTIONS

DATATABLES

IT-HIGHLIGHTED-KEYWORDS

IT-KEYWORDS-EXCEL

IT-FUNCTIONLIST

ACCESS FILE :

\\Sourabhk\d_sourabh\Desktop Data\desktopdata\IT-FUNCTIONS-WORK-DONE\COMBINED-KEYWORDS\wordsFromResumes.mdb

FOLDERS ACCESSED  -

D:\isys index\ISYS-INDEXING-LOG\FINAL-EXCEL-FILES\hcp-sir-finished-indexing

NOW STORED ON EXTERNAL DRIVE – F:\ISYS-RELATED\ISYS INDEX

PURPOSE :

TO FINALIZE THE IT KEYWORDS

Hemen Parekh

PRINT-KEYWORDS

28 June 2007

PRINT-KEYWORDS

DATABASE - FUNCTION_KEYWORDS_TEMP

PURPOSE OF TOOL

THE TOOL WAS CREATED TO HIT GOOGLE SETS AND GET MATCHING KEYWORDS FOR THE VARIOUS KEYWORDS THAT ARE PRESENT ON THE VARIOUS NON IT FUNCTIONS

THIS IS USEFUL TO FILL THE “IIT_KEYWORDMATCHES” TABLE

THIS TABLE IS USED IN KARMASCOPE WHEN KEYWORDS ARE CLICKED TO SHOW THE MATCHING KEYWORDS IN IIT

PRESENTLY THE IT FUNCTION KEYWORDS ARE NOT FILLED IN THE 

KEYWORDMATCHES TABLE

IIT_KEYWORDMATCHES

COLUMN_NAME	DATA_TYPE	LENGTH
PKID	decimal	NULL
FUNCTIONID	decimal	NULL
FUNCTIONNAME	varchar	50
KEYWORD	varchar	50
KEYWORDMATCHES	varchar	50

Looking at the code and the various modules, one can understand how to introduce new functions and keywords and get the matching keywords into the sql database.

Most useful – from New Vitthal Functions Key words. vb

This module can be automated also by calling the button event at the list box. Selected index change event.

Hemen Parekh

PERSONALITY-SOFT-SKILLS-QUESTIONS

28 June 2007

PERSONALITY-SOFT-SKILLS-QUESTIONS

PURPOSE OF THE TOOL

ONE TIME TOOL

TO CAPTURE THE SOFTSKILL QUESTIONS

FROM --------- JOBBANKUSA

http://www.jobbankusa.com/interview_questions_answers/free_samples_examples

DATABASE

soft-skills-questions.mdb

DESCRIPTION

THE LINKS (55) WERE DOWNLOADED ON AN MDB

THE LINKS WERE LOOPED THROUGH THE WEBBROWSER AND THE QUESTIONS WERE TAKEN INTO THE MDB

Hemen Parekh

GURUNET BUSINESS RULES

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

RESUME VIEWER FINAL

25 June 2007

RESUMEVIEWERFINAL

PROJECT DESCRIPTION

IT IS A PROJECT TO VIEW THE RESUMES FROM MONSTER.

POINTS

IT CAN GET A DETAILED DESCRIPTION OF ALL THE AVAILABLE RESUMES ON THE DATABASE.

USERS GET LOGIN.

USERS HAVE SEARCHES MADE IN GURU GRAB.

RESUMES ARE STORED IN THE SQL DATABASE "RESUME".

THE SQL-DIAGRAM OF RESUME DATABASE IS PRESENT IN HTML AND DOC FORMAT TO VIEW IN THE FOLDER "RESUME-DATABASE-DIAGRAM".

RESUMES CAN BE SEARCHED IN THE FOLLOWING MANNERS

1.CONSULTANT WISE

2.DATE WISE

3.CLIENT WISE

4.POSITION WISE

BY TWEAKING THE SEARCH PARAMETERS THE RESULTS CAN BE SEEN IN THE TOP GRID  (GRID A)

DATABASE AND TABLES

DESIGNATION_LIST

COLUMN_NAME	DATA_TYPE	LENGTH
ID	int	NULL
DNAME	nvarchar	255
STATUS	varchar	1

MONCATEGORYROLE

COLUMN_NAME	DATA_TYPE	LENGTH
CATEGORYID	int	NULL
ROLEID	int	NULL
ROLENM	varchar	50

MONRESUME

COLUMN_NAME	DATA_TYPE	LENGTH
PKID	numeric	NULL
PROCESSID	numeric	NULL
EMAILID	varchar	75
RESUMEHTML	text	2147483647
RESUMETEXT	text	2147483647
PROCESSDATE	datetime	NULL

MONSEARCH

COLUMN_NAME	DATA_TYPE	LENGTH
PKID	numeric	NULL
SEARCHNAME	varchar	500
KEYWORDNAMES	varchar	500
MINEXP	varchar	5
MAXEXP	varchar	5
MINSAL	varchar	50
MAXSAL	varchar	50
INDUSTRYIDS	varchar	500
LOCATIONIDS	varchar	500
CATEGORYIDS	varchar	500
ROLEIDS	varchar	500
DEGREEIDS	varchar	500
DEGREESPECIALIDS	varchar	500
IIMS	bit	NULL
IITS	bit	NULL
TOP_UNIVERSITY	bit	NULL
TOP_BUSINESS	bit	NULL
TOP_ENGG	bit	NULL
RESUMERANGEIDS	varchar	500
COMPANYNAMES	varchar	500
PROCESSED	char	1
EMAIL_ID	varchar	75
SEARCHDATE	datetime	NULL

USERLIST

COLUMN_NAME	DATA_TYPE	LENGTH
PKID	numeric	NULL
EMAILID	varchar	70
USERPASSWORD	varchar	70
PROCESSDATE	Date time	NULL
RESUMENUMER	numeric	NULL

KEYWORD_LIST

COLUMN_NAME	DATA_TYPE	LENGTH
ID	numeric	NULL
KEYWORD	varchar	500
WEIGHT	numeric	NULL

Hemen Parekh