Describe the following terms with reference to security of data: Log files and Firewalls

Distinguish between the following sets of terms as used in spreadsheets. Worksheet and workbook, Filtering and sorting

b) A student’ database comprises of students’ details table and fees received table as shown below:
Students’ details table

​i) State the primary key field for each table. 
ii) State the field, which should serve as the linking field for the two tables.
c) Describe the following terms with respect to computer security:
i) Logic bombs 
ii) Physical security 
iii) Tapping 
d) List three functions of antivirus software.

(i) Log files

• A file that lists actions that have occurred. For example, web servers maintain log files listings every request made to the server. With  log  file  analysis  tools, its possible  to get a good  idea  of where  visitors  are coming from, how often they return  and how they navigate through a site.

ii) Firewalls.          

• A firewall is an information technology (IT) security device which is configured to permit, deny or proxy data connections set and configured by the organization's security policy. Firewalls can either be hardware and/or software based.
•  A firewall!\s basic task is to control traffic between compeer networks with different zones of trust. Typical examples are the Internet which is a zone with no trust and an internal network which is (and should be) a zone with high trust The ultimate goal is to provide controlled interfaces between zones of differing trust  levels through the enforcement of a security policy and connectivity model based on the least privilege principle and separation of duties

b) A students' database comprises of students1 details table and fees received table as shown below:

(i)State the primary key field for each table.

• Student table- Admission Number
• Fees Received table - Receipt Number 

ii) State the field, which should serve as the linking field for the two tables.

• Admission number

(Note: Make Admission Number a foreign key in the fees table)
c) Describe the following terms with respect to computer security:
i)Logic bombs
A computer virus that is activated after a series of event/commands/date
ii) Physical security                                                       
Threats that threaten the physical nature of computer equipment e.g. Fire, Lightening water, building access etc
iii) Tapping.

• Telephone tapping (or wire tapping/wiretapping) is the monitoring of telephone and Internet conversations by a third party, often by covert means. The telephone tap or wire tap received its name because historically, the monitoring connection was applied to the wires of the telephone line of the person who was being monitored and drew off or tapped a small amount of the electrical signal carrying the conversation

(d) List three functions of antivirus software.

• Identify a virus/Warn
• Heal/Clean a virus
• Prevent/Protect infection 
• Quarantine infected files

​​Related Searches on Data Security and Controls, Database, Form 2 Level

Read More