Employee (ssn, Name, dno, pid, sal, ...);
Department (dno, dname, mgr_id, ...);
Project (pid, startDate, endDate, ...);
and the following indexes built in the 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