In this experiment, we will explore fermentation. As you read Chapter 13, one of the fates of pyruvic acid can be the production of carbon dioxide and ethanol. The pyruvic acid is made from carbohydrate by glycolysis. By measuring the amount of CO2 made over time, you can measure the efficiency of glycolysis. The basic experiment is relatively simple. 1. Prepare a sample of carbohydrate in water. Take note of the concentration in % (use volume or weight). 2. Completely fill a small juice glass with the carbohydrate mixture. 3. Add yeast to the mixture. Start with 1.4 tsp. 4. Mix the carbohydrate, water, yeast mixture. If you spill some make sure the juice glass is filled to the brim. 5. Place a flat-bottom bowl over the juice glass. 6. Invert both the bowl and juice glass together, being careful not to spill the contents. Now the glass is upside down in the bowl. 7. Watch the glass for at least 2 hours, recording the size of the bubble formed every 15 minutes. The size of the bubble can be estimated by measuring the height of the bubble in cm. Multiply the height by (1/4)x(diameter in cm)x(diameter in cm) x pi. Pi is approximate 3.14. (V= h x pi x r^2). Run this experiment 4 times (Since there is a lot of waiting, you can start a second experiment after you get the first started). One experiment should be a control, using no carbohydrate. Vary only one variable. For example, one student might test sucrose (table sugar), Karo syrup, and honey. Another student might vary the concentration of carbohydrate; 5%, 10%, 15%. Another student might vary the temperature: in an ice bath, room temp, in a 100 degree F oven. This is a case where I would like to see you design your own experiment. Make a lab report of your own design. It should have the following components:

1. Introduction and Objectives.

2. Procedure (What did you do?).

3. Results in tabular form.

4. Conclusion ( What do your results mean in terms of what you have learned about enzyme kinetics, glycolysis, and carbohydrate metabolism?)

Fully explain what the author means by "Pave the Planet or Wear Shoes."

Subverting Greed Chapter 3.

QUESTION 4 Before determining the ?soltnH of the salts in part B of Experiment 4 it's necessary to calibrate the calorimeter to effective heat capacity of the calorimeter. In order to do this, the neutralisation of hydrochloric acid and sodium hydroxide is used, where the ?H for the reaction is known, along with the specific heat and density of sodium chloride, the product of the reaction. By following the example on page 4-4 of the manual and the steps laid out in the table below determine Ccalorimeter in J K-1. The information that you need is shown in the table below. Value Enthalpy change for one mole ( \Delta H ?H) -58.3 kJ mol-1

Density 1 M NaCl (?) 1.037 g mL-1

Specific heat of 1 M NaCl solution ( C C) 3.90 g-1 K-1

Molarity of sodium hydroxide(aq) and hydrochloric acid(aq) used ( c c) 2 mol L-1

Volume of each of sodium hydroxide(aq) and hydrochloric acid(aq) used ( V V) 50 mL

Average neutralisation temperature rise ( \Delta T ?T) 11.2 °C

Calculation

Moles of H2O produced n (mol) = c (mol L ?1 ) ×V (L)

Enthalpy change for the reaction ? r H (kJ) =n (mol) ×?H (kJ mol ?1 )

Enthalpy change for the corresponding temperature change ? t H (kJ) =?? r H (kJ)

Mass of solution m (g) =V (mL) ×? (g mL ?1 )

Heat capacity of the solution C solution (J K ?1 ) =m (g) ×C (J g ?1 K ?1 )

The heat capacity of the calorimeter ( C calorimeter)

PLEASE ANSWER URGENT!!! A world wide fast food chain decided to carry out an experiment to assess the influence of income on number of visits to their restaurants or vice versa. A sample of 8 households was asked about the number of times they visit a fast food restaurant (V) during last month as well as their monthly income (I). The data presented in the following table are the sums and sum of squares. (use 2 digits after decimal point)

a. Compute sample correlation coefficient. r=Answer

b. Test correlation coefficient for significance. (hint: ρ is population correlation coefficient)

Null Hypothesis is

Alternative Hypothesis is

Test statistic  is ???<---- answer

Critical Value of the test at α=5% is ???<--- answer

Does your findings support the hypothesis that as income increases, number of visits also increases at 5% significance level?

c. Find the linear regression equation of visits based on income.

Estimated visit = ?? + ?? Income

d. Find the linear regression equation of income based on visits.

Estimated income = ?? + ?? Visit

e. Which model is more deterministic? (hint: use coefficient of determination to decide)

Model in part (c)

Model in part (d)

They are equivalent

A poll conducted by GfK Roper Public Affairs and Corporate Communications asked a sample of 1001 adults in the United States, "As a child, did you ever believe in Santa Claus, or not?" Of those surveyed, 84% said they had believed as a child. Consider the sample as an SRS. We want to estimate the proportion p of all adults in the United States who would answer that they had believed to the question "As a child, did you ever believe in Santa Claus, or not?" (a) Find a 90% confidence interval (± ± 0.0001) for p p based on this sample. The 90% confidence interval is from to (b) Find the margin of error (± ± 0.0001) for 90%. The margin of error is (c) Suppose we had an SRS of just 150 adults in the United States. What would be the confidence interval (± ± ) for 95% confidence? The 50% confidence interval is from to (d) How does decreasing the sample size change the confidence interval when the confidence level remains the same? Decreasing the sample size creates a less wide interval Decreasing the sample size creates a wider interval

Santa Fe Retailing purchased merchandise “as is” (with no returns) from Mesa Wholesalers with credit terms of 3/10, n/60 and an invoice price of $24,900. The merchandise had cost Mesa $16,982. Assume that both buyer and seller use a perpetual inventory system and the gross method.

1. Prepare entries that the buyer records for the (a) purchase, (b) cash payment within the discount period, and (c) cash payment after the discount period.
2. Prepare entries that the seller records for the (a) sale, (b) cash collection within the discount period, and (c) cash collection after the discount period.

Journal entry worksheet

Record Santa Fe Retailing purchased merchandise “as is” (with no returns) from Mesa Wholesalers with credit terms of 3/10, n/60 and an invoice price of $24,900.

Record the merchandise had cost Mesa $16,982.

Record cash received within discount period.

Record cash received after discount period.

Note: Enter debits before credits.

I need the answers.

A poll conducted by GfK Roper Public Affairs and Corporate Communications asked a sample of 1007 adults in the United States, "As a child, did you ever believe in Santa Claus, or not?" Of those surveyed, 84% said they had believed as a child. Consider the sample as an SRS. We want to estimate the proportion p of all adults in the United States who would answer that they had believed to the question "As a child, did you ever believe in Santa Claus, or not?"

(a) Find a 90% confidence interval (±±0.0001) for p based on this sample.

The 90% confidence interval is from __ to ___

b) Find the margin of error (±±0.0001) for 90%.

The margin error is ___

(c) Suppose we had an SRS of just 100 adults in the United States.

What would be the confidence interval (±±) for 95% confidence?

The 50 % confidence interval (+) is from __ to __

(d) How does decreasing the sample size change the confidence interval when the confidence level remains the same?

a. Decreasing the sample size creates a wider interval

b.Decreasing the sample size creates a less wide interval.

Write at least three sentences in response to questions 2–4.

Article, Andrew Braaksma's "Some Lessons From the Assembly Line."

1. What article did you select for your critical analysis project? List the title and author here.

2. An author's purpose or goal is their reason for writing a work. Based on a literal reading of your selected article, what do you believe is the author's purpose? How did you arrive at that decision?

3. Key points are pieces of evidence that support the author's purpose. In your selected article, what are three key points that support the author's purpose that you identified in this reading? How do those key points support it?

4. An author's audience is the group (or groups) of people being addressed in the reading. What audience do you believe the author is writing for in your selected article? What potential challenges does the author face when addressing their purpose with this audience?

A. Consider the following relations and relationship:

JobOpening (jobNo, positon, salary, requirement, contactPerson)

NewsPaper(newsPaperNo, name, street, city, zipCode, phoneNo)

       Posting(jobNo, newsPaperNo, date, cost)

1. List all the positions that are posted on January 01, 2016

2. List all the positions that have never been posted

3. List the names of all the newspapers where the positions “database administrator has been posted

Database Schema:

Book(bookID, ISBN, title, author, publish-year, category)

Member(memberID, lastname, firstname, address, phone-number, limit)

CurrentLoan(memberID, bookID, loan-date, due-date)

History(memberID, bookID, loan-date, return-date)

Members can borrow books from the library. The number of books they can borrow is limited by the “limit” field of the Member relation (it may differ for different members). The category of a book includes fiction, non-fiction, children’s and reference. The CurrentLoan table represents the information about books that are currently checked out. When the book is returned to the library, the record will be removed from CurrentLoad relation, and will be inserted into History relation with the return-date. A library may have more than one copy of the same book, in which case each copy has its own bookID, but all copies share the same ISBN.

Write SQL statements for each of the following questions.

(1) (16 pts) Create all the relations listed above. Make sure to indicate the primary key and the foreign keys (if any) in your statements.

(2) (10 pts) Insert at least 5 members, 10 books, and enough tuples in the CurrentLoan and History relation. Add tuples as needed to be able to test the following queries for different test cases.

(3) (8 pts) Find the book ID, title, author, and publish-year of all the books with the words “XML” and “XQuery” in the title. These two keywords can appear in the title in any order and do not have to be next to each other. Sort the results by publish year in descending order.

(4) (8 pts) Find the book ID, title, and due date of all the books currently being checked out by John Smith.

(5) (8 pts) Find the member ID, last name, and first name of the members who have never borrowed any books in the past or currently.

Note:

• Please put all the SQL statements in a single file and name it as hw2_yourPirateID.sql.

• Remember to change all the dash “-” in attribute names to underscore “_”.

• For the ease of testing, please add the “drop table” statements at the beginning of your file to drop all the tables.

• Remember to add “commit;” after your last “insert” statement.

• Comment your code as needed. You can use /* … */ to have multi-line comments or use double hyphen (--) for single line commenting. You may use PROMPT … to print any message to the screen. For example, you may use PROMPT Answer for Question 3 (before the query for question 3).

• For this assignment, you need to test your solutions in Oracle and submit your .sql file