Question
Employee (ssn, Name, dno, pid, sal,);
Department (dno, dname, mgr_id, ...);
Project (pid, startDate, endDate, ...);
and the following indexes built in database-
1. hash index on Department.dname
2. B+-tree on Project.startDate
3. Hash index on Employee.dno
4. B+-tree on Project.pid