Question (10 Marks) Part II. Analysis (Answer all questions) 1. Find the following parallel schedule.[5 Marks] T2 T read(A) write(A) read(A) write(A) read(B) write(B) read(B) write(B) Convert the above parallel schedule to serial schedule. State whether given schedule is conflict serializable or not. 2. Analyze and discuss how the following schedule is applied cascading rollbacks. Analyze and justify your answer. [5 Marks] T11 T12 T10 read(A) read(B) write(A) read(A) write(A) read(A) Let us assume transaction T10 fails after Write(A) transaction occurs.

In c++ Write a function that adds two hexadecimal strings, each as long as 1,000 digits. Return a hexadecimal string that represents the sum of the inputs.

Biostatistics ESSAY A firm investigates the length of telephone conversations of their office staff. Ten consecutive conversations had lengths, in minutes: 10.7, 9.5, 11.1, 7.8, 11.9, 4.1, 10.0, 9.2, 6.5, 9.2. Derive a 95% confidence interval for the mean conversation length. Test whether the mean length of a conversation is eight minutes.(25 MARKS)

P3.5 The sales revenue, food cost of sales, and guests served for a small fast- food carryout division of a restaurant for the past six months are given below. Sales Month Cost of Revenue Guests Served Sales, Food 1 2. 4 $258,200 274,800 285,600 289,400 298,300 304,600 $ 96,200 104,300 110,500 113,100 118,900 123,700 10,200 10,400 10,300 10,100 10,400 10,500 6 For each of the six months calculate average check and average costs of sales food. Using these averages, calculate an index number. Set the in- dex for month 1 at 100 and complete index numbers for the remaining five months. With the index numbers identified, convert sales revenue and cost of sales food from historic to current dollars.

A cylindrical rock sample has a length of 6 cm, a diameter of 4 cm, and a dry weight of 166.4 g. When fully saturated with an oil of density 0.85 g/cm3, the weight of this sample is 176.9 g. Assuming constant temperature, find: i) The porosity of the sample ii) The pore compressibility of the sample, given that 0.2 cm of oil leaves the sample when a pressure of 3200 psig is applied on it iii) The amount of oil that can be extracted from the sample when a pressure of 2000 psig is applied on it

2.7 LAB - Alter Movie table The Movie table has the following columns: ID - integer, primary key Title - variable-length string Genre - variable-length string RatingCode - variable-length string Year - integer Write ALTER statements to make the following modifications to the Movie table: Add a Producer column with VARCHAR data type (max 50 chars). Remove the Genre column. Change the Year column's name to ReleaseYear, and change the data type to SMALLINT.

Victory Company uses weighted average process costing. The company has two production processes. Conversion cost is added evenly throughout each process. Direct materials are added at the beginning of the first process Additional information for the first process follows Direct Materials Conversion Percent Percent Units Complete Complete Beginning work in process inventory 72, eee 100% 80% Units started this period 833,eee Units completed and transferred out 71e,eee Ending work in process inventory 195, eee 1ees 50% Beginning work in process inventory Direct materials $ 411,775 Conversion 100,938 $ 512, 713 Costs added this period Direct materials 2,755,725 Conversion 1,917,812 4,673,537 Total costs to account for $ 5,186,250 Required: 1. Compute equivalent units of production for both direct materials and conversion Equivalent Units of Production (EUP). Weighted Average Method Units % Materials EUP-Materials % Conversion EUP. Conversion Total units 2. Compute cost per equivalent unit of production for both direct materials and conversion Cost per equivalent unit of production Materials Conversion Costs Costs Total costs Equivalent units of production (from part 1) Cost per equivalent unit of production EUP EUP 0 0 3. Assign costs to the department's output-specifically, to the units transferred out and to the units in ending work in process Inventory (Round "Cost per EUP" to 2 decimal places.) EUP Cost per EUP Total cost Cost assignment-Weighted average Completed and transferred out Direct materials Conversion Total completed and transferred out Ending work in process Direct materials Conversion Total ending work in process Total costs accounted for $ 0 0.00 $ 0.00 S 0