Guidewire Interview Question

sql nomalisation and avoiding redundant.