Assignment – 1

1- The DISTINCT(X) operator is used to return only distinct (unique) values for datatype (or column) X in the entire dataset .

As an example, for the following table A:

DISTINCT(A.ID) = (1, 2, 3, 4, 5)

DISTINCT(A.ZIPCODE) = (12345, 78910)

DISTINCT(A.AGE) = (30, 40, 10, 20)

Implement the DISTINCT(X) operator using Map-Reduce. Provide the algo-

rithm pseudocode. You should use only one Map-Reduce stage, i.e. the algorithm should

make only one pass over the data.

2-The SHUFFLE operator takes a dataset as input and randomly re-orders it.

Hint: Assume that we have a function rand(m) that is capable of outputting a random integer between [1, m].

Implement the SHUFFLE operator using Map-Reduce. Provide the algorithm pseudocode.

3-What is the communication cost (in terms of total data flow on the network between mappers and reducers) for following query using Map-Reduce:

Get DISTINCT(A.ID from A WHERE A.AGE > 30 )

The dataset A has 1000M rows, and 400M of these rows have A.AGE <= 30. DISTINCT(A.ID) has 1M elements. A tuple emitted from any mapper is 1 KB in size.

4-Consider the checkout counter at a large supermarket chain. For each item sold, it generates a record of the form [ProductId, Supplier, Price]. Here, ProductId is the unique identifier of a product, Supplier is the supplier name of the product and Price is the sales price for the item. Assume that the supermarket chain has accumulated many terabytes of data over a period of several months.

The CEO wants a list of suppliers, listing for each supplier the average sales price of items provided by the supplier. How would you organize the computation using the Map-Reduce computation model?

For the following questions give short explanations of your answers.

5-True or False: Each mapper/reducer must generate the same number of output key/value pairs as it receives on the input.

6-True or False: The output type of keys/values of mappers/reducers must be of the same type as their input.

7-True or False: The input to reducers is grouped by key.

8-True or False: It is possible to start reducers while some mappers are still running.

Write two paragraphs that briefly define effective writing in your own words and identify your writing strengths and weaknesses

Consider the reaction:

2SO_2(g)+O_2(g)--->2SO_3(s)

(a) If 285.5 mL of SO₂ is allowed to react with 158.9mL of O₂ (both measured at STP), what is the limiting reactant and the theoretical yield of SO₃?

(b) If 2.805g of SO₃ is collected (measured at STP), what is the percent yield for the reaction?

April   107   90   29   31   66   0.344
May   106   94   23   35   72   0.372
June   77   62   12   18   29   0.29
July   115   103   20   34   59   0.33
August   124   102   25   36   63   0.353
September   85   69   20   26   44   0.377

(PYTHON)

Using the attached stats.txt, generate a report of a player’s batting average using hits / at bats by month and slugging percent by dividing total bases by at bats. Print out each month, number hits, number of at bats , BA (batting average) and slugging percent (). The input file is organized by month, plate appearances, at bats, runs, hits and total bases.

Explain with examples (at least 3) of arbitrage in exchange rates.

Write a hotel blog about a hotel that you visited recently. Remember that you need to write the text in perfect tense. Please write minimum 30, maximum 40 sentences. Also specify which hotel category suits your hotel.

he following items were selected from among the transactions completed by O’Donnel Co. during the current year:

Andretti Company has a single product called a Dak. The company normally produces and sells 82,000 Daks each year at a selling price of $48 per unit. The company’s unit costs at this level of activity are given below:

A number of questions relating to the production and sale of Daks follow. Each question is independent.

Required:

1-a. Assume that Andretti Company has sufficient capacity to produce 98,400 Daks each year without any increase in fixed manufacturing overhead costs. The company could increase its sales by 20% above the present 82,000 units each year if it were willing to increase the fixed selling expenses by $120,000. Calculate the incremental net operating income. (Round your answers to the nearest whole number.)

1-b. Would the increased fixed selling expenses be justified?

2. Assume again that Andretti Company has sufficient capacity to produce 98,400 Daks each year. A customer in a foreign market wants to purchase 16,400 Daks. Import duties on the Daks would be $1.70 per unit, and costs for permits and licenses would be $9,840. The only selling costs that would be associated with the order would be $1.60 per unit shipping cost. Compute the per unit break-even price on this order. (Round your answers to 2 decimal places.)

3. The company has 900 Daks on hand that have some irregularities and are therefore considered to be "seconds." Due to the irregularities, it will be impossible to sell these units at the normal price through regular distribution channels. What unit cost figure is relevant for setting a minimum selling price? (Round your answer to 2 decimal places.)

Relevant cost per unit= $ ? Per unit

4. Due to a strike in its supplier’s plant, Andretti Company is unable to purchase more material for the production of Daks. The strike is expected to last for two months. Andretti Company has enough material on hand to operate at 25% of normal levels for the two-month period. As an alternative, Andretti could close its plant down entirely for the two months. If the plant were closed, fixed manufacturing overhead costs would continue at 35% of their normal level during the two-month period and the fixed selling expenses would be reduced by 20%. What would be the impact on profits of closing the plant for the two-month period? (Any losses should be indicated by a minus sign. Round all calculations (intermediate and final) to whole numbers. Round unit calculations to whole numbers.)

5. An outside manufacturer has offered to produce Daks and ship them directly to Andretti’s customers. If Andretti Company accepts this offer, the facilities that it uses to produce Daks would be idle; however, fixed manufacturing overhead costs would be reduced by 30%. Because the outside manufacturer would pay for all shipping costs, the variable selling expenses would be only two-thirds of their present amount. Compute the unit cost that can be avoided if purchased from the outside manufacturer. (Do not round intermediate calculations. Round your answer to 2 decimal places.)

Discuss hyper-social organizations and their growing popularity.

Discuss the reasons for globalization and for using global information systems, including e-business and Internet growth.

Discuss the obstacles that organizations face in implementing and using global information systems.

Polaski Company manufactures and sells a single product called a Ret. Operating at capacity, the company can produce and sell 40,000 Rets per year. Costs associated with this level of production and sales are given below:

The Rets normally sell for $46 each. Fixed manufacturing overhead is $200,000 per year within the range of 35,000 through 40,000 Rets per year.

Required:

1. Assume that due to a recession, Polaski Company expects to sell only 35,000 Rets through regular channels next year. A large retail chain has offered to purchase 5,000 Rets if Polaski is willing to accept a 16% discount off the regular price. There would be no sales commissions on this order; thus, variable selling expenses would be slashed by 75%. However, Polaski Company would have to purchase a special machine to engrave the retail chain’s name on the 5,000 units. This machine would cost $10,000. Polaski Company has no assurance that the retail chain will purchase additional units in the future. What is the financial advantage (disadvantage) of accepting the special order? (Round your intermediate calculations to 2 decimal places.)

2. Refer to the original data. Assume again that Polaski Company expects to sell only 35,000 Rets through regular channels next year. The U.S. Army would like to make a one-time-only purchase of 5,000 Rets. The Army would pay a fixed fee of $1.80 per Ret, and it would reimburse Polaski Company for all costs of production (variable and fixed) associated with the units. Because the army would pick up the Rets with its own trucks, there would be no variable selling expenses associated with this order. What is the financial advantage (disadvantage) of accepting the U.S. Army's special order?

3. Assume the same situation as described in (2) above, except that the company expects to sell 40,000 Rets through regular channels next year. Thus, accepting the U.S. Army’s order would require giving up regular sales of 5,000 Rets. Given this new information, what is the financial advantage (disadvantage) of accepting the U.S. Army's special order?

1.     a 10 g particle is undergoing simple harmonic motion with an amplitude of 2.0X10^-3 m and a maximum acceleration of magnitude 8.0X10^3 m/s^2. The phase constant is

Question 4.)

The Fermi Level Under Equilibrium Conditions is Constant. (True or False)

Question 6.) The Fermi level of a semiconductor doped with As (Group V) is : (choose one)

Above the valence band but below the middle of the bandgap.

Below the valence band edge.

Above the conduction band edge.

Above the middle of the bandgap and below the conduction band.

At the precise middle of the bandgap

15.) Choose all that applies for a semiconductor doped n-type:

It has more holes than electrons

Its fermi energy is located exactly at mid gap

Its conductivity depends on the amount of dopant added

It contains impurities

Its bandgap is smaller due to the doping

16.) Choose all that apply for an intrinsic semiconductor at room temperature

It has more holes than electrons

It has more electrons than holes

The Fermi level is located at midgap.

It has an equal number of electrons and holes

17.) Choose all that apply for a degenerate semiconductor:

It is excessively doped with donors or acceptors.

It must be n-type

It must be p-type

It's fermi energy is very close to the middle of the gap

20.) Diffusion currents can only exist in the presence of large electric fields (True or False)

A steel reaction vessel at 25 oC initially contained pure NO2 at a concentration of 2.0 x 10-4 mol/L. Some of the NO2 reacted to form N2O4 as described by the following equilibrum equation:

2NO2(g) <----------> N2O4(g)

At equilibrium, the concentration of N2O4 was found to be 6.01 x 10-6 mol/L. What is the concentration-based equilibrium constant (Kc) for this reaction at 25 oC?

I know the correct answer is 170, but I'd like to know how to get there. Thanks!