Draw extraction schemes that would separate:-

(a) naproxen and cortisone.

(b) ibuprofen from caffeine;

(c) acetaminophen and ibuprofen;

I need to answer all 16 questions. Please do as many as you can.

Please answer the following question of database management.
1. Describe the process of creating a table in SQL and the different data types you can use for fields.

2. What is the purpose of the WHERE clause in SQL? Which comparison operators can you use in a WHERE clause?
3. How do you write a compound condition in an SQL query? When is a compound condition true?

4. What is a computed field? How can you use one in an SQL query? How do you assign a name to a computed field?

6. How do you use the IN operator in an SQL query?

7. How do you sort data in SQL? When there is more than one sort key, how do you indicate which one is the major sort key? How do you sort data in descending order?

8. What are the SQL built-in functions? How do you use them in an SQL query?

9. What is a subquery? When is a subquery executed?

10. How do you group data in SQL? When you group data in SQL, are there any restrictions on the items that you can include in the SELECT clause? Explain.

11. How do you join tables in SQL?

12. In a complex join, how is the number of tables you wish to join related to the number of WHERE conditions?

13. How do you qualify the name of a field in an SQL query? When is it necessary to do so?

14. How do you take the union of two tables in SQL? What criteria must the tables meet to make a union possible?

15. Describe the three update commands in SQL.

16. How do you save the results of an SQL query as a table?

4. As the chapter states, “Defining and targeting your audience is the best way to ensure a match between the company’s product or service and the consumer’s needs.” It only makes good sense that a market-oriented company would want to know as much as possible about its target audiences in order to serve them better. Today, technology has the capability to provide an increasing volume of data that allows audience profiling to become more targeted. Technology-driven audience profiling includes demographics, psychographics, multimedia preference, and characteristics studies in its analysis arsenal. From an ad agency or marketing organization perspective, the idea is simple: the more information you can supply to the creatives the better. OK, so what’s wrong with the picture we just presented to you? There are most likely many faults; however, chief among them are concerns about data collection methods and information security. In other words, there is worry about privacy rights. To investigate this ethical issue, conduct research on the privacy rights of consumers. Specifically, examine privacy rights on the Web and company statements about how consumer information is used. Summarize your findings. Once this is done, summarize your thoughts on how researchers seeking audience profiles can honor consumers’ privacy rights and still conduct meaningful research.

A multi-national-corporation has receivables in a foreign currency. Circle on the correct answer for each question.

(1) [ Long or Short ] in the foreign currency forward contract.
(2) [ Long or Short ] in the foreign currency futures contract.
(3) [ Borrow or Lend ] denominate in the foreign currency.

(4) [ Long or Short ] in the foreign currency [ Call or Put] option.

Exercise 21-21 Overhead controllable and volume variances; overhead variance report LO P3 James Corp. applies overhead on the basis of direct labor hours. For the month of May, the company planned production of 8,000 units (80% of its production capacity of 10,000 units) and prepared the following overhead budget: Operating Levels Overhead Budget 80% Production in units 8,000 Standard direct labor hours 30,000 Budgeted overhead Variable overhead costs Indirect materials $ 21,000 Indirect labor 30,000 Power 7,200 Maintenance 4,800 Total variable costs 63,000 Fixed overhead costs Rent of factory building 17,000 Depreciation—Machinery 11,400 Supervisory salaries 25,600 Total fixed costs 54,000 Total overhead costs $ 117,000 During May, the company operated at 90% capacity (9,000 units) and incurred the following actual overhead costs: Overhead Costs Indirect materials $ 21,000 Indirect labor 33,550 Power 8,100 Maintenance 6,210 Rent of factory building 17,000 Depreciation—Machinery 11,400 Supervisory salaries 28,500 Total actual overhead costs $ 125,760 1. Compute the overhead controllable variance. 2. Compute the overhead volume variance. 3. Prepare an overhead variance report at the actual activity level of 9,000 units.

"Write a function named "firstLast2" that takes as input a vector of integers. The function should return true if the vector starts and ends with the digit 2. Otherwise, it should return false. Test your function with vectors of different length and with the digit 2 at the beginning of the vector, end of the vector, middle of the vector, and missing from the vector."

Additional Requirements:

>Must use a loop allowing the user to continue until he/she quits.

>Read the full name, middle (if there is any) and last name separately.

>Must work even if there is no middle name.

On January 2, 2015, the S. H. Park Company (Park) installed a new $84,000 special molding machine for producing a new product. The product and the machine have an expected life of three years. The machines expected disposal value (amount machine can be sold for) at the end of three years is zero. S. H. Park Company paid cash when the equipment was delivered. Park paid for this machinery via bank transfer. On January 3, 2015, Kimiyo Lee, a salesperson for BT Machine and Tool (BT), tells Park: “I wish I had known earlier of your purchase plans. I can supply you with a technically superior machine for $99,000. Lee indicated the machine just purchased can be sold for $16,000. Lee guaranteed that there machine will save S. H. Park $35,000 per year in cash operating costs. This machine will have no disposal value at the end of three years.” Assume all costs are cost of sales. Park examines some technical data. Park is confident of Lee’s claims. However, Park contends, “I’m locked in now. My alternatives are clear: (a) disposal will result in a loss, (b) keeping and using the ‘old’ equipment avoids such a loss. I have brains enough to avoid a loss when my other alternative is recognizing a loss. We’ve got to use that equipment until we get our money out of it.” The annual operating costs of the old machine are $60,000 all paid in cash. This does not include depreciation. The new machine operating costs will be $25,000 which will be paid in cash. Sales, all in cash, are projected to be $850,000 per year. Annual cash expenses related to sales are $350,000 for material, $250,000 for labor and $150,000 for other operating expenses regardless of this decision. Assume that the equipment in question is the company’s only fixed asset. Ignore income taxes and the time value of money. Any cash payments for the machines occurred in 2015 coinciding with the purchase of the equipment. Should Park dispose of the “old-old” machine (stay the course) or should Park acquire new machine’s (New-New) from Lee? Using the template, prepare income statements as they would appear in each of the next three years under both alternatives. Assume straight-line depreciation over a three year period. What is the cumulative increase or decrease in net income for the three years for each alternative? Prepare statements of cash receipts and disbursements as they would appear in each of the next three years under both alternatives. Assume straight-line depreciation over a three year period. What is the total cumulative increase or decrease in cash for the three years for each alternative? If you were the sales person (Kimiyo Lee), how would respond to Mr. Park so as to get him to purchase your product? Using the provided information, if possible, prepare an alternative analysis which provides a similar result. Regardless of the financial analysis, what factors which effect or influence the decision to replace the equipment or stay with old (new) machine

prove A(A+B) = A using truth table

do you think the way classical economics models individual decision making (through utility maximization) is flawed and should be altered? If so, how?

In reaching her destination, a backpacker walks with an average velocity of 1.05 m/s, due west. This average velocity results, because she hikes for 5.66 km with an average velocity of 2.54 m/s due west, turns around, and hikes with an average velocity of 0.403 m/s due east. How far east did she walk (in kilometers)?

On January 1, 2018, the general ledger of Freedom Fireworks includes the following account balances:

The following information is available on January 31, 2018.

1. Depreciation on the building for the month of January is calculated using the straight-line method. At the time the building was purchased, the company estimated a service life of 10 years and a residual value of $26,000.
2. The company estimates future uncollectible accounts. The company determines $5,000 of accounts receivable on January 31 are past due, and 50% of these accounts are estimated to be uncollectible. The remaining accounts receivable on January 31 are not past due, and 2% of these accounts are estimated to be uncollectible. (Hint: Use the January 31 accounts receivable ending balance shown in the general ledger to start your calculations.) Record the estimated bad debt expense.
3. Unpaid salaries at the end of January are $28,100. (Recognize that salaries are owed, but have not been paid yet.)
4. Accrue income taxes at the end of January are $10,000. (Recognize that income taxes are due, but have not been paid yet.)

Based on the Incorporation Doctrine, formulate a focus question that offers either a broad or specific analysis of the Incorporation Doctrine.

Once you have constructed your question, you should submit a short analysis based answer.

You will construct the question and then offer an answer. 300 words minimum please.

Suppose that (Yi, Xi) satisfy the assumptions we made in the regression analysis. A random sample of size n = 250 is drawn and yields

Yi =5.4 + 3.2×Xi, R2 =0.26, SER=6.2 (3.1) (1.5)

(i) TestH0 :β1 =0vs. H1 :β1 ̸=0atthe5%level.

(ii) Construct a 95% confidence interval for β1.

(iii) Suppose you learned that Yi and Xi were independent. Would you be surprised? Explain.

(iv) Suppose that Yi and Xi are independent, and many samples of size n = 250 are drawn, regressions estimated and the parts (a) and (b) answered. In what fraction of samples would the value β1 = 0 be included in the confidence interval from the second part.

Selected year-end financial statements of Cabot Corporation follow. (All sales were on credit; selected balance sheet amounts at December 31, 2016, were inventory, $55,900; total assets, $249,400; common stock, $87,000; and retained earnings, $40,778.) CABOT CORPORATION Income Statement For Year Ended December 31, 2017 Sales $ 453,600 Cost of goods sold 297,750 Gross profit 155,850 Operating expenses 99,000 Interest expense 4,900 Income before taxes 51,950 Income taxes 20,928 Net income $ 31,022 CABOT CORPORATION Balance Sheet December 31, 2017 Assets Liabilities and Equity Cash $ 14,000 Accounts payable $ 17,500 Short-term investments 9,000 Accrued wages payable 3,600 Accounts receivable, net 34,000 Income taxes payable 4,400 Notes receivable (trade)* 5,500 Merchandise inventory 40,150 Long-term note payable, secured by mortgage on plant assets 70,400 Prepaid expenses 2,750 Common stock 87,000 Plant assets, net 149,300 Retained earnings 71,800 Total assets $ 254,700 Total liabilities and equity $ 254,700 * These are short-term notes receivable arising from customer (trade) sales. Required: Compute the following: (1) current ratio, (2) acid-test ratio, (3) days' sales uncollected, (4) inventory turnover, (5) days' sales in inventory, (6) debt-to-equity ratio, (7) times interest earned, (8) profit margin ratio, (9) total asset turnover, (10) return on total assets, and (11) return on common stockholders' equity. (Do not round intermediate calculations.)