1. Describe the ACID features/principles of a transaction. For each feature/principle, give an example that violates this feature. Namely, discuss a situation where a principle is violated and the corresponding problem(s). For example, what situation will cause a transaction not atomic. (at least 300 words, show word count).

2. List the name of project that at least one of employee from account division does not work on.

3. List the name of employee and his/her division name, who have MOST accumulated hours working on project. Also list his/her accumulated hours.

4. For each division, list its name and its divisional total salary and its total project the division has (Show three columns in result. (Hint; use correlated subquery in top SELECT clause).

5. Above query (No. 4) cannot be done by simply join three tables as follows, can you tell me why? select dname, sum(salary), count(pid) from division d, employee e, project p where d.did = e.did and d.did = p.did group by dname

6. List the name of employee who work on more projects than employee 'Grace'', Show three columns in result: name of employee, project count of employee, grace's project count.

7. List The name of employee and his/her division who do not work on other division's project (hint: correlated subquery)

8. List the name of project that Chen and Larry both work on but Larry spent more time on it.

9. List the name of division that has at least 2 employees spend more than 30 hours on web development.

10. List the name of the project that every division has some employee(s) working on it. Also list the total number of employees who work on this project.