(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.
(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.
