Exercise 8.10 Consider the following relation: Emp(eid; integer, sal: integer, age: real,...

Exercise 8.10 Consider the following relation:

  Emp(eid; integer, sal: integer, age: real, did: integer)

There is a clustered index on eid and an unclustered index on age.

1. How would you use the indexes to enforce the constraint that eid is a key?
2. Give an example of an update that is definitely speeded up because of the available indexes. (English description is sufficient.)
3. Give an example of an update that is definitely slowed down because of the indexes. (English description is sufficient.)
4. Can you give an example of an update that is neither speeded up nor slowed down by the indexes?