Anonymize relational data Sql Scripts

generate-test-data.sql

create table Person(
social_security_number int,
name varchar(50)
)

create table transactions(
	person_social_security_number int,
	month int,
	amount decimal
)

insert into Person (social_security_number,name) values
(19151, 'Tasha Robles'),
(13462, 'Malak Adam'),
(19968, 'Caden Buckner'),
(16057, 'Bonita Leonard'),
(10083, 'Yassin Broadhurst'),
(15442, 'Harri Cook'),
(15948, 'Juno Crouch'),
(13353, 'Domas Simmonds'),
(19358, 'Brenden Ellison'),
(12051, 'Dayna Noble')


insert into transactions (person_social_security_number,month,amount)
values
(19151, 1 , 6760),
(13462, 5 , 1442),
(19968, 9 , 7343),
(16057, 8 , 9443),
(10083, 4 , 2103),
(15442, 8 , 2463),
(15948, 7 , 7702),
(13353, 12 , 5287),
(19358, 12 , 5469),
(12051, 6 , 5741),
(19151, 10 , 7757),
(13462, 4 , 5693),
(19968, 1 , 3258),
(16057, 1 , 711),
(10083, 12 , 1040),
(15442, 2 , 9354),
(15948, 8 , 8279),
(13353, 6 , 2155),
(19358, 6 , 1865),
(12051, 5 , 7366),
(19151, 2 , 1514),
(13462, 12 , 537),
(19968, 10 , 6230),
(16057, 4 , 6856),
(10083, 7 , 5596),
(15442, 10 , 147),
(15948, 7 , 7152),
(13353, 5 , 1700),
(19358, 6 , 2326),
(12051, 6 , 8881),
(19151, 1 , 7866),
(13462, 5 , 7497),
(19968, 4 , 8367),
(16057, 9 , 4269),
(10083, 1 , 1153),
(15442, 12 , 6368),
(15948, 3 , 5383),
(13353, 12 , 7951),
(19358, 7 , 8103),
(12051, 7 , 1505),
(19151, 11 , 5338),
(13462, 1 , 4871),
(19968, 8 , 1157),
(16057, 2 , 4658),
(10083, 4 , 887),
(15442, 7 , 7402),
(15948, 10 , 4656),
(13353, 8 , 2227),
(19358, 8 , 8906),
(12051, 5 , 5866),
(19151, 9 , 9184),
(13462, 1 , 4568),
(19968, 4 , 4620),
(16057, 12 , 1115),
(10083, 11 , 7981),
(15442, 7 , 2468),
(15948, 9 , 9916),
(13353, 3 , 7926),
(19358, 12 , 4237),
(12051, 9 , 6879),
(19151, 12 , 4501),
(13462, 3 , 6587),
(19968, 6 , 1010),
(16057, 8 , 5590),
(10083, 1 , 3741),
(15442, 12 , 3433),
(15948, 9 , 9361),
(13353, 3 , 5348),
(19358, 2 , 650),
(12051, 11 , 4415),
(19151, 10 , 5554),
(13462, 12 , 9662),
(19968, 6 , 5567),
(16057, 10 , 7458),
(10083, 7 , 5435),
(15442, 2 , 859),
(15948, 8 , 8166),
(13353, 6 , 5934),
(19358, 12 , 9295),
(12051, 4 , 5071),
(19151, 10 , 1420),
(13462, 3 , 882),
(19968, 5 , 364),
(16057, 3 , 8336),
(10083, 2 , 991),
(15442, 11 , 474),
(15948, 4 , 8328),
(13353, 11 , 2106),
(19358, 1 , 8471),
(12051, 10 , 1168),
(19151, 6 , 2634),
(13462, 5 , 4730),
(19968, 10 , 7099),
(16057, 9 , 267),
(10083, 5 , 4755),
(15442, 12 , 3938),
(15948, 6 , 1027),
(13353, 10 , 3762),
(19358, 7 , 6729),
(12051, 10 , 7668)