Menu 200 000.00 1 Kama Aly No You 2150000 40 No Yes N) No Ya Yes 1 1 4 A Labara Tos Question One The table below is the students loan records extracted from the Students Loan Trust (SLT) Mice for students who graduated from universities between 2005 and 2013. Use the table to answer the questions below. in your answer booklet (30 Marbis) Student Pun Name Surname DOD Leonbelco Alla Mool Dependent (melovers Write of 01/24/01 Bridge 11/1/7 18.000.00 Rutlyn 11/10/10 10/19/95 305.000.00 25 No am2 92.000.00 28 Yes S/16/% 000.00 31 Yos 10/11/01 17.0000019 9/23/25 1.000.00 11/10/22 245.00000 28 02125728 107.000.00 4 A. While considering all the necessary constraints and retributes, write R statements to represent the structure of the above relation - 10 Marks B. Write a statements to sum up the outstanding loan balance of all unemployed graduates wbose loan balance have not been written-oll-S marks C. Assuming 45% of all write-off loans were to be reinstated (laken back), compute 35% of the total outstanding loans balance - Marks D. Assuming the SLT oMice decides to write-off the outstanding foam balance for all those with 4 or more dependents, compute the 3 quantilo of the outstanding loan balance - 7 Marks Question. Two A. "With vast amounts of data now available, companies in almost every industry are focused on exploiting data for competitive advantage". With reference to specific examples, explain four (1) ways GIMPA as an institute carl explole the principles of data analytics to increase its Nelson Patrid Thomas lelor Nicoli Duvis Lean 3 2 5 4 Yes NS Yo NS Yes You NO NO No Menu 200 000.00 1 Kama Aly No You 2150000 40 No Yes N) No Ya Yes 1 1 4 A Labara Tos Question One The table below is the students loan records extracted from the Students Loan Trust (SLT) Mice for students who graduated from universities between 2005 and 2013. Use the table to answer the questions below. in your answer booklet (30 Marbis) Student Pun Name Surname DOD Leonbelco Alla Mool Dependent (melovers Write of 01/24/01 Bridge 11/1/7 18.000.00 Rutlyn 11/10/10 10/19/95 305.000.00 25 No am2 92.000.00 28 Yes S/16/% 000.00 31 Yos 10/11/01 17.0000019 9/23/25 1.000.00 11/10/22 245.00000 28 02125728 107.000.00 4 A. While considering all the necessary constraints and retributes, write R statements to represent the structure of the above relation - 10 Marks B. Write a statements to sum up the outstanding loan balance of all unemployed graduates wbose loan balance have not been written-oll-S marks C. Assuming 45% of all write-off loans were to be reinstated (laken back), compute 35% of the total outstanding loans balance - Marks D. Assuming the SLT oMice decides to write-off the outstanding foam balance for all those with 4 or more dependents, compute the 3 quantilo of the outstanding loan balance - 7 Marks Question. Two A. "With vast amounts of data now available, companies in almost every industry are focused on exploiting data for competitive advantage". With reference to specific examples, explain four (1) ways GIMPA as an institute carl explole the principles of data analytics to increase its Nelson Patrid Thomas lelor Nicoli Duvis Lean 3 2 5 4 Yes NS Yo NS Yes You NO NO No