Question: Question 3 (25 marks) - Security/Emerging databases The CEO, John Smith, is concerned about security of the multi-user database used in MICE. a) Explain to

 Question 3 (25 marks) - Security/Emerging databases The CEO, John Smith,

Question 3 (25 marks) - Security/Emerging databases The CEO, John Smith, is concerned about security of the multi-user database used in MICE. a) Explain to him the meaning of Discretionary Access Control (DAC) and how it differs from Mandatory Access Control (MAC). [2 marks] b) Provide the syntax for the two commands in SQL which support DAC. [ 4 marks ] c) Give an example of how different employee roles within the MICE organisation might require different data access. Explain how this can be implemented and the interaction between users, roles and views in an MAC scenario. [6 marks d) You have concerns about the new web-site through which customers book and pay for their cinema tickets and other products, explain to John what SQL Injection attacks are and what you need to check to ensure the web-site cannot allow unauthorised access to database data. [7 marks ] John Smith has heard about Big Data and is wondering if it is something he could use at MICE. e) Explain to him what Big Data means, include a description of the three V's and provide examples to support your descriptions (not necessarily related to MICE and its operations). [6 marks ]

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!