VerySafe Ltd offer two vaults with electronic locks. They open only after the correct decimal code has been entered. Software Design #1: Costs $302,000, and will facilitate profits of $128,000/year Software Design #2: Costs $4210,000, and will facilitate profits of $129,500/year Which Software Design should they choose? Enter the NPV of the Software Design they should choose: Why do we learn Software Design Patterns? 3. (20015) What is a Software Design Pattern? stem to use demand paged virtual memory for efficiency. What problems could arise here, and how could they be overcome? [6 marks] 0 will contain the precomputed values for this inquiry. In this way the normal and costly question can be responded to by a solitary key-based peruse. (Note: Sum ought to be 0 on the off chance that no matching records exist.) (a) Explain how the activity embed (a, b) into S can be accurately carried out in the {S 0 , R, T} data set. [4 marks] (b) Explain how the activity embed (c, v) into T can be accurately executed in the {S 0 , R, T} information base. [4 marks] (c) Explain how the activity embed (a, c) into R can be accurately executed in the {S 0 , R, T} information base. [4 marks] (d) For an OLTP information base, examine the exhibition ramifications of this supposed streamlining. [4 marks] (e) This model represents a major compromise in the plan and execution of data set applications. Examine. [4 marks] 6 CST.2014.4.7 6 Databases (a) We are given a social pattern R(A, B, C, D, E) and told that the accompanying table addresses a lawful case of R. A B C D E tuple number 1 2 5 4 3 (#1) 1 4 5 4 4 (#2) 2 4 5 4 5 (#3) 2 5 5 4 3 (#4) Which of the accompanying arrangements of practical conditions might hold in R? If a set of conditions can't hold, then make sense of why. You can allude to tuple numbers in your clarification. (I) F1 is the set {A D}. [2 marks] (ii) F2 is the set A, B C E B D, E A [2 marks] (iii) F3 is the set A, B C D, E C A D [4 marks] (b) We are given a social diagram R(Z, W, Y). Assume that in some (right) occasion of R the inquiry (Z,W(R) Z,Y(R)) R isn't vacant. What might we at any point close about the practical reliance Z W? Make sense of your response. [4 marks] (c) during the time spent utilizing practical conditions to standardize an outline, what is implied by a lossless join deterioration and how is such a disintegration ensured? [4 marks] (d) In mapping standardization, is Boyce-Codd Normal Form (BCNF) consistently to be liked over third Normal Form (3NF)? Make sense of your response. 6 Numerical Analysis I (a) For Single Precision in the IEEE binary floating-point standard (IEEE 754) the precision is defined as 24, and the exponent requires 8 bits of storage. With reference to IEEE Single Precision, explain the terms exponent, significand, precision, sign bit, normalised number, denormal number. [6 marks] (b) Explain the term hidden bit. What are the values of the hidden bit for normalised and denormal numbers? How is the exponent stored and why? How are the exponent, significand and sign bit arranged in memory? [4 marks] (c) Let x denote the floating-point representation of a number x. Define the terms absolute error (x) and relative error (x) in representing x. How are x and x related?