Overview The human body can regulate its function responding to the change of its environment. Temperature is one of the factors which can modulate the body function. Refer to the related lectures and other resources; answer the followed questions (question 1-5 need at least 400 words together): Q1 In case of cold weather how does human body detect the coldness? Explain the signal detection, delivery, processing and involved cells, tissues and organs.
The chief brain mechanisms for heat regulation are established … Read More...
Lab #03 Studying Beam Flexion Summary: Beams are fundamental structural elements used in a variety of engineering applications and have been studied for centuries. Beams can be assembled to create large structures that carry heavy loads, such as motor vehicle traffic. Beams are also used in micro- or nano-scale accelerometers to delicately measure and detect motions that trigger the deployment of an airbag. From a technical standpoint, a beam is a structure that supports transverse load. Transverse load is load that is perpendicular to the long axis of the beam. As a result, of transverse load, beams undergo bending, in which the beam develops a curvature. As the beam bends, material fibers along the beam’s long axis are forced to stretch or contract, which in turn causes a resistance to the bending. The fibers that are the farthest away from the center of the beam are forced to stretch or contract the most and thus, material at these extremities is the most important to resist bending and deflection. This topic is studied quantitatively in Strength of Materials (CE-303). Purpose: The purpose of this assignment is to accomplish the following goals: • Develop a simple experiment to achieve a goal. • Statistically and observationally analyze your data and interpret the results. • Summarize and present your data, results and interpretations. Procedure: 1. Working as a team, develop a procedure to carefully document the amount of bending a beam under-goes as loads are placed on it (this is your experimental protocol). You must select at least two different beam styles. 2. Collect the data points your experimental protocol calls for. You should conduct at least three trials and the order of data collection within those trials should be randomized. 3. Using the provided Excel deflection calculator, calculate the “predicted” deflection for each of the trials in your protocol. 4. Please observe the following MAXIMUM test torques to avoid damaging the beams. • Width Effect Beams: Small beam: 48 in-lbs, Medium beam: 80 in-lbs, Large beam: 120 in-lbs • Depth Effect Beams: Small beam: 8 in-lbs, Medium beam: 48 in-lbs, Large beam: 160 in-lbs Report and Presentation Requirements: 1. Title Page: Should include the title of the lab experiment, groups individual names (in alphabetical order by last name), data collection date, report due date, and course name and section. 2. Introduction: Briefly explain what you are trying to accomplish with this experiment. 3. Hypothesis Development: Should clearly state the three hypotheses, with respect to distance, beam size, and calculated versus actual deflection. Be sure to include logic to support your educated guess. 4. Method: Explain each activity performed during the data collection and analysis process. Provide a list of the equipment used and its purpose. 5. Analysis and Results: (1) Using the raw data, provide a table of descriptive statistics (mean, variance, and range) for each beam at each distance. (2) Provide a data table (average across 3 trials) showing the deflection for each beam at each distance. (3) Create one or more charts demonstrating the difference, if any, between the calculated and observed deflection for each beam. (4) Use the t-Test: Paired Two Sample for Means in Excel to determine if there is a statistically significant difference between predicted (calculated) deflection and actual (observed) deflection, assuming α = 0.05. Show the results for each beam. Note: To add in the Data Analysis package (under the data tab), go to Office Button -> Excel Options -> Add-Ins -> Manage Excel Add-Ins -> GO… -> check Analysis TookPak and click OK. For each table or chart, provide a description and explanation of what is being displayed. 6. Conclusions: Restate the hypotheses and explain whether or not the educated guess was correct. Include limitations of the experiment (in other words, describe other factors that would make the experiment better or possible errors associated with the experiment). Provide suggestions for future research. 7. Last Page: Include, at the end of the document, a summary of all the tasks required to complete the assignment, and which member or members of the group were principally responsible for completing those tasks. This should be in the form of a simple list. 8. Presentation: Summarize the report, excluding the last page. Due Date: This assignment is to be completed and turned in at the beginning of your laboratory meeting during the week of 11th March. Microsoft office package: Excel: Data tab functions, round, drag-drop, $-sign functions, Beginning of analysis toolpak-t-tests
The rationale for self-exploration and personal therapy for helpers is that a) If helpers are unaware of issues stemming from their family experiences, they are likely to find way to avoid acknowledging and dealing with potentially painful areas with their clients b) As clients confront events that trigger their pain , memories of helpers own c) Both of the above d) Neither of the above
Deliverable V – Stored Procedures sProc #1: Modify the Product_Category (or Model) table to include a new Boolean attribute called reorderNecessary that will be set to true when an item needs to be reordered. The attribute should default to false. [do this prior to writing stored procedure] Since the default value may not be valid for all the data in your table, write a stored procedure to set the value of the new reorderNecessary attribute to its correct value. o If the modelInventoryCount is less than or equal to the modelReorderQuantity, then set the reorderNecessary value to true. o Otherwise set the reorderNecessary value to false. o Execute the procedure to reset the value. sProc #2: The next stored program is more complex. When an item is purchased by credit card, the card number must be validated. The algorithm to accomplish this is fairly straightforward, and consists of three steps. These steps are performed by working from the rightmost digit of the credit card number. o Step 1: Double the value of alternate digits of the primary account number beginning with the second digit from the right (the right-most digit is the check digit.) o Step 2: Still working from the right, add the individual digits comprising the products obtained in Step 1 to each of the unaffected digits in the original number. For example, if the product is 12 then add 1 + 2 to the unaffected digit to the right. o Step 3: The total obtained in Step 2 must be a number ending in zero (or mod 10 = 0) for the account number to be validated. 70 mod 10 = 0 ∴ Card number is valid Modify the following SQL Server sProc (stored procedure) to validate a credit card. CREATE PROCEDURE [dbo].[prValidateCreditCard] (@creditCardNum char(16)) AS BEGIN DECLARE @counter INT, @sum INT, @number INT, @tmp INT, @result BIT SET @result=0 IF @creditCardNum IS NULL GOTO lblFail IF len(@creditCardNum)=0 GOTO lblFail SET @counter=1 WHILE @counter<=len(@creditCardNum) BEGIN IF ISNUMERIC(substring(@creditCardNum,@counter,1))=0 GOTO lblFail SET @counter=@counter+1 END SET @sum=0 SET @number=0 SET @counter=len(@creditCardNum) WHILE @counter>0 BEGIN IF @counter>1 BEGIN SET @tmp=(ASCII(substring(@creditCardNum,@counter-1,1))-48)*2 IF @tmp>9 SET @sum=@sum+@tmp-9 ELSE SET @sum=@sum+@tmp END SET @number=@number+(ASCII(substring(@creditCardNum,@counter,1))-48) SET @counter=@counter-2 END SET @sum=(@sum+@number) % 10 IF @sum=0 BEGIN print ‘good’ SET @result=1 END lblFail: RETURN (@result) END GO Test it with a valid credit card number like 5268080043376894. Submit a pdf file that contains the SQL code of the two stored procedures (sProc #1 and sProc #2) along with the result of calling the second stored procedure using the credit card number above. Deliverable VI – Triggers Trigger #1: The first trigger represents a typical inventory management task. Whenever an item is sold the associated inventory count is decremented. The system should automatically check to see if the inventory count has fallen below the reorder quantity. Write a trigger to compare the Product_Category (or Model) attribute modelInventoryCount to the modelReorderQuantity. If the value is less than or equal to the reorder quantity then the reorderNecessary attribute should be set to true. The trigger should be invoked whenever the modelInventoryCount or modelReorderQuantity is updated. Trigger #2: The next trigger calls the credit card validation stored procedure or stored function. When an item is purchased by credit card, the card number must be validated. Write a trigger to execute the stored procedure or function that you developed to validate the card number when the value of the purchaseAgreementCardNumberUsed field is inserted or updated. Note: To get a list of triggers in MySQL use the statement below: SELECT * FROM information_schema.TRIGGERS; Hint: You can generate an error message from a trigger using the signal statement : SIGNAL SQLSTATE ‘45000’ SET MESSAGE_TEXT = ‘Invalid Credit Card Number’; It appears that MySQL treats triggers like queries, so you may want to save them as script files. Submit a pdf file that contains the SQL code of the two triggers.