Regarding Python and Scripting

1. What SQL clause is used to combine rows from two or more tables, based on a related column in a relational database.

Question options:

2. The highlighted portion of this program output indicates ____________.

Tracks:

(u'Thunderstruck', 20)

(u'My Way', 15)

Question options:

3. In technical descriptions of relational databases, the concept of column is formally referred to as ____________.

Question options:

4. What is wrong with this SELECT statement?

SELECT FirstName LastName

FROM TableName

Question options:

5. What is meant by this error message in the SQL query window:

Cannot insert explicit value for identity column in table 'Tracks'

Question options:

6. What is returned by this SQL SELECT statement?

SELECT LoginID, JobTitle, BirthDate

FROM Employee                                                       

WHERE JobTitle Like '%Engineer%'                   

Question options:

7. An integer that is automatically assigned by the database to link rows from different tables together is referred to as ______________.

Question options:

8. Which of the following conclusions about the table Follows is INCORRECT?

CREATE TABLE Follows

(from_id INTEGER, to_id INTEGER, UNIQUE(from_id, to_id) )

Question options:

A retail carpet business has primarily residential customers together with a few commercial customers that make large purchases. Usually, the business sells an average of 100 square yards of carpet with a standard deviation of 90 square yards. The distribution of carpet sales is

Select one:

a. right-skewed.

b. left-skewed.

c. skewed, but we can’t tell whether it’s left-skewed or right-skewed

d. approximately symmetric, but not Normal.

e. approximately Normal.

f. There’s no way to tell what shape the distribution has.

g. It doesn't make sense to talk about the shape of this distribution.

Suppose the histogram in FIGURE 3 is the sampling distribution for sample averages from samples of size n = 25 from some population. Which of the following statements would be true if the sample sizes were increased to 150?

Select one:

a. The shape of the distribution would not change.

b. The shape of the distribution would be more bell-shaped.

c. The shape of the distribution would be more skewed.

"95% confident" means...

Select one:

a. if we took many random samples from the population, and computed a 95% confidence interval for each sample, we would expect 95% of the confidence intervals to contain the true parameter.

b. if we took one random sample from the population, we would expect 95% of the people in the sample to have a value within the confidence interval.

c. Both A and B are true

d. Neither A nor B are true

Using the sampling distribution in FIGURE 3, how likely is a sample mean around 76?

Select one:

a. Reasonably likely to occur from a sample of this size

b. Unusual but might occur occasionally

c. Extremely unlikely to ever occur

We have a large collection (5574) of real SMS text messages from cellphone users in 2010. 747 of these messages are classified as "spam", and the rest are not. The word “text” (or “txt”) is contained in 7.01% of legitimate (not spam) messages, and in 38.55% of all spam messages. What is the probability that a message is spam, given that it contains the word “text” (or “txt”)?

Select one:

a. 7.01%

b. 13.40%

c. 38.55%

d. 45.97%

e. 57.56%

f. 84.61%

g. We can't determine this probability.

A9-75

in this activity, you will be creating budgets for a single product for each of the months in an upcoming quarter. Select a product that you could purchase in large quantities (at a Sam's Club or other warehouse retail chain) and repackage into smaller quantities to offer for sale at a sidealk cafe, a sporting event, a flea market, or other similar venue. Investigate the price a quantity at which this product is available at the warehouse. Choose a selling price for the smaller (repackaged) package. Make Reasonable assumptions about how many of the smaller units you can sell in each of the next four months (your will need the fourth month's sales in units for the operating budgets).

A. Describe your product. What is your cost of this product? What size (quantity) will you purchase? At what price will you sell your repackaged product? Make projections of your sales in units in each of the upcoming three months.

B. Estimate how many hours you will spend in each of the upcoming three months doing the purchasing, repackaging, and selling. Select a reasonable wage rate for yourself. What will your total labor costs be in each of the upcoming three months?

C. Prepare a sales budget for each of the upcoming three months.

D. Prepare the direct material budgets for the upcoming three months, assuming that you need to keep 10% of the direct materials needed for next month's sales on hand at the end of each month (this requirement is why you needed to estimate unit sales for four months).

E. Prepare a direct labor budget (for your labor) for each of the upcoming three months.

F. Think about any other expenses you are likely to have (i.e., booth rental at a flea market or a vendor license). Prepare the operating expenses budget for each of the upcoming three months.

G. Prepare a budgeted income statement that reflectcs the budget you prepared, including the sales budget, direct materials budget, direct labor budget, and the operating expenses budget. This budgeted income statement should include one column for each of the three months in the quarter, and it should also include a total column that represents the totals of the three months. What is your projected by month and for the quarter?

This is the only information given word for word from the textbook.

Write a class called Name. A tester program is provided in Codecheck, but there is no starting code for the Name class. The constructor takes a String parameter representing a person's full name. A name can have multiple words, separated by single spaces. The only non-letter characters in a name will be spaces or -, but not ending with either of them.

The class has the following method:

• public String getName() Gets the name string.

• public int consonants() Gets the number of consonants in the name. A consonant is any character that is not a vowel, the space or -. For this problem assume the vowels are aeiou. Ignore case. "a" and "A" are both vowels. "b" and "B" are both consonants.

You can have only one if statement in the method and the if condition cannot have either && or ||. Do not use the switch statement, which is basically the same as an if statement with multiple alternatives. Hint: call method contains().

- public String initials() Gets the initials of the name.

Do not use nested loops for the method. Hint for initials(): Each word after the first is preceded by a space. You can use the String method indexOf (" ", fromIndex) to control a while loop and to determine where a new word starts. This version of indexOf() returns the index of the first space starting at the fromIndex. The call of indexOf (" ", fromIndex) returns -1 if the space is not found in the string. Remember that the name does not have 2 consecutive spaces and does not end in a space.

NameTester.java

/**
 * A Java tester program for class Name.
 *
 * @author  Kathleen O'Brien, Qi Yang
 * @version 2020-07-25
 */
public class NameTester
{
    public static void main(String[] args)
    {
        Name name = new Name("Allison Chung");
        System.out.println(name.getName()); 
        System.out.println("Expected: Allison Chung");
        System.out.println(name.consonants());
        System.out.println("Expected: 0");
        
        name = new Name("a-abcdefghijklmnopqrstuvwxyz ABCDEFGHIJKLMNOPQRSTUVWXYZ");
        System.out.println(name.getName()); 
        System.out.println("Expected: a-abcdefghijklmnopqrstuvwxyz ABCDEFGHIJKLMNOPQRSTUVWXYZ");
        System.out.println(name.consonants());
        System.out.println("Expected: 0");
        
        name = new Name("Alhambra Cohen");
        System.out.println(name.initials());
        System.out.println("Expected: null");
        
        name = new Name("George H W Bush");
        System.out.println(name.initials());
        System.out.println("Expected: null");
        
        name = new Name("John Jacob Jingleheimer Schmidt");
        System.out.println(name.initials());
        System.out.println("Expected: null");
        
        name = new Name("Zorro");
        System.out.println(name.initials());
        System.out.println("Expected: null");
    }
}

Python

10 - (10 pts) - Implement a program that starts by asking the user to enter a userID (i.e., a string). The program then checks whether the id entered by the user is in the list of valid users.

The current user list is: ['joe', 'sue', jamal, 'sophie']

Depending on the outcome, an appropriate message should be printed. Regardless of the outcome, your function should print 'Done.' before terminating.

Here is an example of a successful login:

>>> Login: joe

Welcome back, joe

Done.

And here is one that is not:

>>> Login: john

Unknown users or passwords

Done.

11 – (10 pts) - Using Python, create a random password generator with length = 10 characters. The password should consist of upper- and lower-case letters and digits.

12 - (15 pts) - An acronym is a word formed by taking the first letters of the words in a phrase and then making a word from them. For example, RAM is an acronym for random access memory.

Write a function acronym() that takes a phrase (i.e., a string) as input and then returns the acronym for that phrase.

Note: The acronym should be all uppercase, even if the words in the phrase are not capitalized.

>>> acronym('Random access memory')

'RAM'

>>> acronym('central processing unit')

'CPU'

13 - (10 pts) – Using Python, write a segment of code to populate the table "employee" of the database "EmployeeDB” with the data below. Import your choice of DB connector (import MySQLdb/sqlite3…)

Create the“employee” table with schema = [name, address, age]

Insert this employee: John Doe, 7001 E Williams Field, 32

14 - (20 pts) - Define a class called Animal that abstracts animals and supports three methods:

setSpecies(species): Sets the species of the animal object to species.

setLanguage(language): Sets the language of the animal object to language.

speak(): Prints a message from the animal as shown below.

The class must support supports a two, one, or no input argument constructor.

Then define Duck as a subclass of Animal and change the behavior of method speak() in class Duck.

>>> snoopy = Animal('dog', 'bark')

>>> snoopy.speak()

I am a dog and I bark.

>>> tweety = Animal('canary', ‘tweet’)

>>> tweety.speak()

I am a canary and I tweet

>>> animal = Animal()

>>> animal.speak()

I am an animal and I make sounds.

>>> daffy = Duck()

>>> daffy.speak()

quack! quack! quack!

In the mid-1990s, Colgate-Palmolive developed a new toothpaste for the U.S. market, Colgate Total, with an antibacterial ingredient that was already being successfully sold overseas. At that time, the word antibacterial was not allowed for such products by the Food and Drug Administration (FDA). In response, the name “Total” was given to the product in the United States. The one word would convey that the toothpaste is the “total” package of various benefits. Young & Rubicam developed several commercials illustrating Total’s benefits and tested the commercials with focus groups. One commercial touting Total’s long-lasting benefits was particularly successful. The product was launched in the United States in January of 1998 using commercials that were designed from the more successful ideas of the focus group tests. Suppose 32% of all people in the United States saw the Total commercials. Of those who saw the commercials, 40% purchased Total at least once in the first 10 months of its introduction. According to U.S. Census Bureau data, approximately 20% of all Americans were in the 45-64 age category. Suppose 24% of the consumers who purchased Total for the first time during the initial 10-month period were in the 45-64 age category. Within three months of the Total launch, Colgate-Palmolive grabbed the number one market share for toothpaste. Ten months later, 21% of all U.S. households had purchased Total for the first time. The commercials and the new product were considered a success. During the first 10 months of its introduction, 43% of those who initially tried Total purchased it again.   

1. What percentage of U.S. households purchased Total at least twice in the first 10 months of its release?

2. Can you conclude the initial purchase of Total was independent of age? Use a quantitative argument to justify your answer.

3. Calculate the probability that a randomly selected U.S. consumer is either in the 45-64 age category or purchased Total during the initial 10-month period.

4. What is the probability that a randomly selected person purchased Total in the first 10 months given that the person is in the 45-64 age category?

e. What percentage of people who did not see the commercials purchased Total at least once in the first 10 months of its introduction?

Review information for The South African Motor Industry (The South African motor industry originally emerged through the assembly of knock-down kits of parts from abroad. Over the years, these developed into fully fledged manufacturers. This was largely due to the active industrial policies of the apartheid government (in power from 1948 to 1994), which aggressively promoted import substitution. Under apartheid, racial discrimination in the communities was mirrored by racial Fordism: blacks were largely condemned to poorly paid unskilled work. This led to many industries relying on cheap labor to solve systemically imposed inefficiencies.

In the 1970s, a wave of unionization of blacks took place, eclipsing the older, white- dominated trade unions. By the early 1980s, the new (“independent”) unions became increasingly outspoken in opposing the apartheid order. Mass resistance in communities was paralleled by an upsurge in strike action. In the Mercedes-Benz plant in East London, the resistance became so intense that large areas of the factory were rendered no-go areas for management. Finally a grouping of workers occupied the plant, damaging inventories and machinery.

The close of the apartheid era alleviated much of the underlying tension; at the same time, managers began to forge cooperative deals with unions. At Mercedes-Benz, these included very much better pay and working conditions, new opportunities for up-skilling and career advancement and a range of participative mechanisms, giving workers a real say in the process of production. Today, the plant is one of the most productive car plants in the world, and its products have the fewest defects of any Mercedes-Benz plant. While previously the plant was marginal, and by the late 1980s under threat of closure, today it is an integral part of the Mercedes-Benz worldwide production network.) case 3.1 then answer the following questions in accordance with the criteria below (Write 150 word minimum for each question, points will be deducted if each question does not meet the minimum 150-word required for each question):

1.       Summarize the study

2.       What lessons does the Mercedes-Benz East London plant hold for HR managers worldwide?

3.       Is the experience of Mercedes-Benz in East London relevant to other industries.

4.       If yes, please explain. If not, why not, please explain.

1.

Significant time and effort was/were spent on perfecting her cover letter.

Everyone in the accounting department was/were instructed on how to politely answer incoming calls.

The members of the Professional Committee is/are   disagreeing on how to allocate funds.

One of the male candidates failed to submit his/their cover letter.

2. Choose the sentence that is punctuated correctly.

A. Traditional job-search techniques, such as those described in your job handout, continue to be critical in landing jobs.

B. Traditional job-search techniques, such as those described in your job handout continue to be critical in landing jobs.

C. Traditional job-search techniques such as those described in your job handout continue to be critical in landing jobs.

3.

Choose the sentence that is punctuated correctly.

A. When customizing your résumé, make sure to include keywords that describe your skills, traits tasks and job titles associated with your targeted job.

B. When customizing your résumé, make sure to include keywords that describe your skills traits tasks and job titles associated with your targeted job.

C. When customizing your résumé, make sure to include keywords that describe your skills, traits, tasks, and job titles associated with your targeted job.

Choose the sentence that is punctuated correctly.

A. When you are organizing your qualifications, try to create as few headings as possible; more than six make the document look cluttered.

B. When you are organizing your qualifications, try to create as few headings as possible more than six make the document look cluttered.

C. When you are organizing your qualifications, try to create as few headings as possible, more than six make the document look cluttered.

4.

In the following sentences, select the correct word to fill in the blank.

When applying for a job, make sure all of your correspondence/corespondence   is concise and professional.

Make sure to highlight any professional development/development you have obtained over your career.

Choose the sentence that uses the correct word.

A. I would like to express my interest in this position formally.

1. (T or F)   C++ throws an exception if you try to refer to element 47 in an array with 20 elements.
2. (T or F)   I can copy one array to another by simply using an assignment statement which assigns the one array to the other.
3. (T or F) An exception is the occurrence of an erroneous or unexpected situation during the execution of a program.
4. (T or F) The try / catch structure is used to test for and catch occurrences of syntax errors.
5. (T or F) There can be no code between a try-block and its associated catch-block.
6. (T or F) The reserved word throw is used to signal that an exception has occurred.
7. (T or F) The correct use of throw can be anywhere in a program; a try / catch structure is used only in class definitions.
8. (T or F) In C++, class is not a reserved word.
9. (T or F) Class attributes have no fixed type; their type can be changed during the program execution.
10. (T or F) A member of a class can be a method or an attribute.
11. (T or F)The private attributes of a class cannot be accessed by the public methods of that class.
12. (T or F) The initialization of a variable in the declaration

Ex: int counter = 0;

is not allowed inside a class definition.

13. (T or F) In C++ a class is a definition; it does not exist in RAM until an object is created, using the definition.
14. (T or F) A member of a class that was created “on the stack” (locally) can be accessed by using the dot operator (.) followed by the member name.
15. (T or F) Class objects can be passed to methods as arguments and can be returned from methods.
16. (T or F) A class constructor is a method that automatically is called whenever an object is created from the class.
17. (T or F) a class destructor is another name for a no-arg constructor..
18. (T or F) a class cannot have more than one constructo
19. (T or F) a class can have a destructor to match each constructor.
20. (T or F) The primary purpose of the separation of a class interface from the class implementation enables the code to be more easily read by a human programmer.
21. (T or F) Every time any method is called, a new “frame” is created in RAM.
    5. (T or F) A “pure” class definition can contain only methods.
    23. (T or F) A class definition by itself, takes very little space in RAM.