Using MYSQL Workbench:

** Cannot use intersect only allowed to use inner join or in**

Suppliers(sid: int, sname: VARCHAR(30), address: VARCHAR(50))

Parts(pid: int, pname: VARCHAR(30), color:VARCHAR(10))

Catalog(sid: int, pid:int, cost: double)

(Bolded names are primary keys)

1. Find distinct sids and snames of suppliers who supply a red part and a green part.

In a test of the effectiveness of garlic for lowering​ cholesterol, 36 subjects were treated with raw garlic. Cholesterol levels were measured before and after the treatment. The changes​ (before minus​ after) in their levels of LDL cholesterol​ (in mg/dL) have a mean of 0.7 and a standard deviation of 20.1. Use a 0.10 significance level to test the claim that with garlic​ treatment, the mean change in LDL cholesterol is greater than 0. What do the results suggest about the effectiveness of the garlic​ treatment? Assume that a simple random sample has been selected. Identify the null and alternative​ hypotheses, test​ statistic, P-value, and state the final conclusion that addresses the original claim. What are the null and alternative​ hypotheses?

Determine the test statistic.

Determine the​ P-value.

. 1. Explain Hamilton’s Rule in words.

2. Relate indirect fitness and kin selection to the alarm callings of black tailed prairie dogs.

4. Does kin selection explain how humans distribute wealth? (You don’t have to write about this, but what about something like the Bill and Melinda Gates Foundation? Think about how you’d explain that.)

Toflokpo-Crane is new company that specializes in designing and manufacturing small-scale automatic jib cranes for moving heavy loads around a workshop or production line environment. Their primary selling point is the integration of neural network-based imaging technology to enable fully automatic identification of objects to pick-up, removing the need for human intervention. The primary components of a jib crane are the floor mounted pillar (containing a rotational motor), the jib/boom mounted on-top of the pillar, the customisable hoist that can traverse the jib/boom as well as raise or lower a pick-up attachment, the pick-up attachment that allows the crane to connect with the goods to move, the high-definition camera array that monitors the area under the pick-up attachment, and the AI unit that processes the camera input and directs the crane. Most pillars are of fixed height; however, the user can manually adjust the height for some pillars using a handle positioned at the pillar base.

Describe two requirements that you have extracted from the description above (two sentences each). For each, state whether it is functional or non-functional .

Identify the stakeholders in the system with justification

The description above is intentionally vague. Identify as many principal components of the Toflokpo-Crane control system as possible and how these might interact with each other. You may wish to use a diagram to illustrate these components and how they connect (1 mark for each correct component identified, up to a maximum of 10 Marks).

Describe two additional requirements that you can reasonably assume from the above description, but are not mentioned in the description above (two sentences each). State whether they are functional or non-functional .

Product Description: This is a description for a new software product that an end-user wants to have developed. It provides high level information about what the user envisages the product will do.

Tasks: For this exercise, your role is as a software architect on a project team. Your project manager has tasked you with converting the product description into documentation for the project development team using the software project management techniques you have learned. The tasks section lists the pieces of documentation you need to produce.

Toflokpo-Crane engineers are awarding you the project of developing the software control system for the crane. There are two ways that the crane should be controlled. First, an on-floor administrator should access a crane control panel enabling manual control of the crane via a Web interface hosted by the crane (accessible via the local Wi-Fi network). They can also toggle between manual and autonomous mode, as well get a live feed from the camera arrays using the Web interface. The camera arrays are only powered when in use. If in autonomous mode, the crane will be controlled by the AI Unit, based on input from the camera array. The AI Unit and human operator share the same operations. Internally, the control system needs to send requests to the other crane components to facilitate pick-up and movement/drop-off of goods. The pillar can rotate a given number of degrees and the hoist can move a number of inches forward or backward along the jib, as well as raise/lower the attachment a number of inches. The Hoist knows the length of the Jib to avoid traversing further than the length of the Jib. The control system should support different attachments natively, as all available attachments share the same base set of commands. Toflokpo-Crane currently makes attachments for picking up packing crates and goods bags. In emergencies the crane can be shut down using a red stop button on the pillar.

TASKS

Describe two requirements that you have extracted from the description above (two sentences each). For each, state whether it is functional or non-functional .

Identify the stakeholders in the system with justification

The description above is intentionally vague. Identify as many principal components of the Toflokpo-Crane control system as possible and how these might interact with each other. You may wish to use a diagram to illustrate these components and how they connect (1 mark for each correct component identified, up to a maximum of 10 Marks).

Describe two additional requirements that you can reasonably assume from the above description, but are not mentioned in the description above (two sentences each). State whether they are functional or non-functional .

Red Red Wine is a wine bar that has been incorporated by Amie. It operates as a closelyheld corporation. The other shareholders are Amie’s brother and sister-in-law. Amie runs the day-to-day management of the wine bar, including managing the books and records. Amie’s brother and sister-in-law handle distribution, sales and marketing. After a few years, Amie starts to feel like she is doing the majority of the work and becomes bitter about the business relationship. She feels like she should be earning more money for the amount of work she does for the bar. Without discussing it with her brother and sister-in-law, Amie starts taking an additional draw from the wine bar every month in the amount of $1,000. She deposits the money into a business account for an LLC she created. On the books and records of the wine bar, Amie records this amount to the LLC as a “consultation fee.” Can Amie be held personally liable in this situation? If so, why?

1.Locate at least one article from a professional journal about GASB Statements No. 67 and No. 68 and:

a. Concisely compares and contrasts the old and new standards based on the article(s) you reviewed.

b. State whether or not you believe the new standards improve governmental reporting for pensions.

c.provide at least one specific example to support your opinion. Support your review and opinion with at least one scholarly source

A student in our class is confused about the motion of pulses on a long taut spring and has scored zeros on many of the homework problems. Pick two ideas that you think are critical for understanding this topic. State them clearly and describe how you would help your fellow student make sense of these ideas. Note: This is an essay question. Your answer will be judged not solely on its correctness, but for its depth, coherence, and clarity.

Name____________________________________________ Section (circle one) 15 16

The Mountain Lion Based on a true story

Instructions

After each of the numbered sections of the story answer the question in bold.

In answering each question you will:

Choose and identify 3 psychobiological factors that were in operation, and

Explain how the psychobiological factors were involved (The factor was doing…what?).  

There will be three answers for each section, a total of 12 (3X4) answers for the assignment.

The fifth section is EXTRA CREDIT. There will be no mark-down for weak or wrong responses.

Select items related to psychobiological processes (items) from the list in the box below.  

You may use an item from the list once only.

I suggest that you check off each item as you use it.

Preferred: Assignment will be typed. If handwritten, writing must be easily legible. Check your grammar and spelling. Number all answers in the format of the Assignment, i.e. 1.1., 1.2., 1.3., etc.

Your answers must be in the form of complete sentences.

Late work will be marked down.

Acetylcholine

Adrenal gland

Afferent and Efferent neurons

Amygdala

Antagonistic Neurotransmitter (Specify which neurotransmitter)

Binocular cues

Brightness constancy

Cerebral cortex

Cortisol

Dopamine

Endocrine system (Which hormone)

Endorphins

Epinephrine

Excitatory neurotransmitter (Specify which neurotransmitter)

Figure ground

Frontal lobe

GABA

Gate control theory

Glutamate

Hippocampus

Hypothalamus

Interneurons

Inhibitory neurotransmitter (Specify which..)

Just Noticeable Difference (Be specific)

Kinesthetic sense

Left side of brain

Limbic system

Mirror neurons

Motor neurons

Norepinephrine

Occipital lobe

Olfaction

Parasympathetic nervous system

Parietal lobe

Sensory neurons

Sensory transduction

Serotonin

Sound localization

Sympathetic nervous system

Synaptic transmission

Synaptic vesicles

Temporal lobe

Thalamus

Vestibular sense

1. A man is jogging in Estes Park, Colorado. A mountain lion starts to track him. The man senses something behind him, looks back, and sees the mountain lion. The jogger springs into action and starts running as fast as he can go. He runs to a tree and climbs up.

Name and describe 3 psychobiological factors that may be operating in this situation. Explain what each is doing.

1. All @ 8.3

2.

3.

2. The mountain lion stands up against the tree growling ferociously and roaring, while trying to swat the jogger with its powerful paws.  

The jogger is desperately afraid. He reaches for a nearby branch, breaks it off, and tries to hit the mountain lion. He is trying to keep it from climbing up the tree. He swings the branch, occasionally hitting a paw or a leg, and screams curses at the mountain lion. The jogger does not notice that the temperature is dropping. The lion continues its attempts to reach the jogger. The man looks down at the lion as it roars, revealing long, wicked looking, cat’s teeth.

Name and describe 3 psychobiological processes that the jogger is experiencing.

3. The jogger’s wife, knowing how long his run should take, realizes that her husband is late. She becomes increasingly upset and worried. After an hour, she can’t wait any longer, calls the sheriff, and explains her concern. She can’t leave the house because there is an infant. Her hands are shaking as she tells the sheriff her husband’s favorite jogging route.  

How would you explain in 3 psychobiological terms what the jogger’s wife has been experiencing?

1.

2.

3.

4. The sheriff follows the jogging route and arrives at the scene. He sees the Mt. Lion standing up against the tree below the jogger. He immediately understands what is going on. He quickly pulls his riffle from the bracket in his Jeep, aims instinctively, and fires, killing the mountain lion. The grateful jogger climbs down. The sheriff wraps a blanket around him and drives him home.

On the ride back to his house, the jogger feels his body calming down as he distances himself to the extent he can from the extreme physical and mental ordeal. As they approach the jogger’s house, he realizes for the first time that it is very cold outside, and he is wearing only shorts and a tee shirt.  

Shortly after arriving home, he falls asleep on the couch while looking at his baby.

Describe three psychobiological processes that could be in effect for the jogger after the Mt. Lion has been killed and he has left the tree.

3.

Extra Credit

Answer these questions. You have nothing to lose!

5. The next day the jogger and his wife return to the scene of the fearful experience. He has told his wife about how he broke off the dead branch and tried to defend himself. The jogger says, for about the fifth time, that this had been the most terrifying experience in his life. As they approach the tree, he begins to feel uneasy.

He is amazed to see that the branch he broke off is almost 3 inches in diameter was alive and healthy. He wonders how he could have had the strength to break a branch that large and heavy.  

READ THIS QUESTION CAREFULLY!  

YOU ARE INSTRUCTED TO

OFFER A POSSIBLE EXPLANATION TO THE JOGGER.

Reader, how would you begin to explain to the jogger what psychobiological

Processes (3) had been triggered in him that may have accounted for the great

physical strength that enabled him to break off the branch that probably saved

his life?

Altogether 6 pts..

2.

3.

Everybody, except of course the mountain lion, lives happily ever after.  

The end.

A recent census asked respondents to state the highest level of education that they had received. The responses were 39% High school, 45% TAFE or Undergraduate Degree, 13% Higher Degree and 3% Other.

The mayor of a small country town held a similar survey. Below are observed counts for each of the education levels for 250 respondents from the town: Highest Education Level

a) If the counts observed for the town matched that of the census, what would be the expected counts for

each education level?

b) To see if these results are unusual, should you perform a goodness-of-fit test or a test of independence?

c) State your hypotheses.

d) How many degrees of freedom are there?

e) Find x² and the P-value.

f) State your conclusion (use α = 0.05) in the context of the question.

Show all working out and dont no technology (ie. spss or excel)

A U.S. firm has a subsidiary in Great Britain and faces the following scenario:

a. Fill in the dollar value of the cash flow (C) in the table above.

b. Estimate your exposure to exchange rate risk (b).

c. Compute the proceeds from the forward contract if you hedge this exposure. Assume the forward rate is $2.45/£. Fill in the proceeds in the appropriate box in the table above. Use two decimal places in your calculations.

d. Compute the dollar value of the hedged position and fill in the blanks in the table above.

e. Calculate the variance of the un-hedged position.

f. If you hedge, what is the variance of the dollar value of the hedged position?

Note C* refers to GPB Cash flow and C refers to the USD equivalent using the spot rate