DbScribe report

DBScribe report

Summary: 35 methods with SQL local invocations, 9 methods mixing local and delegated SQL invocations, and 44 methods with only delegated SQL invocations.

Methods

Methods with local invocations:

com.riskIt.controller.AgentManager.createAgentTable()

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

com.riskIt.controller.AgentManager.createNewUser(String, String, long, int, String, String, String, String, String, String, String, String, String, String, int, int, int, String, String, String, String, String, String, String, int, int, int, int, int, int)

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)

com.riskIt.controller.AgentManager.deleteUser(String)

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

com.riskIt.controller.CalculateByEducation.calculateValue(String, CalcImplInterface)

This method implements the following db-related operations:

- It queries the table(s) JOB, EDUCATION

com.riskIt.controller.CalculateByEducation.getEducationLevelList()

This method implements the following db-related operations:

- It queries the table(s) EDUCATION

com.riskIt.controller.CalculateByOccupationOrIndustryCode.calculateResult(int, CalcImplWithDescriptionInterface)

This method implements the following db-related operations:

- It queries the table(s) JOB

com.riskIt.controller.CalculateByOccupationOrIndustryCode.getIndustryCodeAndNameMap()

This method implements the following db-related operations:

- It queries the table(s) INDUSTRY

com.riskIt.controller.CalculateByOccupationOrIndustryCode.getIndustryCodeList()

This method implements the following db-related operations:

- It queries the table(s) INDUSTRY

com.riskIt.controller.CalculateByOccupationOrIndustryCode.getOccupationCodeAndNameMap()

This method implements the following db-related operations:

- It queries the table(s) OCCUPATION

com.riskIt.controller.CalculateByOccupationOrIndustryCode.getOccupationCodeList()

This method implements the following db-related operations:

- It queries the table(s) OCCUPATION

com.riskIt.controller.CalculateByRace.calculateValue(String, CalcImplInterface)

This method implements the following db-related operations:

- It queries the table(s) JOB, USERRECORD

com.riskIt.controller.CalculateByRace.getRaceList()

This method implements the following db-related operations:

- It queries the table(s) USERRECORD

com.riskIt.controller.CalculateByState.calculateIncome(String, CalcImplInterface)

This method implements the following db-related operations:

- It queries the table(s) ZIPTABLE, JOB, USERRECORD

com.riskIt.controller.CalculateByState.getStateList()

This method implements the following db-related operations:

- It queries the table(s) ZIPTABLE

com.riskIt.controller.EstimateIncome.calculateSlopesAndIntercepts()

This method implements the following db-related operations:

- It queries the table(s) JOB, INVESTMENT

com.riskIt.controller.EstimateIncome.getValues(int)

This method implements the following db-related operations:

- It queries the table(s) USERRECORD, INVESTMENT, EDUCATION, JOB

com.riskIt.controller.Requirements19_24.getEducationResultSet(String[])

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

com.riskIt.controller.Requirements19_24.initializeSsnToEducationMap(HashMap)

This method implements the following db-related operations:

- It queries the table(s) EDUCATION

com.riskIt.controller.Requirements19_24.initializeSsnToWeekWageMap(HashMap)

This method implements the following db-related operations:

- It queries the table(s) JOB

com.riskIt.controller.Requirements19_24.initializeSsnToZipMap(HashMap)

This method implements the following db-related operations:

- It queries the table(s) USERRECORD

com.riskIt.controller.Requirements19_24.initializeZipToStateMap(HashMap)

This method implements the following db-related operations:

- It queries the table(s) ZIPTABLE

com.riskIt.controller.UserManager.FindTopIndustryCode(String)

This method implements the following db-related operations:

- It queries the table(s) ZIPTABLE, USERRECORD, JOB

com.riskIt.controller.UserManager.FindTopOccupationCode(String)

This method implements the following db-related operations:

- It queries the table(s) ZIPTABLE, USERRECORD, JOB

com.riskIt.controller.UserManager.calculateUnEmploymentRate(String)

This method implements the following db-related operations:

- It queries the table(s) ZIPTABLE, USERRECORD, EMPLOYMENTSTAT, ZIPTABLE, USERRECORD

com.riskIt.controller.UserManager.filterEducation(String)

This method implements the following db-related operations:

- It queries the table(s) USERRECORD, EDUCATION

com.riskIt.controller.UserManager.filterEstimatedIncome(String)

This method implements the following db-related operations:

- It queries the table(s) USERRECORD, JOB, INVESTMENT

com.riskIt.controller.UserManager.filterMaritalStatus(String)

This method implements the following db-related operations:

- It queries the table(s) USERRECORD

com.riskIt.controller.UserManager.filterOccupation(String)

This method implements the following db-related operations:

- It queries the table(s) OCCUPATION, USERRECORD, JOB

com.riskIt.controller.UserManager.filterZipcode(String)

This method implements the following db-related operations:

- It queries the table(s) USERRECORD

com.riskIt.controller.UserManager.updatestability(String, int, int)

This method implements the following db-related operations:

- It queries the table(s) INDUSTRY, ZIPTABLE, USERRECORD, JOB, ZIPTABLE, USERRECORD, JOB, EMPLOYMENTSTAT, OCCUPATION

com.riskIt.controller.UserManager.updatetable(long, int, int)

This method implements the following db-related operations:

- It queries the table(s) WAGE, JOB, EMPLOYMENTSTAT, WAGE, WAGE, JOB, WAGE, JOB, WAGE

com.riskIt.controller.UserManager.updatewagetable(int, int)

This method implements the following db-related operations:

- It queries the table(s) WAGE, JOB, WAGE, WAGE, WAGE, JOB

com.riskIt.controller.UserManager.userinformation(long, int, int)

This method implements the following db-related operations:

- It queries the table(s) WAGE, WAGE, JOB, WAGE, JOB, WAGE, JOB, EMPLOYMENTSTAT, JOB

com.riskIt.controller.ZipcodeManager.getAllZipcodes(String)

This method implements the following db-related operations:

- It queries the table(s) USERRECORD, JOB, INVESTMENT

com.riskIt.controller.ZipcodeManager.getOneZipcode(Invitation)

This method implements the following db-related operations:

- It queries the table(s) USERRECORD, ZIPTABLE

Methods with mixed invocations:

com.riskIt.controller.AgentManager.calculateScore(long)

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

com.riskIt.controller.Requirements19_24.CalculateAverageWageForOccupationForAllStates(int, String[], double[])

com.riskIt.controller.Requirements19_24.CalculateLikelinessToMoveFactor(int)

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

com.riskIt.controller.Requirements19_24.ComputeAverageEducation(String, int)

com.riskIt.controller.Requirements19_24.FindCccupationIndustryWithHighestLowestEducation(String)

com.riskIt.controller.Requirements19_24.FindTopStatesByCategory(String, String)

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

com.riskIt.controller.Requirements19_24.RecommendBestStateToWork(int)

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

com.riskIt.ui.SubMenuChoices.AgentLogin()

com.riskIt.ui.SubMenuChoices.inputForCreateUser()

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)

Methods with only delegated invocations:

com.riskIt.app.MainClass.main(String[])

com.riskIt.app.testCalculateScoreDriver.main(String[])

com.riskIt.app.testCustomerQuotesDriver.main(String[])

com.riskIt.app.testLiklinessToMoveFactor.main(String[])

com.riskIt.controller.AgentManager.calculateActualPremium(Invitation, double, double)

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

com.riskIt.controller.AgentManager.calculateTotalValue(Invitation)

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

com.riskIt.controller.CalculateByEducation.calculateIncomeByAllEducationLevels()

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

com.riskIt.controller.CalculateByEducation.calculateIncomeByEducationLevel(String)

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

com.riskIt.controller.CalculateByEducation.calculateWeeklyWageByAllEducationLevels()

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

com.riskIt.controller.CalculateByEducation.calculateWeeklyWageByEducationLevel(String)

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

com.riskIt.controller.CalculateByEducation.isInEducationList(String)

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

com.riskIt.controller.CalculateByOccupationOrIndustryCode.calculateIncomeByIndustryCode(int)

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

com.riskIt.controller.CalculateByOccupationOrIndustryCode.calculateIncomeByOccupationCode(int)

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

com.riskIt.controller.CalculateByOccupationOrIndustryCode.calculateWeeklyWageByIndustryCode(int)

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

com.riskIt.controller.CalculateByOccupationOrIndustryCode.calculateWeeklyWageByOccupationCode(int)

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

com.riskIt.controller.CalculateByOccupationOrIndustryCode.isValidIndustryCode(int)

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

com.riskIt.controller.CalculateByOccupationOrIndustryCode.isValidOccupationCode(int)

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

com.riskIt.controller.CalculateByRace.calculateIncomeByAllRaces()

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

com.riskIt.controller.CalculateByRace.calculateIncomeByRace(String)

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

com.riskIt.controller.CalculateByRace.calculateWeeklyWageByRace(String)

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

com.riskIt.controller.CalculateByRace.calculateWeelkyWageByAllRaces()

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

com.riskIt.controller.CalculateByRace.isInRaceList(String)

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

com.riskIt.controller.CalculateByState.calculagteWeeklyWageByAllState()

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

com.riskIt.controller.CalculateByState.calculateIncomeByAllStates()

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

com.riskIt.controller.CalculateByState.calculateIncomeByState(String)

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

com.riskIt.controller.CalculateByState.calculateWeeklyWageByState(String)

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

com.riskIt.controller.CalculateByState.isInStateList(String)

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

com.riskIt.controller.EstimateIncome.EstimateIncome()

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

com.riskIt.controller.Requirements19_24.ComputeAverageEducationString(String, int)

com.riskIt.controller.Requirements19_24.FindTopStatesByCode(String, ArrayList)

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

com.riskIt.controller.Requirements19_24.initializeEducationToLevelHashMap(HashMap)

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

com.riskIt.controller.Requirements19_24.initializeLevelToEducationHashMap(HashMap)

com.riskIt.controller.UserManager.calculateQuoteForCustomer(long, double, double, ArrayList)

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

com.riskIt.ui.MenuChoices.mainMenu()

com.riskIt.ui.SubMenuChoices19_24.CalculateLikelinessToMoveFactorMenu()

com.riskIt.ui.SubMenuChoices19_24.ComputeAverageEducationMenu()

com.riskIt.ui.SubMenuChoices19_24.FindOccIndustryWithHighestLowestEducationMenu()

com.riskIt.ui.SubMenuChoices19_24.FindTopStatesMenu(String)

com.riskIt.ui.SubMenuChoices19_24.RecommendBestStateToWorkMenu()

com.riskIt.ui.SubMenuChoices.AgentAndUser()

com.riskIt.ui.SubMenuChoices.agentMenu()

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

com.riskIt.ui.SubMenuChoices.browseUserByChoice()

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

com.riskIt.ui.SubMenuChoices.inputForUserQuotes()

com.riskIt.ui.SubMenuChoices.sendInvitation()