Expect that R(A, B, C) is a social planning with viable circumstances F = {A, B C, C B}. (I) Is this graph in 3NF? Get a handle on. [2 marks] (ii) Is this graph in BCNF? Get a handle on. [2 marks] (b) Decomposition expects a critical part in informational index plan. (I) Define what is suggested by a lossless-join crumbling. [2 marks] (ii) Define what is suggested by a dependence saving crumbling. [2 marks] (c) Let R(A, B, C, D, E) be a social example with the going with valuable circumstances I) What is the finish of {A, B}? [2 marks] (ii) What is the finish of {B, E}? [2 marks] (iii) Decompose the outline to BCNF in two exceptional ways. For every circumstance, are conditions saved? Figure out. [4 + 4 marks] Expect that R(A, B, C) is a social example with helpful circumstances F = {A, B C, C B}. (I) Is this example in 3NF? Figure out. [2 marks] (ii) Is this framework in BCNF? Figure out. [2 marks] (b) Decomposition expects a huge part in informational index plan. (I) Define what is suggested by a lossless-join deterioration. [2 marks] (ii) Define what is inferred by a dependence shielding disintegration. [2 marks] (c) Let R(A, B, C, D, E) be a social example with the going with viable circumstances I) What is the finish of {A, B}? [2 marks] (ii) What is the finish of {B, E}? [2 marks] (iii) Decompose the example to BCNF in two unmistakable ways. For every circumstance, are conditions saved? Get a handle on. [4 + 4 marks]

For a trade model considering things and thing action time-stamps: (a) (I) Define how battle may be resolved concerning object action semantics. (ii) Give an occurrence of conflicting exercises. (iii) Give an outline of non-conflicting exercises that would be described as conflicting under read-form semantics. [3 marks] (b) Define the central and sufficient condition for two trades to be serialisable. Give a delineation of a non-serialisable execution of several trades. [3 marks] (c) Define the fundamental and sufficient condition for many trades to be serialisable. [1 mark] (d) Discuss how the going with methods for giving concurrence control in informational index systems carry out the properties portrayed beforehand. (I) Strict two-stage locking. [4 marks] (ii) Strict timestamp mentioning. [4 marks] (iii) Optimistic synchronization control. [5 marks]

) Concerning virtual memory the leaders: completed? [4 marks] (ii) What is an inferred by transient area of reference? [2 marks] (iii) How does the doubt of transient area of reference affect page replacement decisions? Frame your reaction by quickly depicting a fitting page replacement estimation or computations. [3 marks] (iv) What is a suggested by spatial area of reference? [2 marks] (v) In what ways does the doubt of spatial area of reference affect the arrangement of the virtual memory system? [3 marks] (b) Buses are used to relate devices to the processor. (I) Describe with the aide of a graph the movement of a planned vehicle. [4 marks] (ii) In what ways does a nonconcurrent transport contrast? For a trade model considering things and thing action time-stamps: (a) (I) Define how battle may be resolved concerning object action semantics. (ii) Give an occurrence of conflicting exercises. (iii) Give an outline of non-conflicting exercises that would be described as conflicting under read-form semantics. [3 marks] (b) Define the central and sufficient condition for two trades to be serialisable. Give an outline of a non-serialisable execution of several trades. [3 marks] (c) Define the fundamental and satisfactory condition for many trades to be serialisable. [1 mark] (d) Discuss how the going with systems for giving synchronization control in informational index structures carry out the properties portrayed beforehand. (I) Strict two-stage locking. [4 marks] (ii) Strict timestamp mentioning. [4 marks] (iii) Optimistic synchronization control. [5 marks]

) Concerning virtual memory the board: executed? [4 marks] (ii) What is inferred by transient area of reference? [2 marks] (iii) How does the notion of common domain of reference influence page replacement decisions? Address your reaction by immediately portraying a fitting page replacement estimation or computations. [3 marks] (iv) What is an inferred by spatial area of reference? [2 marks] (v) In what ways does the doubt of spatial district of reference affect the arrangement of the virtual memory structure? [3 marks] (b) Buses are used to connect contraptions to the processor. (I) Describe with the aide of a chart the action of an organized vehicle. [4 marks] (ii) In what ways does a strange vehicle differentiate?