Hi, here you will find project 1 (xquery) including the extra credit

Queries:
1) Temporal Projection. Retrieve the employment history of employee 'Anneke Preusig' (i.e., the departments where she worked and the periods during which she worked there).
xquery Results Extra Credit
2) Temporal Snapshot. Retrieve the name and the salary of each employees on 1995-05-06, who was making less than $ 45000 at that time.
xquery Results Extra Credit
3) Temporal Slicing. For all departments, show their manager history in the period starting on 1994-05-06 and ending 1995-05-06.
xquery Results Extra Credit
4) Duration: For each employee, show the longest period during which he/she went with no change in salary and his/her salary during that time.
xquery Results Extra Credit
5) Temporal Join. For each employee, show his/her title history and hi/her manager history.
xquery Results Extra Credit
6) Snapshot Count: For each department, show the count of employees who worked in the department in year 1999.
xquery Results Extra Credit
7) Temporal Aggregate. For each department show the history of employee count in the department over time.
xquery Results Extra Credit