A college is using a local area network (LAN) to access data from a database.
a) Give two security measures to protect the data on the college’s computer system.
b) Data regarding new students joining the college is being entered into the database.
Each student has a 7-digit identification number (ID).
A check digit is used as a form of checking to ensure errors have not been made when entering the ID numbers. The verification routine uses modulo-11 with the check digit as the eighth (right-most) digit.
The weightings used to calculate the check digit are: 7, 6, 5, 4, 3, 2 and 1; the value 7 is the multiplier for the left-most digit.
The ID number is: 1 5 6 3 4 1 2
Calculate the check digit.
c) Name and describe two validation checks that could be carried out on the student ID number.