Transaction Analysis, Evaluation, and Comparison

A transaction follows the two-phase locking (2PL) protocol if all locking operations (read_lock, write_lock) precede the first unlock operation in the transaction.
Such a transaction can be divided into two phases: an expanding or growing (first) phase, during which new locks on items can be acquired but none can be released, and a shrinking (second) phase, during which existing locks can be released but no new locks can be acquired (Elmasri, 2017).

To prepare:
• Review the media piece, Definition of Transaction Management, found in this week’s Learning Resources. (

To complete this Assignment:

  1. Consider the transactions:
    T1: R1(A), W1(B)
    T2: R2(A), W2(A), W2(B)
    Suppose we insert a pair of lock and unlock commands for each element of the database that the transactions can access.
    • Explain how many concurrent execution schedules, of the two transactions, follow the 2PL protocol.
    • Explain whether there are any serializable schedules of concurrent execution of the two transactions that do not follow the 2PL protocol.
  2. Consider the following transactions:
    T1: R1(A), R1(B), INC1(A), INC1(B)
    T2: R2(A), R2(B), INC2(A), INC2(B)
    • Explain how many serializable schedules of concurrent execution of the two transactions there are.
    • If the order of the increment operations in T2 is reversed, how many serializable schedules of concurrent execution of the two transactions are there?

Sample Solution

SW Airlines Critical Thinking, Evaluation, and Deduction

Please analyze Southwest Airlines, identify the reasons why the company has been successful in the unattractive industry, and predict its future. You need to research the company, using a variety of reliable sources such as books, journal articles, library database, trustworthy news media, credible Web sources, etc. After collecting relevant information, you need to evaluate and draw conclusions based on deductive reasoning. Your response should include the following segments:

Operational overview of Southwest Airlines. Why is the company so successful?
Current economic condition of the airline industry. How would this affect Southwest Airlines?
Current operational issues or challenges within Southwest Airlines. How can Southwest Airlines take on the issues or challenges?
Trends for the future within the operational segment. How can Southwest Airlines remain competitive in the future?
To effectively address the above questions, you are expected to write an evaluation essay (with the headings preferred) using deductive reasoning. Here are a few tips:

The purpose of an evaluation essay is to present an opinion or viewpoint on a subject or body of work. The writer should firstly provide a summary of the article in question, then present a point-of-view supported with clear examples and evidence, using a thorough, well-structured argument so that the evaluation seems reasoned and unbiased.
Deductive reasoning starts with a general principle and deduces that it applies to a specific case. Deductive reasoning moves with exacting precision from the assumed truth of a set of premises to a conclusion which cannot be false if those premises are true. Explain the deductive reasoning process applied to analyze the firm’s performance.

Sample Solution

Forecasting, Evaluation

Each complete question will have two parts: 1) a Word document in which the questions are answered and conclusions are explained. And 2) an Excel document which contains the calculations and financial models.

1. Company Q is a publicly-traded company. You forecasted its Enterprise Value to be $3,450 million. The company as 245 million shares outstanding. Would purchasing Company Q’s stock at $15.32 per share be a good investment? Why or why not. If not, then under what circumstances would it be a good investment?

2. Given the following, what would you estimate the EBITDA (Earnings Before Interest Taxes Depreciation and Amortization) value in 2019 for this firm to be? Explain your approach to arriving at this answer.

2016 2017 2018
Revenue 1,250.0 1,281.3 1,306.9
COGS 900.0 928.9 944.9
Depreciation 123.0 145.0 155.0
SG&A 177.5 187.1 188.2
R&D 41.3 38.4 40.5
Operating Income 8.3 -18.2 -21.7

3. Calculate the WACC for a publicly-traded company that has:
a. a beta value of 1.29,
b. an effective tax rate of 12.2%, and
c. Company capital distribution: 40% debt, 60% equity
Use the data from the 9/10/18 value of the Wall Street Journal (below) to calculate your answer. Show your work in the submitted Excel Workbook.








Sample Solution

Data Collection, Analysis, Evaluation, Dissemination of Results, and Conclusion

Among the tobacco smoking patients aged above 60 years diagnosed with COPD, does cessation intervention yield the desired results (quitting) versus continuing to smoke within the first six months of admission



























Sample Solution