here in this question
sql does not remove duplicate. we have to use distinct word to remove duplicate
and in sql also we cant repeat the names of attribute
and without index also we can work just the work will be slow. index just speed up the searches in the database. index cant be seen by the user.