Shell Interview Question

what is normalization differences between indexing and identity what are joins