Assignment #8

1. Using the Employees table of Figure 14.6, what is the result of the following SQL query?

SELECT *

FROM Employees

WHERE HoursWorked < 100;

2. Write an SQL query that retrieves first and last names and pay rate, ordered by PayRate, from the Employees table of Figure 14.6.

3. Using the Employees table of Figure 14.6 and the Insur-ancePolicies table of Figure 14.7, what is the result of the following SQL query? (The # marks allow the date to be treated numerically.)

SELECT ID, PlanType

FROM Employees, InsurancePolicies

WHERE Birthdate > #1/01/1960# AND ID = EmployeelD;

Table 14.6

ID LastName FirstName BirthDate PayRate HoursWorked

Table 14.7

EmployeeID PlanType DateIssued

Assignment #6

1. Discuss some situations where a sequential storage device such as tape could be a useful form of mass storage and why?

2. Assuming a square two-dimensional memory organization, what are the dimensions of a memory containing 1 MB (2^20) bytes of storage?

How large would the MAR be?

How many bits are sent to the row and column decoders?

How many output lines would these decoders have?

3. Consider the following structure of the Instruction Register:

OPCODE Address 1 Address 2

6 bits 18 bits 18 bits

a. What is the maximum number of distinct operation codes that can be recognized and executed by the processor on this machine?

b. What is the maximum memory size on this machine?

c. How many bytes are required to store each complete instruction?

75 words

How would you explain the difference between casual dining and fine dining?

75 words

Fine dining restaurants are expensive. I used to work at a fine dinning restaurant and I would have many people complain that the food is not worth the money. Personally I thought that our food wasn’t worth the money even though it was really good. I think that many people go to fine dinning restaurants for the ambiance not just for the food. I always think this type of restaurant re for people they have a lot of money.

75 words

There is no doubt that dining market is more classier than the eating market. Having the chance to be waited on and eating fine food from great chefs make the experience more enjoyable. When I am eating at a fine restaurant I do not get attitudes from the waiter who is serving my table unlike the response I get when I am going through the drive through. So, there is definitely a difference between the two.

75 words

Who makes the decision as to which type of establishment a restaurant is - eating or dining - the owner or the guest?  And why?

150 words

How does U.S. society view smoking, and how have views changed over the years? What are the ethical discussions related to smoking and to second-hand smoke?

75 words

Someone in class tell us about COPD and its effect on the respiratory system. What is COPD? What is the prognosis once diagnosed? What types of treatments are available for it?

75 words

 I have a friend who smoked all her life and a few years back had shortness of breath.  She kept on smoking.  She married a man who also smoked and would smoke cigars.  She started smoking the mini cigars with him even though she was supposed to quit smoking.  Well over time, it got to the point where she had a major attack and was taken by ambulance to the hospital.  There they told her she had COPD and she is now on oxygen at night.  She still has shortness of breath during the day.  I often wonder if she would have stopped smoking when she was first told to do so, if she would be in the shape she is today.  I smoke too, but not very often.  I have of course had doctors look at me weird but when I tell them it's only sometimes they really don't have much to say since the world we live in is polluted as well, but I do know it is something I should stop.  You are an inspiration to me and I am so glad that you are on your way to "new" lungs.

75 words

What are our thoughts on the ban on smoking in public places? Is it fair to the smoker? Why or why not?

75 words

The changes in the smoking laws has changed just in the past few years.  I know that in my local community there is no smoking in restaurants, bars, workplaces, ect.  However, I remember when there was no such laws, and people could smoke anywhere.  You can not even smoke on the hospital property in my hometown, the laws have defiantly changed!  Although, I use to smoke, I do not put down the smokers, but I do know that it is very stinky and a very unhealthy habit.  The second hand smokers use to not have the choice and was stuck with the smokers all around them; now with the changes, people have more of the choices and can go to a bar or a restaurant and not have to deal with the stinky and unhealthy cigarette smoke!  Good luck to you!

Financial Markets and Institutions

1) Explain Interest Rate Swaps and stock options. (10 points)

2) Explain the role that credit default swaps played in the financial crises. (5 points)

3) Explain 4 other things that led up to the financial crises and their impact on the financial markets, housing, prices and GDP. (20 points)

4) Compare and contrast the 3 different theories of money demand (15 points).

5) Given the quantitative theory of money:

a) what happens to real GDP if the money supply is cut in half, velocity is stable and prices are sticky? (5 points)

b) what happens to prices if the money supply doubles under the classical model assuming that velocity is stable? (5 points)

6) Compare and contrast the independence of the U.S Central Bank (Federal Reserve Bank) and the European Central Bank. Give the pros and cons of an independent central bank (10 points).

7) Explain the 4 tools of monetary policy and how they impact interest rates, financial markets, housing, and GDP (15 points).

8) Give 4 transmission mechanisms and explain how each impacts the financial markets and the overall economy (15 points)