Question: Question 3 [ 5 marks ] : ( Database Security ) Consider the following database that contains information about 1 3 students. The attacker cannot
Question marks: Database Security
Consider the following database that contains information about students. The attacker cannot
directly access the database and can only issue statistical queries count and sum The field
Name is a sensitive one. The attacker has the following background information about one of the
students NameBaker, SexFemale, Class
Name Sex Major Class SAT GP
Allen Female CS
Baker Female EE
Cook Male EE
Davis Female CS
Evans Male Bio
Frank Male EE
Good Male CS
Hall Female Psy
Iles Male CS
Jones Female Bio
Kline Female Psy
Lane Male EE
Moore Male CS
a marks Using statistical queries count and sum and depending on the provided
dataset, how can the attacker know Bakers SAT Remember that Name is a sensitive
field and cannot be part of any query
b marks How can we prevent the attacker from knowing Bakers GP
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
