Task 3 (40 marks)
Part 1 (21 marks)
NOW UK is rolling out a rural area community Wi-Fi network in a number of villages in Nepal’s Myagdi district. They keep track of their equipment in a table similar to that in Table 2. which is stored on a computer in their
Birmingham office. This is just an illustration (with fictitious entries); the actual table used by NOW UK contains many more items and would be continually updated.
Table 2: NOW UK wireless equipment table
Equip- Equipment type Equipment Village Equipment contact person Equipment contact person’s home GPS coordinates Equipment
E1 Satellite connection Arman Subash 28.3735308, 83-4010833 sub@NOWUK.org
E2 Long-distance wireless Arthunge Paras 28.3488018, 83-5523205 paras@NOWUK.org
E3 Long-distance wireless Babiyachaur Ram 287830764, 81 .3949264 ram@NOWUK.org
E4 Community terminal Baranja Ram 287830764, 81 .3949264 ram@NOWUK.org
E5 Community terminal Begkhola Baburam 28.4459126, 83-5762898 bab@NOWUK-org
E6 Community terminal Arman Anil 28.3845245, 83-4099999 anil@NOWUK-org
i. The data in this table is stored in a spreadsheet that looks similar to Table 2.
Explain why this could lead to inconsistencies and why it is inefficient. Illustrate your answer with an example drawn from Table 2.
ii. Given the downsides of storing the table as a spreadsheet. NOW UK is looking for advice on how to store the table as a relational database.
Identify the two entities in Table 2 for which we can store information.
Give the entity table for each of these entities.
Briefly explain how you identified the two entities. If you added any new column(s) to the entity tables (which were not present in Table 2). explain this as well.
iii. Create one joining table that captures the relationship between the two entities you identified in your answer to (ii).
Your answer (excluding tables) to Part 1 of Task 3 must be no more than 290 words.
Part 2 (19 marks)
As already mentioned, NOW UK uses a table similar to that in Table 2 to keep track of their equipment. For this purpose, the table is stored on a computer in their Birmingham office.
i- Explain how NOW UK should take account of the Data Protection Act (DPA)- Do this by:
a paraphrasing in your own words what personal data is
a saying whether, according to the Data Protection Act, the data in Table 2 constitutes ‘personal data’ and explaining why
o saying whether the use as described above constitutes ‘processing’ and explaining why.
ii- Helen works at the Birmingham office of NOW UK. She needs to share equipment contact person details with a maintenance engineer, Maja. on the ground in Nepal- She wants to send the data using an asymmetric cipher.
a how an asymmetric cipher works; illustrate your answer in terms of a message that is sent from Helen to Maja
a how an asymmetric cipher can support the confidentiality of Helen’s message
a how an asymmetric cipher can support the integrity of Helen’s message-