Question 2. The figure shows traffic entering and exiting a road system (the units are vehicles per hour). Set up an appropriate system of equations. The total time it takes the vehicles to travel any stretch of road is proportional to the traffic along that stretch. That is, the total time it takes 11 vehicles to traverse AB is ko minutes. Assuming that the constant is the same for all sections of road, the total time for all these 200 vehicles to be in this network is kr +2kx2 + kr3 +224 + krs. What is the total time if k = 4? Give the average time for each car. B с 200 D 200 X2 F X2 E

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.

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)

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

Help in SQL.. please take your time 3.12 LAB - Create LessonSchedule table with FK constraints Two tables are created: 1. Horse with columns: - ID - integer, primary key RegisteredName - variable-length string 2. Student with columns: ID - integer, primary key FirstName - variable-length string LastName - variable-length string Create the Lesson Schedule table with columns: • HorselD-integer with range 0 to 65 thousand, not NULL, partial primary key, foreign key references HorseID) • StudentID - integer with range 0 to 65 thousand, foreign key references Student(ID) • LessonDate Time - date/time, not NULL, partial primary key If a row is deleted from Horse, the rows with the same horse ID should be deleted from LessonSchedule automatically. If a row is deleted from Student, the same student IDs should be set to NULL in Lesson Schedule automatically. 387240.1399152.qx3zay? LAB ACTIVITY 3.12.1: LAB - Create Lesson Schedule table with FK constraints 0/10 Main.sql Load default template... 1 CREATE TABLE Horse ( 2 ID SMALLINT UNSIGNED AUTO_INCREMENT, 3 RegisteredName VARCHAR(15), 4. PRIMARY KEY (ID) 5); 7 CREATE TABLE Student ( 8 ID SMALLINT UNSIGNED AUTO_INCREMENT, 9 FirstName VARCHAR(20), 10 LastName VARCHAR(30), 11 PRIMARY KEY (ID) 12 ); 13 If a row is deleted from Student, the same student IDs should be set to NULL in LessonSchedule automatically. SB/270.7399152 gy LAB ACTIVITY 3.12.1: LAB - Create Lesson Schedule table with FK constraints 0/10 Main.sql Load default template... 1 CREATE TABLE Horse 2 2 ID SMALLINT UNSIGNED AUTO_INCREMENT, 3 RegisteredName VARCHAR(15), 4 PRIMARY KEY (ID) 5); 6 7 CREATE TABLE Student 8 ID SMALLINT UNSIGNED AUTO_INCREMENT, 9 FirstName VARCHAR(20), 10 Last Name VARCHAR(30), 11 PRIMARY KEY (ID 12); 13 14 -- Your SQL statements go here 15 16 17 Develop mode Submit mode Explore the database and run your program as often as you'd like, before submitting for grading. Click Run program and observe the program's output in the second box. Main.sql Run program Output (shown below) (Your program) Program output displayed here Coding trail of your work What is this? History of your effort will appear here once you begin working on this zylab.