Assignment #3 Example | Topics and Well Written Essays - 500 words

3 - Assignment poserDiscuss the final result of the different schedules in Figure 21.3 (a) and (b), where M = 2 and N = 2, with prize to the following questions. Does adding the above condition change the final outcome? Does the outcome obey the implied consistency line up (that the capacity of X is 90)?However, a transaction could end in two ways, When it Commits that is all changes to the database are registered or Rollback when the chances are ignored and database returns to original state.With ARIES, main memory buffers that have been modified are non flushed to disk. ARIES, however writes additional information to the LOG in the form of a Transaction put off and a Dirty Page Table when a checkpoint occurs.No-steal means that the cache (buffer) page updated by a transaction cannot be pen to disk before the transaction commits. Force means that updated pages are written to disk when a transaction commits.24.33- Suppose that privilege (a) of exercise 24.32 is to be given with GRANT cream but only so that account A can grant it to at most fivesome accounts, and each of these accounts can propagate the privilege to other accounts but without the GRANT OPTION privilege. What would the horizontal and unsloped propagation limits be in this case?24.34- Consider the relation shown in Figure 24.2 (d). How would it appear to a user with classification U? Suppose a classification U user tries to update the compensation of Smith to $50,000 what would be the result of this