CS507 Assignment No 5 Spring 2012 solution

Question 1: (5 Marks)

Suppose you are appointed as a Network manager in ABC Insurance Company. Your first task is to analysis the security measures for software and data management. You are required to suggest at least five security measures that should be implemented for the company.

 1. Establish strong passwords
Implementing strong passwords is the easiest thing you can do to strengthen your security.

2. Put up a strong firewall
In order to have a properly protected network, “firewalls are a must,

3. Install antivirus protection
Antivirus and anti-malware software are essentials in your arsenal of online security weapons, as well.

4. Backup regularly
Scheduling regular backups to an external hard drive, or in the cloud, is a painless way to ensure that all your data is stored safely.

5. Educate employees
Teaching your employees about safe online habits and proactive defense is crucial.

Question 2: (10 Marks)

Consider an accounting system for an XYZ organization. As the system maintains the accounts of the company, therefore it should be highly secure. Different measures have been taken to implement the security and one is to maintain a detailed log of each activity performed by the user.


Suggest the structure (schema) of this log i.e. the information contained in the log and the exact field names that will be used to store this information. (You are required to give information about each field in one or two lines).


Log File Structure

The transaction log file is a standard comma-delimited ASCII file with the following fields:

    Date/Time, as a numeric string in GMT.

    Name of client who performed the transaction (for example, updating a value in a cube).

    Transaction type: Currently always a “C”to indicate a cube cell change.

    Old value (value before update).

    New value (value after update).

    Name of the cube updated.

Dimension elements that define the intersection updated.