Question Problem 11 What is the SQL command to list the number of product sales (number of rows) and total sales by month, product category, and product, with subtotals by month and product category and a grand total for all sales? Figure P13.11 shows the result of the query. TM MONTH P CATEGORY NUMPROD TOTSALES P CODE 13-02/12 CATI CATI STAT CAN NULL CAT 1611-00 NE Some records omitted in output shown 18 CATE SM11277 NULL CATA 10 NULL NULL 13 101221 NULL NULL Task Complete Problem 11 above. > Below is the Schema for the database: FIGURE 13.20 SALECO SNOWFLAKE SCHEMA DWVENDOR PKV CODE DWREGION PK REG ID REG_NAME 회 DWTIME PK TID TM YEAR TM_MONTH TM_DAY TM QTR V_NAME VAREACODE V STATE DWCUSTOMER PK CUS_CODE CUS_LNAME ++ CUS_FNAME CUS INITIAL CUS_STATE FK1REG_ID DWSALESFACT PK.FK2 IMID PKFK1CUS CODE OPKFKSP_CODE SALE_UNITS SALE PRICE DWPRODUCT PKP_CODE P_DESCRIPT P CATEGORY FK1 CODE

Henry has been hired as a systems analyst to work on an information system project for a library. Currently, books are ordered manually. Three librarians receive a checklist containing details of forthcoming books and journals every week. Each one places checkmarks against the books they think should be ordered. The three marked lists are then reviewed by a head librarian, who finalizes the list of books and the quantity to be ordered. The final list is sent to a clerk, who mails it to the appropriate publishers for orders. a. Draw a context diagram for this situation. b. Draw a level 0 data flow diagram for this situation

For the following exercises, find the lengths of the functions of y over the given interval. If you cannot evaluate the integral exactly, use technology to approximate it. 181. y = 5 - 3x from y = 0 to y = 4 – 4

C. Which of the following organisms are most closely related? Are any two the same species? On what did you base your answer? 2.0 A B D C Rod Rod Coccus Rod + + Fermentative Oxidative Fermentative Fermentative Characteristics Morphology Gram Reaction Glucose utilization Cytochrome oxidase GC moles % Present Present Absent Absent 48-52 23-40 50-54 49-53

For this week's discussion, you are asked to generate a continuous and differentiable function f (2) with the following properties: • f(x) is decreasing at x = -6 • f(x) has a local minimum at x = -3 • f (x) has a local maximum at x = 3 Hints: • Use calculus! • Before specifying a function f (2), first determine requirements for its derivative f' (2). For example, one of the requirements is that f' (-3) = 0. • If you want to find a function g(x) such that g(-9) = 0 and g(8) = 0, then you could try g(x) = (x + 9) (x – 8). • If you have a possible function for f' (2), then use the techniques in Indefinite Integrals this Module to try a possible f (x). You can generate a plot of your function by clicking the plotting option (the page option with a "P" next to your function input). You may want to do this before clicking "How Did I Do?". Notice that the label "f(2) =" is already provided for you. Once you are ready to check your function, click "How Did I Do?" below (unlimited attempts). Please note that the bounds on the x-axis go from -6 to 6. f(x) = How Did I Do? Try Another

CLEARLY PLEASE Toluene is produced by hydroforming conversion of n-heptane in a Cr203@-A1203 catalyst medium. The operating conditions of the process are given on the flow chart. The solvent used in the process is recovered. CH3CH2CH2CH2CH2CH2CH2 - CH3CH3 + 4H2 Toluene production efficiency is 15% based on n-heptane fed into the process. The solvent ratio used in the extractor is 10 kg solvent / 1 kg toluene. According to this, a. Calculate how much heat must be added or removed to keep the reactor isothermal at 425 °C. b. What is the temperature of the n-heptane or solvent stream leaving the extractor. (The temperatures of the n- heptane and solvent streams can be considered the same.) но | 425 °C Cooler n-Heptane Superheater 425 °C 18°C 18 °C Catalytic Reactor HO Saturated Toluene vapour n-Heptane . 38c Solvent Heat Heat Extractor Still Exchanger Separator 18 °C 120 °C Solvent Solvent+Toluene

Chapter 4: Project Management (CPM & PERT TECHNIQUES) QUESTION 1 A network consists of the following list. Times are given in weeks. Preceding Activity A B C D E F G H I J K Duration 9 2 12 5 6 A A A B B CF ဝ ထt D H GI E, ] 3 2 8 6 2 a. Draw the network diagram. b. Which activities form the critical path? c. What is the duration of the project completion? QUESTION 2 A PERT problem is detailed in the table below. Times are given in weeks. Preceding Activity A B с D E F G H I J K A A A B B CF D H GI E,J Optimistic Time 7 2 8 3 4 6 2 2 6 4 2 Probable Time/ Most likely time 9 2 12 5 6 8 3 2 8 6 2 Pessimistic Time 14 8 16 10 8 10 4 8 16 14 5 a. Calculate the expected time and ES, EF, LF, and LS of each activity. b. Draw diagram network for this project. c. What are the project variance and the project standard deviation? d. What is the estimated completion time? e. What is the probability of completion of the project after week 40?