Atlassian interview question

sql questions on index, normalisations