Question: Question 3 [ 5 marks ] : ( Database Security ) Consider the following database that contains information about 1 3 students. The attacker cannot

Question 3[5 marks]: (Database Security)
Consider the following database that contains information about 13 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 (Name=Baker, Sex=Female, Class=1980)
3
Name Sex Major Class SAT GP
Allen Female CS 19786003.4
Baker Female EE 19805202.5
Cook Male EE 19786303.5
Davis Female CS 19788004.0
Evans Male Bio 19795002.2
Frank Male EE 19815803.0
Good Male CS 19787003.8
Hall Female Psy 19795802.8
Iles Male CS 19816003.2
Jones Female Bio 19797503.8
Kline Female Psy 19815002.5
Lane Male EE 19786003.0
Moore Male CS 19796503.5
a.[3 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.[2 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 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 Programming Questions!