(a) With the aid of a practical example (two tables), explain the SQLÂ
statement below:
SELECT FIRST_NAME, LAST_NAME, SCHOOL_FEE4
FROM STUDENT, FEE_PAYMENT
WHERE STUDENT.STUDENT_ID = FEE_PAYMENT.STUDENT_ID
ORDER BY FIRST_NAME AP(5)
(b)Using the following passwords “ABCefg12” and “KojoGiggs12” asÂ
examples, discuss the strengths and weaknesses of each password andÂ
discuss what could be done to strengthen them, if they are weakÂ
passwords. AN(8)
(c) Assuming your exam answer booklet for this course in the end ofÂ
semester exams is flagged (indicated) by your antivirus as being infectedÂ
with a virus but you have just about 5 hours to submit/upload yourÂ
answer booklet to lemsas.net. Discuss what you would do to avoid notÂ
submitting your answer booklet and thereby not failing the course.