Genie Soft System interview question

basic question on database querys, normalization, joins etc