C#

1.Visual Studio .NET’s ___________ feature displays all the members in a class

a.real-time error checking

b.Quick Info

c.outlined code

d.Intellisense

2.An algorithm specifies the actions to be executed.

True

False

3.A(n) _________ occurs when an executed statement does not directly follow the previously executed statement in the written application.

a.unordered execution

b.transfer of control

c.action state

d.jump

4.The declarations and statements that compose the method definition are called the __________.   

a.method body

b.method header

c.parameter list

d.method name

5.The word directly following the return type (in a method header) is called the ___________.

a.method body

b.parameter list

c.argument

d.method name

6.Declaring a variable in the method’s body with the same name as a parameter variable in the method header is ___________.

a.a syntax error

b.a logic error

c.a logic error

d.not an error

e.a common programming practice

7.Failing to return a value from a non-void method __________.

a.is a syntax error

b.causes the application to fail

c.causes the method to return the default value for the return-type

d.causes the method to return the value 0

8.A(n) ____________ conversion occurs when C# converts one data type to another and the programmer has not provided code to perform the conversion.

a.explicit

b.implicit

c.narrowing conversion

d.widening

9.Statements using the ___________ class are explicit conversions.

a.Explicit

b.Convert

c.ExplicitConvert

d.ConvertType

10.If a local variable in a called method shares its name with a variable with class scope, then ____________.

a.a syntax error occurs

b.the local variable is assigned the value of the class scope variable

c.the class scope variable is hidden until the called method terminates execution

d.the local variable is hidden until the called method terminates execution

11.When an argument is passed ______________, the called method can access and modify the caller’s original data directly.

a.either by value or by reference

b.by value

c.using keyword ref

12.Enumerations can contain ___________ values.

a.only unique

b.an indefinite number of

c.up to 10

d.up to 100

13.To access a member of an enumeration, follow the enumeration name with __________ the member name.

a.a dot, followed by

b.parentheses surrounding

c.parentheses surrounding

d.a comma, followed by

e.an underscore character, followed by

14.Attempting to access an element in an array by using an index outside the array’s bounds _________.

a.is a syntax error

b.is an array-time error

c.is a run-time error

d.returns the data-type’s default value

e.returns the value of the last value in the array

Please submit SQL statements as a plain text file (.txt). If blackboard rejects txt file you can submit a zipped file containing the text file. Word, PDF, or Image format are not accepted. You do not need to show screen shot. Make sure you have tested your SQL statements in Oracle 11g.

Problem 1. Please create the following tables for a tool rental database with appropriate primary keys & foreign keys. [30 points]

Assumptions:

1. Each tool belongs to a category.
2. Each category may have a parent category but the parent category should not have parent category (so at most two levels). E.g., a Tool A belongs to electric mower, and electric mower belongs to mower. Mower has no parent category.
3. Each tool can be rented at different time units. The typical time units are hourly, daily, and weekly. There is a different price for each time unit and tool combination. E.g., tool A may be rented at $5 per hour, $30 per day, and $120 per week.
4. Each customer can rent a tool for a certain number of time units. If the tool is returned late a late fee will be charged.

The list of tables is:

Tables:

Cust Table:

cid, -- customer id

cname, --- customer name

cphone, --- customer phone

cemail, --- customer email

Category table:

ctid, --- category id

ctname, --- category name

parent, --- parent category id since category has a hierarchy structure, power washers, electric power washers, gas power washers. You can assume that there are only two levels.

Tool:

tid, --- tool id

tname, --- tool name

ctid, --- category id, the bottom level.

quantity, --- number of this tools

Time_unit table allowed renting unit

tuid, --- time unit id

len, --- length of period, can be 1 hour, 1 day, etc.

min_len, --- minimal #of time unit, e.g., hourly rental but minimal 4 hours.

Tool_Price:

tid, --- tool id

tuid, --- time unit id

price, -- price per period

Rental:

rid, --- rental id

cid, --- customer id

tid, --- tool id

tuid, --- time unit id

num_unit, --- number of time unit of rental, e.g., if num_unit = 5 and unit is hourly, it means 5 hours.

start_time, -- rental start time

end_time, --- suppose rental end_time

return_time, --- time to return the tool

credit_card, --- credit card number

total, --- total charge

1. Recalling what outfit you wore yesterday is an example of which type of memory?

A. episodic memory

B. declarative memory

C. short-term memory

D. both A and B

E. both A and C

2. Which of the following is NOT a form of long-term memory?

A. semantic memory

B. procedural memory

C. iconic memory

D. episodic memory

E. these are all forms of long-term memory

3. When conducting an experiment that asks participants to memorize a list of 20 words, which experimental manipulation would serve to abolish the recency effect?

A.speed up the presentation rate

B.slow down the presentation rate

C.add a distractor task at the beginning of the experiment

D.add a distractor task after the word list but before the recall test

E. none of these options would influence the recency effect

4. What are the three core components of the Baddeley & Hitch model of working memory?

A. encoding, storage, retrieval
B. sensory register, STM, LTM
C. phonological loop, visuo-spatial buffer, central executive
D. iconic memory, echoic memory, short-term memory
E. maintenance, manipulation, executive control

5. _____ is an example of _____.

A. Memory for the first question on this quiz; iconic memory

B. Knowing how to ride a skateboard; control processes

C. Dory from Finding Nemo; a short-term memory problem

D. The auditory sensory store; haptic register

E. Remembering whose face is on a $1 bill; semantic memory

6. What mechanism of working memory makes it possible for people to hold more information in mind than would be expected given our general capacity limit of 7 ± 2 items?

A. Rote rehearsal

B. Scanning

C. Chunking

D. Summarizing

E. Parallel search

7. The "testing effect" refers to the phenomenon that:

A. studied information will only be consolidated into long-term memory if it is subsequently tested.

B. testing is maximally effective when no feedback is provided.

C. testing increases the likelihood that explicit memories will become implicit memories.

D. testing in the same place you in which you studied will lead to improved performance.

E. the act of retrieving a piece of information will strengthen your memory for that information.

8.Which of the following claim(s) would be consistent with the levels of processing theory:

A. intentional learning is always better than incidental learning

B. deeper processing leads to stronger memories

C. the amount of rehearsal determines the strength of the memory

D. memory is best when the retrieval context closely matches the encoding context

E. All of the above are claims made by levels of processing theory

1. Write a MapReduce program to find the frequency of each letter, case insensitive, in some given input. For example, "The quick brown fox jumps over the lazy dog" as input should generate the following (letter,count) pairs: (T, 2), (H, 1), (E, 3), etc.

2. Test your program against the 3 attached input files: HadoopFile0.txt, HadoopFile1.txt, and HadoopFile2.txt.

3. The input and output must be read/written from/into HDFS.

4. Please submit only the Java source file(s) on .

5. I've attached the WordCount.java as a sample MapReduce program. You might find it useful.

WordCount.java ::

import java.io.IOException;
import org.apache.hadoop.fs.Path;
import org.apache.hadoop.io.IntWritable;
import org.apache.hadoop.io.LongWritable;
import org.apache.hadoop.io.Text;
import org.apache.hadoop.mapreduce.Job;
import   org.apache.hadoop.mapreduce.lib.input.FileInputFormat;
import org.apache.hadoop.mapreduce.lib.output.FileOutputFormat;
import org.apache.hadoop.mapreduce.Mapper;
import org.apache.hadoop.mapreduce.Reducer;
public class WordCount
{
public static void main(String[] args)
throws Exception {
if (args.length != 2) {
System.err.println("Usage: WordCount <input path> <output path>");
System.exit(-1); }
Job job = Job.getInstance(); job.setJarByClass(WordCount.class); job.setJobName("Word Count");
//job.setNumReduceTasks(2); FileInputFormat.addInputPath(job, new Path(args[0])); FileOutputFormat.setOutputPath(job, new Path(args[1])); job.setMapperClass(WordMapper.class); job.setReducerClass(WordReducer.class); job.setOutputKeyClass(Text.class); job.setOutputValueClass(IntWritable.class); System.exit(job.waitForCompletion(true) ? 0 : 1);
}
public static class WordMapper
extends Mapper<LongWritable, Text, Text, IntWritable> {
public void map(LongWritable key, Text value, Context context)
throws IOException, InterruptedException {
String line = value.toString().toLowerCase(); String[] tokens = line.split("\\W+");
for (String token : tokens) {
if (token.length() > 0)
context.write(new Text(token), new IntWritable(1));
}
}
}
public static class WordReducer
extends Reducer<Text, IntWritable, Text, IntWritable> {
public void reduce(Text key, Iterable<IntWritable> values, Context context)
throws IOException, InterruptedException {
int count = 0;
for (IntWritable value : values) {
count += value.get();
}
context.write(key, new IntWritable(count));
}
}
}

Hadoopfile0.txt::
Hadoop is the Elephant King!
A yellow and elegant thing.
He never forgets
Useful data, or lets
An extraneous element cling!

Hadoopfile1.txt::
A wonderful king is Hadoop.
The elephant plays well with Sqoop.
But what helps him to thrive
Are Impala, and Hive,
And HDFS in the group.

Hadoopfile2.txt::
Hadoop is an elegant fellow.
An elephant gentle and mellow.
He never gets mad, Or does anything bad,
Because, at his core, he is yellow.

The unadjusted trial balance of Epicenter Laundry at June 30, 2016, the end of the fiscal year, follows:

Epicenter Laundry

UNADJUSTED TRIAL BALANCE

June 30, 2016

The data needed to determine year-end adjustments are as follows:

SAS Enterprise Miner Exersice

Chapter 8 – Pattern Discovery Association

1.   Conducting an Association Analysis

A store is interested in determining the associations between items purchased from the Health and Beauty Aids Department and the Stationery Department. The store chose to conduct a market basket analysis of specific items purchased from these two departments. The TRANSACTIONSdata set contains information about more than 400,000 transactions made over the past three months. The following products are represented in the data set:

bar soap

bows

candy bars

deodorant

greeting cards

magazines

markers

pain relievers

pencils

pens

perfume

photo processing

prescription medications

shampoo

toothbrushes

toothpaste

wrapping paper

There are four variables in the data set:

2.   Create a new diagram. Name the diagram Ch_08_Assoc_Transactions.

3.   Create a new data source. Use the data set AAEM.TRANSACTIONS.

4.   Assign the model role Rejected to the variables STORE and QUANTITY. These variables are not used in this analysis. Assign the ID model role to the variable TRANSACTION and the Target model role to the variable PRODUCT.

5.   Add the node for the TRANSACTIONS data set and an Association node to the diagram.

6.   Change the setting for Export Rule by ID to Yes.

7.   Do not change the remaining default settings for the Association node and run the analysis.

8.   Examine the results of the association analysis.

What is the highest lift value for the resulting rules?                                                              

Which rule has this value?                                                                                                      

Identify all rules that have a Lift greater than 2.0.  For each rule, provide the Support, Confidence, Expected Confidence, Lift, and the actual Rule.

For any two different rules (i.e., not symmetric) with a lift greater than 2.0, for each rule:

Provide an explanation of why you think this rule makes sense

Three different methods that a store manager can use this rule to increase their profit on the related products.  

9.   The submittal for this chapter will be a Word document containing the screen shots captured. Make sure to clearly label each of the screen shots to explain the purpose of the screen shot.

10.   Additionally, as you generate results using SAS Enterprise Miner, you need to explain your results from a business perspective.  This means that you need to explain the results in non-technical terms as well as the business implications of the results.   

One of the items that businesses would like to be able to test is whether or not a change they make to their procedures is effective. Remember that when you create a hypothesis and then test it, you have to take into consideration that some variance between what you expect and what you collect as actual data is because of random chance. However, if the difference between what you expect and what you collect is large enough, you can more readily say that the variance is at least in part because of some other thing that you have done, such as a change in procedure.

For this submission, you will watch a video about the Chi-square test. This test looks for variations between expected and actual data and applies a relatively simple mathematical calculation to determine whether you are looking at random chance or if the variance can be attributed to a variable that you are testing for.

Imagine that a company wants to test whether it is a better idea to assign each sales representative to a defined territory or allow him or her to work without a defined territory. The company expects their sales reps to sell the same number of widgets each month, no matter where they work. The company creates a null and alternate hypothesis to test sales from defined territory sales versus open sales.

One of the best ways to test a hypothesis is through a Chi-square test of a null hypothesis. A null hypothesis looks for there to be no relationship between two items. Therefore, the company creates the following null hypothesis to test: There is no relationship between the amount of sales that a representative makes and the type of territory (defined or open) that a representative works in. The alternate hypothesis would be the following: There is a relationship between the kind of sales territory a sale representative has (defined or open) and the amount of sales he or she makes during a month.

Step 1:

Watch this video.

Step 2:

Use the following data to conduct a Chi-square test for each region of the company in the same manner you viewed in the video:

Step 3:

Write an 800–1,000-word essay, utilizing APA formatting, to discuss the following:

• Describe why hypothesis testing is important to businesses.
• Report your findings from each Chi-square test that you conducted.

Scenario You are the senior event services manager for a 12,000-seat arena located on a major university campus in the southeastern United States. The university’s athletics teams compete in the powerful Atlantic Coast Conference (ACC). On this particular Saturday afternoon, the university men’s basketball team is playing a home game against one of its fiercest ACC rivals. In fact, the visiting team is the defending NCAA national champion and the fans were in a frenzied state for this game when you opened the doors. This televised marquee match-up is sold out. The game has commenced as tip-off was scheduled at 3:08 p.m. EST. As halftime approaches, the power goes out as a result of an automobile accident that knocked out a major electrical transformer. To the best of your knowledge, the power is out all across campus, as well as in the nearby surrounding neighborhoods. The campus police officers on duty have received word that the power will most likely not be restored for several hours. The majority of the campus police on duty in the arena have been directed to take other posts on campus to assist with traffic control and to protect some the highly sensitive research venues on campus. The operations manager reports that while the emergency generator started up and there is emergency lighting, for some reason the public address system is not working even though it is connected to the generator. You are the senior manager on-site and are responsible for decision-making and leading your staff in addressing this dilemma. The campus police have previously agreed that the decision whether or not to evacuate the venue during any event is ultimately the responsibility of the arena’s senior manager on-site during any emergency situation.

Assignment Emergency planning is an ongoing activity that should involve every department within a venue. From the event manager’s point of view, emergency preparedness takes on heightened importance during events because of the high stakes in a venue occupied by many people. The event manager must have the knowledge and competence to carry out emergency responses if necessary. In addition to venue management staff, emergency response will include appropriate actions from a broad range of venue occupants, including event staff (such as ushers and security personnel), medical staff, police, and fire officials. The emergency plan should include a chain of command protocol that includes an incident command system specifying who is in charge. Please answer the following questions as thoroughly as possible:

1. What is the first action you must take in this situation?

2. What instructions do you give to your on-site staff?

3. How do you communicate with the fans without the public address system?

4. How do you handle questions from fans regarding continuation of the game?