u a R s u s) e d n ) D p rtm n (H m n e u s) (R a mn y e e a e tH ry(H m n e o rce (R a -o ly e a e t u a R so rce e E-olo) D p rtm n isto d plye D p...

I need help completing this excercise. I attched the assignment and the full ERD diagram. 

• Attachment 1
• Attachment 2

1)SELECT nameFROM Department As dept,EmployeedepartmentHistory As empdept,Employee As empWHERE empdept.BusinessEntityId=emp.BusinessEntityId ANDdept.DepartmentID=empdept.departmentIDAND...