Tutor profile: Brian R.
Subject: SQL Programming
Corporate bank ABC’s design team has come up with a new, user-friendly design of an online loan application. You have been asked to analyze the new design. What metrics/data would you want to track in order to evaluate the success of the redesign?
In order to evaluate the success of the design, it should be evaluated that the data requested through the application are not redundant and are standardized according to the relational database design; therefore it is expected to have the appropriate entities such as the following: • Personal data of the Customer • Customer work data • Customer financial data • Loans offered by the bank • Request tracking table In addition to these entities we can mention some attributes such as the following: • Name, Last name, address, zip code, date of birth, social security number, • Company name, Role, salary, time in the company. • Debts payable, debts receivable, savings. • Type of loan, loan amount, number of installments, the percentage of interest. • Request number, date of the request.
Subject: Information Technology
What is an XSS (Cross Site Scripting) attack? What should be done on a server to prevent this type of attack?
What’s the most popular genre of music style in the database of entertainers?
select StyleName,max(popular) from ( select count(ea_entertainer_styles.StyleID) as popular,ea_music_styles.StyleName from ea_entertainer_styles,ea_music_styles where ea_entertainer_styles.StyleID=ea_music_styles.StyleID group by ea_entertainer_styles.StyleID ) as t;
needs and Brian will reply soon.