Summary: 35 methods with SQL local invocations, 9 methods mixing local and delegated SQL invocations, and 44 methods with only delegated SQL invocations.
This method implements the following db-related operations:
- It inserts values for the first 2 columns into table AGENTTABLE
- It drops the TABLE AGENTTABLE
- It creates the table(s) AGENTTABLE
This method implements the following db-related operations:
- It queries the table(s) USERRECORD
- It inserts values for the first 2 columns into table YOUTH
,
- It inserts values for the first 14 columns into table USERRECORD
,
- It inserts values for the first 9 columns into table JOB
,
- It inserts values for the first 4 columns into table INVESTMENT
,
- It inserts values for the first 3 columns into table EDUCATION
,
- It inserts values for the first 3 columns into table EMPLOYMENTSTAT
Some constraints that should be taken into the account are the following:
- Make sure the strings to be stored in EDUCATION do not overflow the varchar limits: 50 (EDUCATION, EDUENROLL)
- Make sure the strings to be stored in EMPLOYMENTSTAT do not overflow the varchar limits: 50 (EMPLOYMENTSTAT, UNEMPLOYMENTREASON)
- Make sure the strings to be stored in JOB do not overflow the varchar limits: 50 (WORKCLASS, UNIONMEMBER)
- Make sure the strings to be stored in USERRECORD do not overflow the varchar limits: 50 (TAXSTAT, BIRTHCOUNTRY, NAME, FATHERORIGIN, SEX, MOTHERORIGIN, CITIZENSHIP, MARITAL, RACE), 100 (DETAIL, HOUSEHOLDDETAIL), 5 (ZIP)
- Make sure the strings to be stored in YOUTH do not overflow the varchar limits: 50 (PARENTS)
- When inserting into table EDUCATION, make sure the referential integrity imposed by attribute(s) SSN is accomplished. The foreign keys in the table are the following: (SSN userrecord.SSN)
- When inserting into table EMPLOYMENTSTAT, make sure the referential integrity imposed by attribute(s) SSN is accomplished. The foreign keys in the table are the following: (SSN userrecord.SSN)
- When inserting into table INVESTMENT, make sure the referential integrity imposed by attribute(s) SSN is accomplished. The foreign keys in the table are the following: (SSN userrecord.SSN)
- When inserting into table JOB, make sure the referential integrity imposed by attribute(s) SSN, INDUSTRYCODE, OCCUPATIONCODE is accomplished. The foreign keys in the table are the following: (SSN userrecord.SSN), (INDUSTRYCODE industry.INDUSTRYCODE), (OCCUPATIONCODE occupation.OCCUPATIONCODE)
- When inserting into table YOUTH, make sure the referential integrity imposed by attribute(s) SSN is accomplished. The foreign keys in the table are the following: (SSN userrecord.SSN)
This method implements the following db-related operations:
- It queries the table(s) USERRECORD
- It deletes rows from table(s) YOUTH
,
- It deletes rows from table(s) INVESTMENT
,
- It deletes rows from table(s) EDUCATION
,
- It deletes rows from table(s) MIGRATION
,
- It deletes rows from table(s) JOB
,
- It deletes rows from table(s) USERRECORD
,
- It deletes rows from table(s) EMPLOYMENTSTAT
This method implements the following db-related operations:
- It queries the table(s) JOB, EDUCATION
This method implements the following db-related operations:
- It queries the table(s) EDUCATION
This method implements the following db-related operations:
- It queries the table(s) JOB
This method implements the following db-related operations:
- It queries the table(s) INDUSTRY
This method implements the following db-related operations:
- It queries the table(s) INDUSTRY
This method implements the following db-related operations:
- It queries the table(s) OCCUPATION
This method implements the following db-related operations:
- It queries the table(s) OCCUPATION
This method implements the following db-related operations:
- It queries the table(s) JOB, USERRECORD
This method implements the following db-related operations:
- It queries the table(s) USERRECORD
This method implements the following db-related operations:
- It queries the table(s) ZIPTABLE, JOB, USERRECORD
This method implements the following db-related operations:
- It queries the table(s) ZIPTABLE
This method implements the following db-related operations:
- It queries the table(s) JOB, INVESTMENT
This method implements the following db-related operations:
- It queries the table(s) USERRECORD, INVESTMENT, EDUCATION, JOB
This method implements the following db-related operations:
- It queries the table(s) EDUCATIONMAP
- It inserts values for the first 2 columns into table EDUCATIONMAP
- It drops the TABLE EDUCATIONMAP
- It creates the table(s) EDUCATIONMAP
This method implements the following db-related operations:
- It queries the table(s) EDUCATION
This method implements the following db-related operations:
- It queries the table(s) JOB
This method implements the following db-related operations:
- It queries the table(s) USERRECORD
This method implements the following db-related operations:
- It queries the table(s) ZIPTABLE
This method implements the following db-related operations:
- It queries the table(s) ZIPTABLE, USERRECORD, JOB
This method implements the following db-related operations:
- It queries the table(s) ZIPTABLE, USERRECORD, JOB
This method implements the following db-related operations:
- It queries the table(s) ZIPTABLE, USERRECORD, EMPLOYMENTSTAT, ZIPTABLE, USERRECORD
This method implements the following db-related operations:
- It queries the table(s) USERRECORD, EDUCATION
This method implements the following db-related operations:
- It queries the table(s) USERRECORD, JOB, INVESTMENT
This method implements the following db-related operations:
- It queries the table(s) USERRECORD
This method implements the following db-related operations:
- It queries the table(s) OCCUPATION, USERRECORD, JOB
This method implements the following db-related operations:
- It queries the table(s) USERRECORD
This method implements the following db-related operations:
- It queries the table(s) INDUSTRY, ZIPTABLE, USERRECORD, JOB, ZIPTABLE, USERRECORD, JOB, EMPLOYMENTSTAT, OCCUPATION
This method implements the following db-related operations:
- It queries the table(s) WAGE, JOB, EMPLOYMENTSTAT, WAGE, WAGE, JOB, WAGE, JOB, WAGE
This method implements the following db-related operations:
- It queries the table(s) WAGE, JOB, WAGE, WAGE, WAGE, JOB
This method implements the following db-related operations:
- It queries the table(s) WAGE, WAGE, JOB, WAGE, JOB, WAGE, JOB, EMPLOYMENTSTAT, JOB
This method implements the following db-related operations:
- It queries the table(s) USERRECORD, JOB, INVESTMENT
This method implements the following db-related operations:
- It queries the table(s) USERRECORD, ZIPTABLE
This method implements the following db-related operations:
- It queries the table(s) OCCUPATION, USERRECORD, JOB, EDUCATION, INDUSTRY, INVESTMENT
This method invokes db-related operations via delegation:
- It queries the table(s) USERRECORD, JOB, INVESTMENT via a call to the com.riskIt.controller.ZipcodeManager.getAllZipcodes method
This method implements the following db-related operations:
- It queries the table(s) JOB
This method invokes db-related operations via delegation:
- It queries the table(s) JOB via a call to the com.riskIt.controller.Requirements19_24.initializeSsnToWeekWageMap method
- It queries the table(s) USERRECORD via a call to the com.riskIt.controller.Requirements19_24.initializeSsnToZipMap method
- It queries the table(s) ZIPTABLE via a call to the com.riskIt.controller.Requirements19_24.initializeZipToStateMap method
This method implements the following db-related operations:
- It queries the table(s) USERRECORD, JOB, ZIPTABLE, JOB
This method invokes db-related operations via delegation:
- It queries the table(s) JOB via a call to the com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates method
- It queries the table(s) JOB via the chain-call com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates com.riskIt.controller.Requirements19_24.initializeSsnToWeekWageMap
- It queries the table(s) USERRECORD via the chain-call com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates com.riskIt.controller.Requirements19_24.initializeSsnToZipMap
- It queries the table(s) ZIPTABLE via the chain-call com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates com.riskIt.controller.Requirements19_24.initializeZipToStateMap
This method implements the following db-related operations:
- It queries the table(s) JOB
This method invokes db-related operations via delegation:
- It creates the table(s) EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It creates the table(s) EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It drops the TABLE EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It drops the TABLE EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It inserts values for the first 2 columns of table EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It inserts values for the first 2 columns of table EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It queries the table(s) EDUCATION via a call to the com.riskIt.controller.Requirements19_24.initializeSsnToEducationMap method
- It queries the table(s) EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It queries the table(s) EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
This method implements the following db-related operations:
- It queries the table(s) SELECTION
This method invokes db-related operations via delegation:
- It creates the table(s) EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It creates the table(s) EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It creates the table(s) EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It drops the TABLE EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It drops the TABLE EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It drops the TABLE EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It inserts values for the first 2 columns of table EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It inserts values for the first 2 columns of table EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It inserts values for the first 2 columns of table EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It queries the table(s) EDUCATION via the chain-call com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeSsnToEducationMap
- It queries the table(s) EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It queries the table(s) EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It queries the table(s) EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It queries the table(s) JOB via a call to the com.riskIt.controller.Requirements19_24.ComputeAverageEducation method
This method implements the following db-related operations:
- It queries the table(s) SELECTION
This method invokes db-related operations via delegation:
- It queries the table(s) USERRECORD via the chain-call com.riskIt.controller.Requirements19_24.FindTopStatesByCode com.riskIt.controller.Requirements19_24.initializeSsnToZipMap
- It queries the table(s) ZIPTABLE via the chain-call com.riskIt.controller.Requirements19_24.FindTopStatesByCode com.riskIt.controller.Requirements19_24.initializeZipToStateMap
This method implements the following db-related operations:
- It queries the table(s) JOB
This method invokes db-related operations via delegation:
- It queries the table(s) JOB via a call to the com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates method
- It queries the table(s) JOB via the chain-call com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates com.riskIt.controller.Requirements19_24.initializeSsnToWeekWageMap
- It queries the table(s) USERRECORD via the chain-call com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates com.riskIt.controller.Requirements19_24.initializeSsnToZipMap
- It queries the table(s) ZIPTABLE via the chain-call com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates com.riskIt.controller.Requirements19_24.initializeZipToStateMap
This method implements the following db-related operations:
- It queries the table(s) AGENTTABLE
This method invokes db-related operations via delegation:
- It creates the table(s) AGENTTABLE via a call to the com.riskIt.controller.AgentManager.createAgentTable method
- It drops the TABLE AGENTTABLE via a call to the com.riskIt.controller.AgentManager.createAgentTable method
- It inserts values for the first 2 columns of table AGENTTABLE via a call to the com.riskIt.controller.AgentManager.createAgentTable method
- It queries the table(s) OCCUPATION, USERRECORD, JOB, EDUCATION, INDUSTRY, INVESTMENT via the chain-call com.riskIt.ui.SubMenuChoices.agentMenu com.riskIt.ui.SubMenuChoices.sendInvitation com.riskIt.controller.AgentManager.calculateScore
- It queries the table(s) USERRECORD, JOB, INVESTMENT via the chain-call com.riskIt.ui.SubMenuChoices.agentMenu com.riskIt.ui.SubMenuChoices.sendInvitation com.riskIt.controller.AgentManager.calculateScore com.riskIt.controller.ZipcodeManager.getAllZipcodes
- It queries the table(s) USERRECORD, ZIPTABLE via the chain-call com.riskIt.ui.SubMenuChoices.agentMenu com.riskIt.ui.SubMenuChoices.sendInvitation com.riskIt.controller.AgentManager.calculateTotalValue com.riskIt.controller.AgentManager.calculateActualPremium com.riskIt.controller.ZipcodeManager.getOneZipcode
This method implements the following db-related operations:
- It queries the table(s) USERRECORD
This method invokes db-related operations via delegation:
- It inserts the NAME, ZIP, SSN, AGE, SEX, MARITAL, RACE, TAXSTAT, DETAIL, HOUSEHOLDDETAIL, FATHERORIGIN, MOTHERORIGIN, BIRTHCOUNTRY, CITIZENSHIP attributes into table USERRECORD via a call to the com.riskIt.controller.AgentManager.createNewUser method
- It inserts the SSN, CAPITALGAINS, CAPITALLOSSES, STOCKDIVIDENDS attributes into table INVESTMENT via a call to the com.riskIt.controller.AgentManager.createNewUser method
- It inserts the SSN, EDUCATION, EDUENROLL attributes into table EDUCATION via a call to the com.riskIt.controller.AgentManager.createNewUser method
- It inserts the SSN, PARENTS attributes into table YOUTH via a call to the com.riskIt.controller.AgentManager.createNewUser method
- It inserts the SSN, UNEMPLOYMENTREASON, EMPLOYMENTSTAT attributes into table EMPLOYMENTSTAT via a call to the com.riskIt.controller.AgentManager.createNewUser method
- It inserts the SSN, WORKCLASS, INDUSTRYCODE, OCCUPATIONCODE, UNIONMEMBER, EMPLOYERSIZE, WEEKWAGE, SELFEMPLOYED, WORKWEEKS attributes into table JOB via a call to the com.riskIt.controller.AgentManager.createNewUser method
- It queries the table(s) USERRECORD via a call to the com.riskIt.controller.AgentManager.createNewUser method
Some constraints that should be taken into the account are the following:
- Make sure the strings to be stored in EDUCATION do not overflow the varchar limits: 50 (EDUCATION, EDUENROLL)
- Make sure the strings to be stored in EMPLOYMENTSTAT do not overflow the varchar limits: 50 (EMPLOYMENTSTAT, UNEMPLOYMENTREASON)
- Make sure the strings to be stored in JOB do not overflow the varchar limits: 50 (WORKCLASS, UNIONMEMBER)
- Make sure the strings to be stored in USERRECORD do not overflow the varchar limits: 50 (TAXSTAT, BIRTHCOUNTRY, NAME, FATHERORIGIN, SEX, MOTHERORIGIN, CITIZENSHIP, MARITAL, RACE), 100 (DETAIL, HOUSEHOLDDETAIL), 5 (ZIP)
- Make sure the strings to be stored in YOUTH do not overflow the varchar limits: 50 (PARENTS)
- When inserting into table EDUCATION, make sure the referential integrity imposed by attribute(s) SSN is accomplished. The foreign keys in the table are the following: (SSN userrecord.SSN)
- When inserting into table EMPLOYMENTSTAT, make sure the referential integrity imposed by attribute(s) SSN is accomplished. The foreign keys in the table are the following: (SSN userrecord.SSN)
- When inserting into table INVESTMENT, make sure the referential integrity imposed by attribute(s) SSN is accomplished. The foreign keys in the table are the following: (SSN userrecord.SSN)
- When inserting into table JOB, make sure the referential integrity imposed by attribute(s) SSN, INDUSTRYCODE, OCCUPATIONCODE is accomplished. The foreign keys in the table are the following: (SSN userrecord.SSN), (INDUSTRYCODE industry.INDUSTRYCODE), (OCCUPATIONCODE occupation.OCCUPATIONCODE)
- When inserting into table YOUTH, make sure the referential integrity imposed by attribute(s) SSN is accomplished. The foreign keys in the table are the following: (SSN userrecord.SSN)
This method invokes db-related operations via delegation:
- It creates the table(s) AGENTTABLE via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices.AgentAndUser com.riskIt.ui.SubMenuChoices.AgentLogin com.riskIt.controller.AgentManager.createAgentTable
- It creates the table(s) EDUCATIONMAP via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.ComputeAverageEducationMenu com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It creates the table(s) EDUCATIONMAP via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.ComputeAverageEducationMenu com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It creates the table(s) EDUCATIONMAP via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.ComputeAverageEducationMenu com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It creates the table(s) EDUCATIONMAP via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.FindOccIndustryWithHighestLowestEducationMenu com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It creates the table(s) EDUCATIONMAP via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.FindOccIndustryWithHighestLowestEducationMenu com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It creates the table(s) EDUCATIONMAP via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.FindOccIndustryWithHighestLowestEducationMenu com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It drops the TABLE AGENTTABLE via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices.AgentAndUser com.riskIt.ui.SubMenuChoices.AgentLogin com.riskIt.controller.AgentManager.createAgentTable
- It drops the TABLE EDUCATIONMAP via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.ComputeAverageEducationMenu com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It drops the TABLE EDUCATIONMAP via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.ComputeAverageEducationMenu com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It drops the TABLE EDUCATIONMAP via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.ComputeAverageEducationMenu com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It drops the TABLE EDUCATIONMAP via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.FindOccIndustryWithHighestLowestEducationMenu com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It drops the TABLE EDUCATIONMAP via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.FindOccIndustryWithHighestLowestEducationMenu com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It drops the TABLE EDUCATIONMAP via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.FindOccIndustryWithHighestLowestEducationMenu com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It inserts the NAME, ZIP, SSN, AGE, SEX, MARITAL, RACE, TAXSTAT, DETAIL, HOUSEHOLDDETAIL, FATHERORIGIN, MOTHERORIGIN, BIRTHCOUNTRY, CITIZENSHIP attributes into table USERRECORD via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices.inputForCreateUser com.riskIt.controller.AgentManager.createNewUser
- It inserts the SSN, CAPITALGAINS, CAPITALLOSSES, STOCKDIVIDENDS attributes into table INVESTMENT via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices.inputForCreateUser com.riskIt.controller.AgentManager.createNewUser
- It inserts the SSN, EDUCATION, EDUENROLL attributes into table EDUCATION via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices.inputForCreateUser com.riskIt.controller.AgentManager.createNewUser
- It inserts the SSN, PARENTS attributes into table YOUTH via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices.inputForCreateUser com.riskIt.controller.AgentManager.createNewUser
- It inserts the SSN, UNEMPLOYMENTREASON, EMPLOYMENTSTAT attributes into table EMPLOYMENTSTAT via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices.inputForCreateUser com.riskIt.controller.AgentManager.createNewUser
- It inserts the SSN, WORKCLASS, INDUSTRYCODE, OCCUPATIONCODE, UNIONMEMBER, EMPLOYERSIZE, WEEKWAGE, SELFEMPLOYED, WORKWEEKS attributes into table JOB via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices.inputForCreateUser com.riskIt.controller.AgentManager.createNewUser
- It inserts values for the first 2 columns of table AGENTTABLE via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices.AgentAndUser com.riskIt.ui.SubMenuChoices.AgentLogin com.riskIt.controller.AgentManager.createAgentTable
- It inserts values for the first 2 columns of table EDUCATIONMAP via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.ComputeAverageEducationMenu com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It inserts values for the first 2 columns of table EDUCATIONMAP via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.ComputeAverageEducationMenu com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It inserts values for the first 2 columns of table EDUCATIONMAP via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.ComputeAverageEducationMenu com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It inserts values for the first 2 columns of table EDUCATIONMAP via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.FindOccIndustryWithHighestLowestEducationMenu com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It inserts values for the first 2 columns of table EDUCATIONMAP via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.FindOccIndustryWithHighestLowestEducationMenu com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It inserts values for the first 2 columns of table EDUCATIONMAP via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.FindOccIndustryWithHighestLowestEducationMenu com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It queries the table(s) AGENTTABLE via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices.AgentAndUser com.riskIt.ui.SubMenuChoices.AgentLogin
- It queries the table(s) EDUCATION via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.ComputeAverageEducationMenu com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeSsnToEducationMap
- It queries the table(s) EDUCATION via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.FindOccIndustryWithHighestLowestEducationMenu com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeSsnToEducationMap
- It queries the table(s) EDUCATIONMAP via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.ComputeAverageEducationMenu com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It queries the table(s) EDUCATIONMAP via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.ComputeAverageEducationMenu com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It queries the table(s) EDUCATIONMAP via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.ComputeAverageEducationMenu com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It queries the table(s) EDUCATIONMAP via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.FindOccIndustryWithHighestLowestEducationMenu com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It queries the table(s) EDUCATIONMAP via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.FindOccIndustryWithHighestLowestEducationMenu com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It queries the table(s) EDUCATIONMAP via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.FindOccIndustryWithHighestLowestEducationMenu com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It queries the table(s) INDUSTRY, ZIPTABLE, USERRECORD, JOB, ZIPTABLE, USERRECORD, JOB, EMPLOYMENTSTAT, OCCUPATION via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.controller.UserManager.updatestability
- It queries the table(s) JOB via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.CalculateLikelinessToMoveFactorMenu com.riskIt.controller.Requirements19_24.CalculateLikelinessToMoveFactor com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates com.riskIt.controller.Requirements19_24.initializeSsnToWeekWageMap
- It queries the table(s) JOB via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.CalculateLikelinessToMoveFactorMenu com.riskIt.controller.Requirements19_24.CalculateLikelinessToMoveFactor com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates
- It queries the table(s) JOB via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.ComputeAverageEducationMenu com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.ComputeAverageEducation
- It queries the table(s) JOB via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.FindOccIndustryWithHighestLowestEducationMenu com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.ComputeAverageEducation
- It queries the table(s) JOB via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.RecommendBestStateToWorkMenu com.riskIt.controller.Requirements19_24.RecommendBestStateToWork com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates com.riskIt.controller.Requirements19_24.initializeSsnToWeekWageMap
- It queries the table(s) JOB via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.RecommendBestStateToWorkMenu com.riskIt.controller.Requirements19_24.RecommendBestStateToWork com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates
- It queries the table(s) JOB via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.RecommendBestStateToWorkMenu com.riskIt.controller.Requirements19_24.RecommendBestStateToWork
- It queries the table(s) OCCUPATION, USERRECORD, JOB, EDUCATION, INDUSTRY, INVESTMENT via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.controller.AgentManager.calculateScore
- It queries the table(s) OCCUPATION, USERRECORD, JOB, EDUCATION, INDUSTRY, INVESTMENT via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices.AgentAndUser com.riskIt.ui.SubMenuChoices.AgentLogin com.riskIt.ui.SubMenuChoices.agentMenu com.riskIt.ui.SubMenuChoices.sendInvitation com.riskIt.controller.AgentManager.calculateScore
- It queries the table(s) OCCUPATION, USERRECORD, JOB, EDUCATION, INDUSTRY, INVESTMENT via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices.AgentAndUser com.riskIt.ui.SubMenuChoices.agentMenu com.riskIt.ui.SubMenuChoices.sendInvitation com.riskIt.controller.AgentManager.calculateScore
- It queries the table(s) OCCUPATION, USERRECORD, JOB, EDUCATION, INDUSTRY, INVESTMENT via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices.AgentAndUser com.riskIt.ui.SubMenuChoices.inputForUserQuotes com.riskIt.controller.UserManager.calculateQuoteForCustomer com.riskIt.controller.AgentManager.calculateScore
- It queries the table(s) OCCUPATION, USERRECORD, JOB via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices.browseUserByChoice com.riskIt.controller.UserManager.filterOccupation
- It queries the table(s) SELECTION via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.FindOccIndustryWithHighestLowestEducationMenu com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation
- It queries the table(s) SELECTION via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.FindTopStatesMenu com.riskIt.controller.Requirements19_24.FindTopStatesByCategory
- It queries the table(s) USERRECORD, EDUCATION via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices.browseUserByChoice com.riskIt.controller.UserManager.filterEducation
- It queries the table(s) USERRECORD, JOB, INVESTMENT via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.controller.AgentManager.calculateScore com.riskIt.controller.ZipcodeManager.getAllZipcodes
- It queries the table(s) USERRECORD, JOB, INVESTMENT via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices.AgentAndUser com.riskIt.ui.SubMenuChoices.AgentLogin com.riskIt.ui.SubMenuChoices.agentMenu com.riskIt.ui.SubMenuChoices.sendInvitation com.riskIt.controller.AgentManager.calculateScore com.riskIt.controller.ZipcodeManager.getAllZipcodes
- It queries the table(s) USERRECORD, JOB, INVESTMENT via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices.AgentAndUser com.riskIt.ui.SubMenuChoices.agentMenu com.riskIt.ui.SubMenuChoices.sendInvitation com.riskIt.controller.AgentManager.calculateScore com.riskIt.controller.ZipcodeManager.getAllZipcodes
- It queries the table(s) USERRECORD, JOB, INVESTMENT via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices.AgentAndUser com.riskIt.ui.SubMenuChoices.inputForUserQuotes com.riskIt.controller.UserManager.calculateQuoteForCustomer com.riskIt.controller.AgentManager.calculateScore com.riskIt.controller.ZipcodeManager.getAllZipcodes
- It queries the table(s) USERRECORD, JOB, INVESTMENT via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices.browseUserByChoice com.riskIt.controller.UserManager.filterEstimatedIncome
- It queries the table(s) USERRECORD, JOB, ZIPTABLE, JOB via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.CalculateLikelinessToMoveFactorMenu com.riskIt.controller.Requirements19_24.CalculateLikelinessToMoveFactor
- It queries the table(s) USERRECORD, ZIPTABLE via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices.AgentAndUser com.riskIt.ui.SubMenuChoices.AgentLogin com.riskIt.ui.SubMenuChoices.agentMenu com.riskIt.ui.SubMenuChoices.sendInvitation com.riskIt.controller.AgentManager.calculateTotalValue com.riskIt.controller.AgentManager.calculateActualPremium com.riskIt.controller.ZipcodeManager.getOneZipcode
- It queries the table(s) USERRECORD, ZIPTABLE via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices.AgentAndUser com.riskIt.ui.SubMenuChoices.agentMenu com.riskIt.ui.SubMenuChoices.sendInvitation com.riskIt.controller.AgentManager.calculateTotalValue com.riskIt.controller.AgentManager.calculateActualPremium com.riskIt.controller.ZipcodeManager.getOneZipcode
- It queries the table(s) USERRECORD, ZIPTABLE via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices.AgentAndUser com.riskIt.ui.SubMenuChoices.inputForUserQuotes com.riskIt.controller.UserManager.calculateQuoteForCustomer com.riskIt.controller.AgentManager.calculateTotalValue com.riskIt.controller.AgentManager.calculateActualPremium com.riskIt.controller.ZipcodeManager.getOneZipcode
- It queries the table(s) USERRECORD via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices.browseUserByChoice com.riskIt.controller.UserManager.filterMaritalStatus
- It queries the table(s) USERRECORD via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices.browseUserByChoice com.riskIt.controller.UserManager.filterZipcode
- It queries the table(s) USERRECORD via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices.inputForCreateUser com.riskIt.controller.AgentManager.createNewUser
- It queries the table(s) USERRECORD via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices.inputForCreateUser
- It queries the table(s) USERRECORD via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.CalculateLikelinessToMoveFactorMenu com.riskIt.controller.Requirements19_24.CalculateLikelinessToMoveFactor com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates com.riskIt.controller.Requirements19_24.initializeSsnToZipMap
- It queries the table(s) USERRECORD via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.FindTopStatesMenu com.riskIt.controller.Requirements19_24.FindTopStatesByCategory com.riskIt.controller.Requirements19_24.FindTopStatesByCode com.riskIt.controller.Requirements19_24.initializeSsnToZipMap
- It queries the table(s) USERRECORD via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.FindTopStatesMenu com.riskIt.controller.Requirements19_24.FindTopStatesByCode com.riskIt.controller.Requirements19_24.initializeSsnToZipMap
- It queries the table(s) USERRECORD via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.RecommendBestStateToWorkMenu com.riskIt.controller.Requirements19_24.RecommendBestStateToWork com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates com.riskIt.controller.Requirements19_24.initializeSsnToZipMap
- It queries the table(s) WAGE, JOB, EMPLOYMENTSTAT, WAGE, WAGE, JOB, WAGE, JOB, WAGE via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.controller.UserManager.updatetable
- It queries the table(s) WAGE, JOB, WAGE, WAGE, WAGE, JOB via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.controller.UserManager.updatewagetable
- It queries the table(s) WAGE, WAGE, JOB, WAGE, JOB, WAGE, JOB, EMPLOYMENTSTAT, JOB via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.controller.UserManager.userinformation
- It queries the table(s) ZIPTABLE, USERRECORD, EMPLOYMENTSTAT, ZIPTABLE, USERRECORD via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.controller.UserManager.calculateUnEmploymentRate
- It queries the table(s) ZIPTABLE, USERRECORD, JOB via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.controller.UserManager.FindTopIndustryCode
- It queries the table(s) ZIPTABLE, USERRECORD, JOB via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.controller.UserManager.FindTopOccupationCode
- It queries the table(s) ZIPTABLE via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.CalculateLikelinessToMoveFactorMenu com.riskIt.controller.Requirements19_24.CalculateLikelinessToMoveFactor com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates com.riskIt.controller.Requirements19_24.initializeZipToStateMap
- It queries the table(s) ZIPTABLE via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.FindTopStatesMenu com.riskIt.controller.Requirements19_24.FindTopStatesByCategory com.riskIt.controller.Requirements19_24.FindTopStatesByCode com.riskIt.controller.Requirements19_24.initializeZipToStateMap
- It queries the table(s) ZIPTABLE via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.FindTopStatesMenu com.riskIt.controller.Requirements19_24.FindTopStatesByCode com.riskIt.controller.Requirements19_24.initializeZipToStateMap
- It queries the table(s) ZIPTABLE via the chain-call com.riskIt.ui.MenuChoices.mainMenu com.riskIt.ui.SubMenuChoices19_24.RecommendBestStateToWorkMenu com.riskIt.controller.Requirements19_24.RecommendBestStateToWork com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates com.riskIt.controller.Requirements19_24.initializeZipToStateMap
Some constraints that should be taken into the account are the following:
- Make sure the strings to be stored in EDUCATION do not overflow the varchar limits: 50 (EDUCATION, EDUENROLL)
- Make sure the strings to be stored in EMPLOYMENTSTAT do not overflow the varchar limits: 50 (EMPLOYMENTSTAT, UNEMPLOYMENTREASON)
- Make sure the strings to be stored in JOB do not overflow the varchar limits: 50 (WORKCLASS, UNIONMEMBER)
- Make sure the strings to be stored in USERRECORD do not overflow the varchar limits: 50 (TAXSTAT, BIRTHCOUNTRY, NAME, FATHERORIGIN, SEX, MOTHERORIGIN, CITIZENSHIP, MARITAL, RACE), 100 (DETAIL, HOUSEHOLDDETAIL), 5 (ZIP)
- Make sure the strings to be stored in YOUTH do not overflow the varchar limits: 50 (PARENTS)
- When inserting into table EDUCATION, make sure the referential integrity imposed by attribute(s) SSN is accomplished. The foreign keys in the table are the following: (SSN userrecord.SSN)
- When inserting into table EMPLOYMENTSTAT, make sure the referential integrity imposed by attribute(s) SSN is accomplished. The foreign keys in the table are the following: (SSN userrecord.SSN)
- When inserting into table INVESTMENT, make sure the referential integrity imposed by attribute(s) SSN is accomplished. The foreign keys in the table are the following: (SSN userrecord.SSN)
- When inserting into table JOB, make sure the referential integrity imposed by attribute(s) SSN, INDUSTRYCODE, OCCUPATIONCODE is accomplished. The foreign keys in the table are the following: (SSN userrecord.SSN), (INDUSTRYCODE industry.INDUSTRYCODE), (OCCUPATIONCODE occupation.OCCUPATIONCODE)
- When inserting into table YOUTH, make sure the referential integrity imposed by attribute(s) SSN is accomplished. The foreign keys in the table are the following: (SSN userrecord.SSN)
This method invokes db-related operations via delegation:
- It queries the table(s) JOB via the chain-call com.riskIt.controller.Requirements19_24.CalculateLikelinessToMoveFactor com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates com.riskIt.controller.Requirements19_24.initializeSsnToWeekWageMap
- It queries the table(s) JOB via the chain-call com.riskIt.controller.Requirements19_24.CalculateLikelinessToMoveFactor com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates
- It queries the table(s) OCCUPATION, USERRECORD, JOB, EDUCATION, INDUSTRY, INVESTMENT via the chain-call com.riskIt.controller.UserManager.calculateQuoteForCustomer com.riskIt.controller.AgentManager.calculateScore
- It queries the table(s) USERRECORD, JOB, INVESTMENT via the chain-call com.riskIt.controller.UserManager.calculateQuoteForCustomer com.riskIt.controller.AgentManager.calculateScore com.riskIt.controller.ZipcodeManager.getAllZipcodes
- It queries the table(s) USERRECORD, JOB, ZIPTABLE, JOB via a call to the com.riskIt.controller.Requirements19_24.CalculateLikelinessToMoveFactor method
- It queries the table(s) USERRECORD, ZIPTABLE via the chain-call com.riskIt.controller.UserManager.calculateQuoteForCustomer com.riskIt.controller.AgentManager.calculateTotalValue com.riskIt.controller.AgentManager.calculateActualPremium com.riskIt.controller.ZipcodeManager.getOneZipcode
- It queries the table(s) USERRECORD via the chain-call com.riskIt.controller.Requirements19_24.CalculateLikelinessToMoveFactor com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates com.riskIt.controller.Requirements19_24.initializeSsnToZipMap
- It queries the table(s) ZIPTABLE via the chain-call com.riskIt.controller.Requirements19_24.CalculateLikelinessToMoveFactor com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates com.riskIt.controller.Requirements19_24.initializeZipToStateMap
This method invokes db-related operations via delegation:
- It queries the table(s) OCCUPATION, USERRECORD, JOB, EDUCATION, INDUSTRY, INVESTMENT via the chain-call com.riskIt.controller.UserManager.calculateQuoteForCustomer com.riskIt.controller.AgentManager.calculateScore
- It queries the table(s) USERRECORD, JOB, INVESTMENT via the chain-call com.riskIt.controller.UserManager.calculateQuoteForCustomer com.riskIt.controller.AgentManager.calculateScore com.riskIt.controller.ZipcodeManager.getAllZipcodes
- It queries the table(s) USERRECORD, ZIPTABLE via the chain-call com.riskIt.controller.UserManager.calculateQuoteForCustomer com.riskIt.controller.AgentManager.calculateTotalValue com.riskIt.controller.AgentManager.calculateActualPremium com.riskIt.controller.ZipcodeManager.getOneZipcode
This method invokes db-related operations via delegation:
- It queries the table(s) JOB via the chain-call com.riskIt.controller.Requirements19_24.CalculateLikelinessToMoveFactor com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates com.riskIt.controller.Requirements19_24.initializeSsnToWeekWageMap
- It queries the table(s) JOB via the chain-call com.riskIt.controller.Requirements19_24.CalculateLikelinessToMoveFactor com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates
- It queries the table(s) USERRECORD, JOB, ZIPTABLE, JOB via a call to the com.riskIt.controller.Requirements19_24.CalculateLikelinessToMoveFactor method
- It queries the table(s) USERRECORD via the chain-call com.riskIt.controller.Requirements19_24.CalculateLikelinessToMoveFactor com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates com.riskIt.controller.Requirements19_24.initializeSsnToZipMap
- It queries the table(s) ZIPTABLE via the chain-call com.riskIt.controller.Requirements19_24.CalculateLikelinessToMoveFactor com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates com.riskIt.controller.Requirements19_24.initializeZipToStateMap
This method invokes db-related operations via delegation:
- It queries the table(s) USERRECORD, ZIPTABLE via a call to the com.riskIt.controller.ZipcodeManager.getOneZipcode method
This method invokes db-related operations via delegation:
- It queries the table(s) USERRECORD, ZIPTABLE via the chain-call com.riskIt.controller.AgentManager.calculateActualPremium com.riskIt.controller.ZipcodeManager.getOneZipcode
This method invokes db-related operations via delegation:
- It queries the table(s) JOB, EDUCATION via a call to the com.riskIt.controller.CalculateByEducation.calculateValue method
This method invokes db-related operations via delegation:
- It queries the table(s) JOB, EDUCATION via a call to the com.riskIt.controller.CalculateByEducation.calculateValue method
This method invokes db-related operations via delegation:
- It queries the table(s) JOB, EDUCATION via a call to the com.riskIt.controller.CalculateByEducation.calculateValue method
This method invokes db-related operations via delegation:
- It queries the table(s) JOB, EDUCATION via a call to the com.riskIt.controller.CalculateByEducation.calculateValue method
This method invokes db-related operations via delegation:
- It queries the table(s) EDUCATION via a call to the com.riskIt.controller.CalculateByEducation.getEducationLevelList method
This method invokes db-related operations via delegation:
- It queries the table(s) JOB via a call to the com.riskIt.controller.CalculateByOccupationOrIndustryCode.calculateResult method
This method invokes db-related operations via delegation:
- It queries the table(s) JOB via a call to the com.riskIt.controller.CalculateByOccupationOrIndustryCode.calculateResult method
This method invokes db-related operations via delegation:
- It queries the table(s) JOB via a call to the com.riskIt.controller.CalculateByOccupationOrIndustryCode.calculateResult method
This method invokes db-related operations via delegation:
- It queries the table(s) JOB via a call to the com.riskIt.controller.CalculateByOccupationOrIndustryCode.calculateResult method
This method invokes db-related operations via delegation:
- It queries the table(s) INDUSTRY via a call to the com.riskIt.controller.CalculateByOccupationOrIndustryCode.getIndustryCodeList method
This method invokes db-related operations via delegation:
- It queries the table(s) OCCUPATION via a call to the com.riskIt.controller.CalculateByOccupationOrIndustryCode.getOccupationCodeList method
This method invokes db-related operations via delegation:
- It queries the table(s) JOB, USERRECORD via a call to the com.riskIt.controller.CalculateByRace.calculateValue method
This method invokes db-related operations via delegation:
- It queries the table(s) JOB, USERRECORD via a call to the com.riskIt.controller.CalculateByRace.calculateValue method
This method invokes db-related operations via delegation:
- It queries the table(s) JOB, USERRECORD via a call to the com.riskIt.controller.CalculateByRace.calculateValue method
This method invokes db-related operations via delegation:
- It queries the table(s) JOB, USERRECORD via a call to the com.riskIt.controller.CalculateByRace.calculateValue method
This method invokes db-related operations via delegation:
- It queries the table(s) USERRECORD via a call to the com.riskIt.controller.CalculateByRace.getRaceList method
This method invokes db-related operations via delegation:
- It queries the table(s) ZIPTABLE, JOB, USERRECORD via a call to the com.riskIt.controller.CalculateByState.calculateIncome method
This method invokes db-related operations via delegation:
- It queries the table(s) ZIPTABLE, JOB, USERRECORD via a call to the com.riskIt.controller.CalculateByState.calculateIncome method
This method invokes db-related operations via delegation:
- It queries the table(s) ZIPTABLE, JOB, USERRECORD via a call to the com.riskIt.controller.CalculateByState.calculateIncome method
This method invokes db-related operations via delegation:
- It queries the table(s) ZIPTABLE, JOB, USERRECORD via a call to the com.riskIt.controller.CalculateByState.calculateIncome method
This method invokes db-related operations via delegation:
- It queries the table(s) ZIPTABLE via a call to the com.riskIt.controller.CalculateByState.getStateList method
This method invokes db-related operations via delegation:
- It queries the table(s) JOB, INVESTMENT via a call to the com.riskIt.controller.EstimateIncome.calculateSlopesAndIntercepts method
This method invokes db-related operations via delegation:
- It creates the table(s) EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It creates the table(s) EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It creates the table(s) EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It drops the TABLE EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It drops the TABLE EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It drops the TABLE EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It inserts values for the first 2 columns of table EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It inserts values for the first 2 columns of table EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It inserts values for the first 2 columns of table EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It queries the table(s) EDUCATION via the chain-call com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeSsnToEducationMap
- It queries the table(s) EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It queries the table(s) EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It queries the table(s) EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It queries the table(s) JOB via a call to the com.riskIt.controller.Requirements19_24.ComputeAverageEducation method
This method invokes db-related operations via delegation:
- It queries the table(s) USERRECORD via a call to the com.riskIt.controller.Requirements19_24.initializeSsnToZipMap method
- It queries the table(s) ZIPTABLE via a call to the com.riskIt.controller.Requirements19_24.initializeZipToStateMap method
This method invokes db-related operations via delegation:
- It creates the table(s) EDUCATIONMAP via a call to the com.riskIt.controller.Requirements19_24.getEducationResultSet method
- It drops the TABLE EDUCATIONMAP via a call to the com.riskIt.controller.Requirements19_24.getEducationResultSet method
- It inserts values for the first 2 columns of table EDUCATIONMAP via a call to the com.riskIt.controller.Requirements19_24.getEducationResultSet method
- It queries the table(s) EDUCATIONMAP via a call to the com.riskIt.controller.Requirements19_24.getEducationResultSet method
This method invokes db-related operations via delegation:
- It creates the table(s) EDUCATIONMAP via a call to the com.riskIt.controller.Requirements19_24.getEducationResultSet method
- It drops the TABLE EDUCATIONMAP via a call to the com.riskIt.controller.Requirements19_24.getEducationResultSet method
- It inserts values for the first 2 columns of table EDUCATIONMAP via a call to the com.riskIt.controller.Requirements19_24.getEducationResultSet method
- It queries the table(s) EDUCATIONMAP via a call to the com.riskIt.controller.Requirements19_24.getEducationResultSet method
This method invokes db-related operations via delegation:
- It queries the table(s) OCCUPATION, USERRECORD, JOB, EDUCATION, INDUSTRY, INVESTMENT via a call to the com.riskIt.controller.AgentManager.calculateScore method
- It queries the table(s) USERRECORD, JOB, INVESTMENT via the chain-call com.riskIt.controller.AgentManager.calculateScore com.riskIt.controller.ZipcodeManager.getAllZipcodes
- It queries the table(s) USERRECORD, ZIPTABLE via the chain-call com.riskIt.controller.AgentManager.calculateTotalValue com.riskIt.controller.AgentManager.calculateActualPremium com.riskIt.controller.ZipcodeManager.getOneZipcode
This method invokes db-related operations via delegation:
- It creates the table(s) AGENTTABLE via the chain-call com.riskIt.ui.SubMenuChoices.AgentAndUser com.riskIt.ui.SubMenuChoices.AgentLogin com.riskIt.controller.AgentManager.createAgentTable
- It creates the table(s) EDUCATIONMAP via the chain-call com.riskIt.ui.SubMenuChoices19_24.ComputeAverageEducationMenu com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It creates the table(s) EDUCATIONMAP via the chain-call com.riskIt.ui.SubMenuChoices19_24.ComputeAverageEducationMenu com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It creates the table(s) EDUCATIONMAP via the chain-call com.riskIt.ui.SubMenuChoices19_24.ComputeAverageEducationMenu com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It creates the table(s) EDUCATIONMAP via the chain-call com.riskIt.ui.SubMenuChoices19_24.FindOccIndustryWithHighestLowestEducationMenu com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It creates the table(s) EDUCATIONMAP via the chain-call com.riskIt.ui.SubMenuChoices19_24.FindOccIndustryWithHighestLowestEducationMenu com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It creates the table(s) EDUCATIONMAP via the chain-call com.riskIt.ui.SubMenuChoices19_24.FindOccIndustryWithHighestLowestEducationMenu com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It drops the TABLE AGENTTABLE via the chain-call com.riskIt.ui.SubMenuChoices.AgentAndUser com.riskIt.ui.SubMenuChoices.AgentLogin com.riskIt.controller.AgentManager.createAgentTable
- It drops the TABLE EDUCATIONMAP via the chain-call com.riskIt.ui.SubMenuChoices19_24.ComputeAverageEducationMenu com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It drops the TABLE EDUCATIONMAP via the chain-call com.riskIt.ui.SubMenuChoices19_24.ComputeAverageEducationMenu com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It drops the TABLE EDUCATIONMAP via the chain-call com.riskIt.ui.SubMenuChoices19_24.ComputeAverageEducationMenu com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It drops the TABLE EDUCATIONMAP via the chain-call com.riskIt.ui.SubMenuChoices19_24.FindOccIndustryWithHighestLowestEducationMenu com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It drops the TABLE EDUCATIONMAP via the chain-call com.riskIt.ui.SubMenuChoices19_24.FindOccIndustryWithHighestLowestEducationMenu com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It drops the TABLE EDUCATIONMAP via the chain-call com.riskIt.ui.SubMenuChoices19_24.FindOccIndustryWithHighestLowestEducationMenu com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It inserts the NAME, ZIP, SSN, AGE, SEX, MARITAL, RACE, TAXSTAT, DETAIL, HOUSEHOLDDETAIL, FATHERORIGIN, MOTHERORIGIN, BIRTHCOUNTRY, CITIZENSHIP attributes into table USERRECORD via the chain-call com.riskIt.ui.SubMenuChoices.inputForCreateUser com.riskIt.controller.AgentManager.createNewUser
- It inserts the SSN, CAPITALGAINS, CAPITALLOSSES, STOCKDIVIDENDS attributes into table INVESTMENT via the chain-call com.riskIt.ui.SubMenuChoices.inputForCreateUser com.riskIt.controller.AgentManager.createNewUser
- It inserts the SSN, EDUCATION, EDUENROLL attributes into table EDUCATION via the chain-call com.riskIt.ui.SubMenuChoices.inputForCreateUser com.riskIt.controller.AgentManager.createNewUser
- It inserts the SSN, PARENTS attributes into table YOUTH via the chain-call com.riskIt.ui.SubMenuChoices.inputForCreateUser com.riskIt.controller.AgentManager.createNewUser
- It inserts the SSN, UNEMPLOYMENTREASON, EMPLOYMENTSTAT attributes into table EMPLOYMENTSTAT via the chain-call com.riskIt.ui.SubMenuChoices.inputForCreateUser com.riskIt.controller.AgentManager.createNewUser
- It inserts the SSN, WORKCLASS, INDUSTRYCODE, OCCUPATIONCODE, UNIONMEMBER, EMPLOYERSIZE, WEEKWAGE, SELFEMPLOYED, WORKWEEKS attributes into table JOB via the chain-call com.riskIt.ui.SubMenuChoices.inputForCreateUser com.riskIt.controller.AgentManager.createNewUser
- It inserts values for the first 2 columns of table AGENTTABLE via the chain-call com.riskIt.ui.SubMenuChoices.AgentAndUser com.riskIt.ui.SubMenuChoices.AgentLogin com.riskIt.controller.AgentManager.createAgentTable
- It inserts values for the first 2 columns of table EDUCATIONMAP via the chain-call com.riskIt.ui.SubMenuChoices19_24.ComputeAverageEducationMenu com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It inserts values for the first 2 columns of table EDUCATIONMAP via the chain-call com.riskIt.ui.SubMenuChoices19_24.ComputeAverageEducationMenu com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It inserts values for the first 2 columns of table EDUCATIONMAP via the chain-call com.riskIt.ui.SubMenuChoices19_24.ComputeAverageEducationMenu com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It inserts values for the first 2 columns of table EDUCATIONMAP via the chain-call com.riskIt.ui.SubMenuChoices19_24.FindOccIndustryWithHighestLowestEducationMenu com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It inserts values for the first 2 columns of table EDUCATIONMAP via the chain-call com.riskIt.ui.SubMenuChoices19_24.FindOccIndustryWithHighestLowestEducationMenu com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It inserts values for the first 2 columns of table EDUCATIONMAP via the chain-call com.riskIt.ui.SubMenuChoices19_24.FindOccIndustryWithHighestLowestEducationMenu com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It queries the table(s) AGENTTABLE via the chain-call com.riskIt.ui.SubMenuChoices.AgentAndUser com.riskIt.ui.SubMenuChoices.AgentLogin
- It queries the table(s) EDUCATION via the chain-call com.riskIt.ui.SubMenuChoices19_24.ComputeAverageEducationMenu com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeSsnToEducationMap
- It queries the table(s) EDUCATION via the chain-call com.riskIt.ui.SubMenuChoices19_24.FindOccIndustryWithHighestLowestEducationMenu com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeSsnToEducationMap
- It queries the table(s) EDUCATIONMAP via the chain-call com.riskIt.ui.SubMenuChoices19_24.ComputeAverageEducationMenu com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It queries the table(s) EDUCATIONMAP via the chain-call com.riskIt.ui.SubMenuChoices19_24.ComputeAverageEducationMenu com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It queries the table(s) EDUCATIONMAP via the chain-call com.riskIt.ui.SubMenuChoices19_24.ComputeAverageEducationMenu com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It queries the table(s) EDUCATIONMAP via the chain-call com.riskIt.ui.SubMenuChoices19_24.FindOccIndustryWithHighestLowestEducationMenu com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It queries the table(s) EDUCATIONMAP via the chain-call com.riskIt.ui.SubMenuChoices19_24.FindOccIndustryWithHighestLowestEducationMenu com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It queries the table(s) EDUCATIONMAP via the chain-call com.riskIt.ui.SubMenuChoices19_24.FindOccIndustryWithHighestLowestEducationMenu com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It queries the table(s) INDUSTRY, ZIPTABLE, USERRECORD, JOB, ZIPTABLE, USERRECORD, JOB, EMPLOYMENTSTAT, OCCUPATION via a call to the com.riskIt.controller.UserManager.updatestability method
- It queries the table(s) JOB via the chain-call com.riskIt.ui.SubMenuChoices19_24.CalculateLikelinessToMoveFactorMenu com.riskIt.controller.Requirements19_24.CalculateLikelinessToMoveFactor com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates com.riskIt.controller.Requirements19_24.initializeSsnToWeekWageMap
- It queries the table(s) JOB via the chain-call com.riskIt.ui.SubMenuChoices19_24.CalculateLikelinessToMoveFactorMenu com.riskIt.controller.Requirements19_24.CalculateLikelinessToMoveFactor com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates
- It queries the table(s) JOB via the chain-call com.riskIt.ui.SubMenuChoices19_24.ComputeAverageEducationMenu com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.ComputeAverageEducation
- It queries the table(s) JOB via the chain-call com.riskIt.ui.SubMenuChoices19_24.FindOccIndustryWithHighestLowestEducationMenu com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.ComputeAverageEducation
- It queries the table(s) JOB via the chain-call com.riskIt.ui.SubMenuChoices19_24.RecommendBestStateToWorkMenu com.riskIt.controller.Requirements19_24.RecommendBestStateToWork com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates com.riskIt.controller.Requirements19_24.initializeSsnToWeekWageMap
- It queries the table(s) JOB via the chain-call com.riskIt.ui.SubMenuChoices19_24.RecommendBestStateToWorkMenu com.riskIt.controller.Requirements19_24.RecommendBestStateToWork com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates
- It queries the table(s) JOB via the chain-call com.riskIt.ui.SubMenuChoices19_24.RecommendBestStateToWorkMenu com.riskIt.controller.Requirements19_24.RecommendBestStateToWork
- It queries the table(s) OCCUPATION, USERRECORD, JOB, EDUCATION, INDUSTRY, INVESTMENT via a call to the com.riskIt.controller.AgentManager.calculateScore method
- It queries the table(s) OCCUPATION, USERRECORD, JOB, EDUCATION, INDUSTRY, INVESTMENT via the chain-call com.riskIt.ui.SubMenuChoices.AgentAndUser com.riskIt.ui.SubMenuChoices.AgentLogin com.riskIt.ui.SubMenuChoices.agentMenu com.riskIt.ui.SubMenuChoices.sendInvitation com.riskIt.controller.AgentManager.calculateScore
- It queries the table(s) OCCUPATION, USERRECORD, JOB, EDUCATION, INDUSTRY, INVESTMENT via the chain-call com.riskIt.ui.SubMenuChoices.AgentAndUser com.riskIt.ui.SubMenuChoices.agentMenu com.riskIt.ui.SubMenuChoices.sendInvitation com.riskIt.controller.AgentManager.calculateScore
- It queries the table(s) OCCUPATION, USERRECORD, JOB, EDUCATION, INDUSTRY, INVESTMENT via the chain-call com.riskIt.ui.SubMenuChoices.AgentAndUser com.riskIt.ui.SubMenuChoices.inputForUserQuotes com.riskIt.controller.UserManager.calculateQuoteForCustomer com.riskIt.controller.AgentManager.calculateScore
- It queries the table(s) OCCUPATION, USERRECORD, JOB via the chain-call com.riskIt.ui.SubMenuChoices.browseUserByChoice com.riskIt.controller.UserManager.filterOccupation
- It queries the table(s) SELECTION via the chain-call com.riskIt.ui.SubMenuChoices19_24.FindOccIndustryWithHighestLowestEducationMenu com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation
- It queries the table(s) SELECTION via the chain-call com.riskIt.ui.SubMenuChoices19_24.FindTopStatesMenu com.riskIt.controller.Requirements19_24.FindTopStatesByCategory
- It queries the table(s) USERRECORD, EDUCATION via the chain-call com.riskIt.ui.SubMenuChoices.browseUserByChoice com.riskIt.controller.UserManager.filterEducation
- It queries the table(s) USERRECORD, JOB, INVESTMENT via the chain-call com.riskIt.controller.AgentManager.calculateScore com.riskIt.controller.ZipcodeManager.getAllZipcodes
- It queries the table(s) USERRECORD, JOB, INVESTMENT via the chain-call com.riskIt.ui.SubMenuChoices.AgentAndUser com.riskIt.ui.SubMenuChoices.AgentLogin com.riskIt.ui.SubMenuChoices.agentMenu com.riskIt.ui.SubMenuChoices.sendInvitation com.riskIt.controller.AgentManager.calculateScore com.riskIt.controller.ZipcodeManager.getAllZipcodes
- It queries the table(s) USERRECORD, JOB, INVESTMENT via the chain-call com.riskIt.ui.SubMenuChoices.AgentAndUser com.riskIt.ui.SubMenuChoices.agentMenu com.riskIt.ui.SubMenuChoices.sendInvitation com.riskIt.controller.AgentManager.calculateScore com.riskIt.controller.ZipcodeManager.getAllZipcodes
- It queries the table(s) USERRECORD, JOB, INVESTMENT via the chain-call com.riskIt.ui.SubMenuChoices.AgentAndUser com.riskIt.ui.SubMenuChoices.inputForUserQuotes com.riskIt.controller.UserManager.calculateQuoteForCustomer com.riskIt.controller.AgentManager.calculateScore com.riskIt.controller.ZipcodeManager.getAllZipcodes
- It queries the table(s) USERRECORD, JOB, INVESTMENT via the chain-call com.riskIt.ui.SubMenuChoices.browseUserByChoice com.riskIt.controller.UserManager.filterEstimatedIncome
- It queries the table(s) USERRECORD, JOB, ZIPTABLE, JOB via the chain-call com.riskIt.ui.SubMenuChoices19_24.CalculateLikelinessToMoveFactorMenu com.riskIt.controller.Requirements19_24.CalculateLikelinessToMoveFactor
- It queries the table(s) USERRECORD, ZIPTABLE via the chain-call com.riskIt.ui.SubMenuChoices.AgentAndUser com.riskIt.ui.SubMenuChoices.AgentLogin com.riskIt.ui.SubMenuChoices.agentMenu com.riskIt.ui.SubMenuChoices.sendInvitation com.riskIt.controller.AgentManager.calculateTotalValue com.riskIt.controller.AgentManager.calculateActualPremium com.riskIt.controller.ZipcodeManager.getOneZipcode
- It queries the table(s) USERRECORD, ZIPTABLE via the chain-call com.riskIt.ui.SubMenuChoices.AgentAndUser com.riskIt.ui.SubMenuChoices.agentMenu com.riskIt.ui.SubMenuChoices.sendInvitation com.riskIt.controller.AgentManager.calculateTotalValue com.riskIt.controller.AgentManager.calculateActualPremium com.riskIt.controller.ZipcodeManager.getOneZipcode
- It queries the table(s) USERRECORD, ZIPTABLE via the chain-call com.riskIt.ui.SubMenuChoices.AgentAndUser com.riskIt.ui.SubMenuChoices.inputForUserQuotes com.riskIt.controller.UserManager.calculateQuoteForCustomer com.riskIt.controller.AgentManager.calculateTotalValue com.riskIt.controller.AgentManager.calculateActualPremium com.riskIt.controller.ZipcodeManager.getOneZipcode
- It queries the table(s) USERRECORD via a call to the com.riskIt.ui.SubMenuChoices.inputForCreateUser method
- It queries the table(s) USERRECORD via the chain-call com.riskIt.ui.SubMenuChoices.browseUserByChoice com.riskIt.controller.UserManager.filterMaritalStatus
- It queries the table(s) USERRECORD via the chain-call com.riskIt.ui.SubMenuChoices.browseUserByChoice com.riskIt.controller.UserManager.filterZipcode
- It queries the table(s) USERRECORD via the chain-call com.riskIt.ui.SubMenuChoices.inputForCreateUser com.riskIt.controller.AgentManager.createNewUser
- It queries the table(s) USERRECORD via the chain-call com.riskIt.ui.SubMenuChoices19_24.CalculateLikelinessToMoveFactorMenu com.riskIt.controller.Requirements19_24.CalculateLikelinessToMoveFactor com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates com.riskIt.controller.Requirements19_24.initializeSsnToZipMap
- It queries the table(s) USERRECORD via the chain-call com.riskIt.ui.SubMenuChoices19_24.FindTopStatesMenu com.riskIt.controller.Requirements19_24.FindTopStatesByCategory com.riskIt.controller.Requirements19_24.FindTopStatesByCode com.riskIt.controller.Requirements19_24.initializeSsnToZipMap
- It queries the table(s) USERRECORD via the chain-call com.riskIt.ui.SubMenuChoices19_24.FindTopStatesMenu com.riskIt.controller.Requirements19_24.FindTopStatesByCode com.riskIt.controller.Requirements19_24.initializeSsnToZipMap
- It queries the table(s) USERRECORD via the chain-call com.riskIt.ui.SubMenuChoices19_24.RecommendBestStateToWorkMenu com.riskIt.controller.Requirements19_24.RecommendBestStateToWork com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates com.riskIt.controller.Requirements19_24.initializeSsnToZipMap
- It queries the table(s) WAGE, JOB, EMPLOYMENTSTAT, WAGE, WAGE, JOB, WAGE, JOB, WAGE via a call to the com.riskIt.controller.UserManager.updatetable method
- It queries the table(s) WAGE, JOB, WAGE, WAGE, WAGE, JOB via a call to the com.riskIt.controller.UserManager.updatewagetable method
- It queries the table(s) WAGE, WAGE, JOB, WAGE, JOB, WAGE, JOB, EMPLOYMENTSTAT, JOB via a call to the com.riskIt.controller.UserManager.userinformation method
- It queries the table(s) ZIPTABLE, USERRECORD, EMPLOYMENTSTAT, ZIPTABLE, USERRECORD via a call to the com.riskIt.controller.UserManager.calculateUnEmploymentRate method
- It queries the table(s) ZIPTABLE, USERRECORD, JOB via a call to the com.riskIt.controller.UserManager.FindTopIndustryCode method
- It queries the table(s) ZIPTABLE, USERRECORD, JOB via a call to the com.riskIt.controller.UserManager.FindTopOccupationCode method
- It queries the table(s) ZIPTABLE via the chain-call com.riskIt.ui.SubMenuChoices19_24.CalculateLikelinessToMoveFactorMenu com.riskIt.controller.Requirements19_24.CalculateLikelinessToMoveFactor com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates com.riskIt.controller.Requirements19_24.initializeZipToStateMap
- It queries the table(s) ZIPTABLE via the chain-call com.riskIt.ui.SubMenuChoices19_24.FindTopStatesMenu com.riskIt.controller.Requirements19_24.FindTopStatesByCategory com.riskIt.controller.Requirements19_24.FindTopStatesByCode com.riskIt.controller.Requirements19_24.initializeZipToStateMap
- It queries the table(s) ZIPTABLE via the chain-call com.riskIt.ui.SubMenuChoices19_24.FindTopStatesMenu com.riskIt.controller.Requirements19_24.FindTopStatesByCode com.riskIt.controller.Requirements19_24.initializeZipToStateMap
- It queries the table(s) ZIPTABLE via the chain-call com.riskIt.ui.SubMenuChoices19_24.RecommendBestStateToWorkMenu com.riskIt.controller.Requirements19_24.RecommendBestStateToWork com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates com.riskIt.controller.Requirements19_24.initializeZipToStateMap
Some constraints that should be taken into the account are the following:
- Make sure the strings to be stored in EDUCATION do not overflow the varchar limits: 50 (EDUCATION, EDUENROLL)
- Make sure the strings to be stored in EMPLOYMENTSTAT do not overflow the varchar limits: 50 (EMPLOYMENTSTAT, UNEMPLOYMENTREASON)
- Make sure the strings to be stored in JOB do not overflow the varchar limits: 50 (WORKCLASS, UNIONMEMBER)
- Make sure the strings to be stored in USERRECORD do not overflow the varchar limits: 50 (TAXSTAT, BIRTHCOUNTRY, NAME, FATHERORIGIN, SEX, MOTHERORIGIN, CITIZENSHIP, MARITAL, RACE), 100 (DETAIL, HOUSEHOLDDETAIL), 5 (ZIP)
- Make sure the strings to be stored in YOUTH do not overflow the varchar limits: 50 (PARENTS)
- When inserting into table EDUCATION, make sure the referential integrity imposed by attribute(s) SSN is accomplished. The foreign keys in the table are the following: (SSN userrecord.SSN)
- When inserting into table EMPLOYMENTSTAT, make sure the referential integrity imposed by attribute(s) SSN is accomplished. The foreign keys in the table are the following: (SSN userrecord.SSN)
- When inserting into table INVESTMENT, make sure the referential integrity imposed by attribute(s) SSN is accomplished. The foreign keys in the table are the following: (SSN userrecord.SSN)
- When inserting into table JOB, make sure the referential integrity imposed by attribute(s) SSN, INDUSTRYCODE, OCCUPATIONCODE is accomplished. The foreign keys in the table are the following: (SSN userrecord.SSN), (INDUSTRYCODE industry.INDUSTRYCODE), (OCCUPATIONCODE occupation.OCCUPATIONCODE)
- When inserting into table YOUTH, make sure the referential integrity imposed by attribute(s) SSN is accomplished. The foreign keys in the table are the following: (SSN userrecord.SSN)
This method invokes db-related operations via delegation:
- It queries the table(s) JOB via the chain-call com.riskIt.controller.Requirements19_24.CalculateLikelinessToMoveFactor com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates com.riskIt.controller.Requirements19_24.initializeSsnToWeekWageMap
- It queries the table(s) JOB via the chain-call com.riskIt.controller.Requirements19_24.CalculateLikelinessToMoveFactor com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates
- It queries the table(s) USERRECORD, JOB, ZIPTABLE, JOB via a call to the com.riskIt.controller.Requirements19_24.CalculateLikelinessToMoveFactor method
- It queries the table(s) USERRECORD via the chain-call com.riskIt.controller.Requirements19_24.CalculateLikelinessToMoveFactor com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates com.riskIt.controller.Requirements19_24.initializeSsnToZipMap
- It queries the table(s) ZIPTABLE via the chain-call com.riskIt.controller.Requirements19_24.CalculateLikelinessToMoveFactor com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates com.riskIt.controller.Requirements19_24.initializeZipToStateMap
This method invokes db-related operations via delegation:
- It creates the table(s) EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It creates the table(s) EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It creates the table(s) EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It drops the TABLE EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It drops the TABLE EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It drops the TABLE EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It inserts values for the first 2 columns of table EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It inserts values for the first 2 columns of table EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It inserts values for the first 2 columns of table EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It queries the table(s) EDUCATION via the chain-call com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeSsnToEducationMap
- It queries the table(s) EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It queries the table(s) EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It queries the table(s) EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It queries the table(s) JOB via the chain-call com.riskIt.controller.Requirements19_24.ComputeAverageEducationString com.riskIt.controller.Requirements19_24.ComputeAverageEducation
This method invokes db-related operations via delegation:
- It creates the table(s) EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It creates the table(s) EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It creates the table(s) EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It drops the TABLE EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It drops the TABLE EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It drops the TABLE EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It inserts values for the first 2 columns of table EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It inserts values for the first 2 columns of table EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It inserts values for the first 2 columns of table EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It queries the table(s) EDUCATION via the chain-call com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeSsnToEducationMap
- It queries the table(s) EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It queries the table(s) EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.ComputeAverageEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It queries the table(s) EDUCATIONMAP via the chain-call com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap com.riskIt.controller.Requirements19_24.getEducationResultSet
- It queries the table(s) JOB via the chain-call com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation com.riskIt.controller.Requirements19_24.ComputeAverageEducation
- It queries the table(s) SELECTION via a call to the com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation method
This method invokes db-related operations via delegation:
- It queries the table(s) SELECTION via a call to the com.riskIt.controller.Requirements19_24.FindTopStatesByCategory method
- It queries the table(s) USERRECORD via the chain-call com.riskIt.controller.Requirements19_24.FindTopStatesByCategory com.riskIt.controller.Requirements19_24.FindTopStatesByCode com.riskIt.controller.Requirements19_24.initializeSsnToZipMap
- It queries the table(s) USERRECORD via the chain-call com.riskIt.controller.Requirements19_24.FindTopStatesByCode com.riskIt.controller.Requirements19_24.initializeSsnToZipMap
- It queries the table(s) ZIPTABLE via the chain-call com.riskIt.controller.Requirements19_24.FindTopStatesByCategory com.riskIt.controller.Requirements19_24.FindTopStatesByCode com.riskIt.controller.Requirements19_24.initializeZipToStateMap
- It queries the table(s) ZIPTABLE via the chain-call com.riskIt.controller.Requirements19_24.FindTopStatesByCode com.riskIt.controller.Requirements19_24.initializeZipToStateMap
This method invokes db-related operations via delegation:
- It queries the table(s) JOB via a call to the com.riskIt.controller.Requirements19_24.RecommendBestStateToWork method
- It queries the table(s) JOB via the chain-call com.riskIt.controller.Requirements19_24.RecommendBestStateToWork com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates com.riskIt.controller.Requirements19_24.initializeSsnToWeekWageMap
- It queries the table(s) JOB via the chain-call com.riskIt.controller.Requirements19_24.RecommendBestStateToWork com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates
- It queries the table(s) USERRECORD via the chain-call com.riskIt.controller.Requirements19_24.RecommendBestStateToWork com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates com.riskIt.controller.Requirements19_24.initializeSsnToZipMap
- It queries the table(s) ZIPTABLE via the chain-call com.riskIt.controller.Requirements19_24.RecommendBestStateToWork com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates com.riskIt.controller.Requirements19_24.initializeZipToStateMap
This method invokes db-related operations via delegation:
- It creates the table(s) AGENTTABLE via the chain-call com.riskIt.ui.SubMenuChoices.AgentLogin com.riskIt.controller.AgentManager.createAgentTable
- It drops the TABLE AGENTTABLE via the chain-call com.riskIt.ui.SubMenuChoices.AgentLogin com.riskIt.controller.AgentManager.createAgentTable
- It inserts values for the first 2 columns of table AGENTTABLE via the chain-call com.riskIt.ui.SubMenuChoices.AgentLogin com.riskIt.controller.AgentManager.createAgentTable
- It queries the table(s) AGENTTABLE via a call to the com.riskIt.ui.SubMenuChoices.AgentLogin method
- It queries the table(s) OCCUPATION, USERRECORD, JOB, EDUCATION, INDUSTRY, INVESTMENT via the chain-call com.riskIt.ui.SubMenuChoices.AgentLogin com.riskIt.ui.SubMenuChoices.agentMenu com.riskIt.ui.SubMenuChoices.sendInvitation com.riskIt.controller.AgentManager.calculateScore
- It queries the table(s) OCCUPATION, USERRECORD, JOB, EDUCATION, INDUSTRY, INVESTMENT via the chain-call com.riskIt.ui.SubMenuChoices.agentMenu com.riskIt.ui.SubMenuChoices.sendInvitation com.riskIt.controller.AgentManager.calculateScore
- It queries the table(s) OCCUPATION, USERRECORD, JOB, EDUCATION, INDUSTRY, INVESTMENT via the chain-call com.riskIt.ui.SubMenuChoices.inputForUserQuotes com.riskIt.controller.UserManager.calculateQuoteForCustomer com.riskIt.controller.AgentManager.calculateScore
- It queries the table(s) USERRECORD, JOB, INVESTMENT via the chain-call com.riskIt.ui.SubMenuChoices.AgentLogin com.riskIt.ui.SubMenuChoices.agentMenu com.riskIt.ui.SubMenuChoices.sendInvitation com.riskIt.controller.AgentManager.calculateScore com.riskIt.controller.ZipcodeManager.getAllZipcodes
- It queries the table(s) USERRECORD, JOB, INVESTMENT via the chain-call com.riskIt.ui.SubMenuChoices.agentMenu com.riskIt.ui.SubMenuChoices.sendInvitation com.riskIt.controller.AgentManager.calculateScore com.riskIt.controller.ZipcodeManager.getAllZipcodes
- It queries the table(s) USERRECORD, JOB, INVESTMENT via the chain-call com.riskIt.ui.SubMenuChoices.inputForUserQuotes com.riskIt.controller.UserManager.calculateQuoteForCustomer com.riskIt.controller.AgentManager.calculateScore com.riskIt.controller.ZipcodeManager.getAllZipcodes
- It queries the table(s) USERRECORD, ZIPTABLE via the chain-call com.riskIt.ui.SubMenuChoices.AgentLogin com.riskIt.ui.SubMenuChoices.agentMenu com.riskIt.ui.SubMenuChoices.sendInvitation com.riskIt.controller.AgentManager.calculateTotalValue com.riskIt.controller.AgentManager.calculateActualPremium com.riskIt.controller.ZipcodeManager.getOneZipcode
- It queries the table(s) USERRECORD, ZIPTABLE via the chain-call com.riskIt.ui.SubMenuChoices.agentMenu com.riskIt.ui.SubMenuChoices.sendInvitation com.riskIt.controller.AgentManager.calculateTotalValue com.riskIt.controller.AgentManager.calculateActualPremium com.riskIt.controller.ZipcodeManager.getOneZipcode
- It queries the table(s) USERRECORD, ZIPTABLE via the chain-call com.riskIt.ui.SubMenuChoices.inputForUserQuotes com.riskIt.controller.UserManager.calculateQuoteForCustomer com.riskIt.controller.AgentManager.calculateTotalValue com.riskIt.controller.AgentManager.calculateActualPremium com.riskIt.controller.ZipcodeManager.getOneZipcode
This method invokes db-related operations via delegation:
- It queries the table(s) OCCUPATION, USERRECORD, JOB, EDUCATION, INDUSTRY, INVESTMENT via the chain-call com.riskIt.ui.SubMenuChoices.sendInvitation com.riskIt.controller.AgentManager.calculateScore
- It queries the table(s) USERRECORD, JOB, INVESTMENT via the chain-call com.riskIt.ui.SubMenuChoices.sendInvitation com.riskIt.controller.AgentManager.calculateScore com.riskIt.controller.ZipcodeManager.getAllZipcodes
- It queries the table(s) USERRECORD, ZIPTABLE via the chain-call com.riskIt.ui.SubMenuChoices.sendInvitation com.riskIt.controller.AgentManager.calculateTotalValue com.riskIt.controller.AgentManager.calculateActualPremium com.riskIt.controller.ZipcodeManager.getOneZipcode
This method invokes db-related operations via delegation:
- It queries the table(s) OCCUPATION, USERRECORD, JOB via a call to the com.riskIt.controller.UserManager.filterOccupation method
- It queries the table(s) USERRECORD, EDUCATION via a call to the com.riskIt.controller.UserManager.filterEducation method
- It queries the table(s) USERRECORD, JOB, INVESTMENT via a call to the com.riskIt.controller.UserManager.filterEstimatedIncome method
- It queries the table(s) USERRECORD via a call to the com.riskIt.controller.UserManager.filterMaritalStatus method
- It queries the table(s) USERRECORD via a call to the com.riskIt.controller.UserManager.filterZipcode method
This method invokes db-related operations via delegation:
- It queries the table(s) OCCUPATION, USERRECORD, JOB, EDUCATION, INDUSTRY, INVESTMENT via the chain-call com.riskIt.controller.UserManager.calculateQuoteForCustomer com.riskIt.controller.AgentManager.calculateScore
- It queries the table(s) USERRECORD, JOB, INVESTMENT via the chain-call com.riskIt.controller.UserManager.calculateQuoteForCustomer com.riskIt.controller.AgentManager.calculateScore com.riskIt.controller.ZipcodeManager.getAllZipcodes
- It queries the table(s) USERRECORD, ZIPTABLE via the chain-call com.riskIt.controller.UserManager.calculateQuoteForCustomer com.riskIt.controller.AgentManager.calculateTotalValue com.riskIt.controller.AgentManager.calculateActualPremium com.riskIt.controller.ZipcodeManager.getOneZipcode
This method invokes db-related operations via delegation:
- It queries the table(s) OCCUPATION, USERRECORD, JOB, EDUCATION, INDUSTRY, INVESTMENT via a call to the com.riskIt.controller.AgentManager.calculateScore method
- It queries the table(s) USERRECORD, JOB, INVESTMENT via the chain-call com.riskIt.controller.AgentManager.calculateScore com.riskIt.controller.ZipcodeManager.getAllZipcodes
- It queries the table(s) USERRECORD, ZIPTABLE via the chain-call com.riskIt.controller.AgentManager.calculateTotalValue com.riskIt.controller.AgentManager.calculateActualPremium com.riskIt.controller.ZipcodeManager.getOneZipcode