Choose an index for each of the following SELECT statements. Specify whether your choice is clustered or unclustered and whether it is a hash index or a B+ tree.
1.SELECT P.Name
FROM Professor P
WHERE P.Id = '0000000'
2.SELECT P.Name
FROM Professor P
WHERE P.Status = 'Faculty'
3.SELECT T.StudId
FROM Transcript T
WHERE T.Grade = 'B' AND T.CrsCode = 'Econ220'
4.SELECT E.Name
FROM Employee E
WHERE E.Salary BETWEEN 20000 AND 100000
5.SELECT T.ProfId
FROM Teaching T
WHERE T.CrsCode LIKE 'Econ%' AND T.Semester = 'S2010'