Table Course:    Column    dataType Constraint

ccode char(8) primary key,

meetingTime char(4),

room char(6),

fid    decimal(3) NOT NULL,

cTitle    varchar(24) NOT NULL,

fee    decimal(4,2),   

prereq char(8)

1. Select all Course table data and display in primary key order. Show this query result.

2. By default MySQL runs in autocommit mode. Issue a START TRANSACTION command before a series of update commands that may need to be rolled back or to be committed. ROLLBACK will "undo" commands given in the transaction. [Note: COMMIT is not needed here, but makes work final and completes the transaction.]

You work in a chartered accounting firm and your partner, Sally Smith, has asked you to do some research and write a report to update her about the potential liability that auditors face as a result of the global financial crisis. The issue arose when a neighbour mentioned to Sally at the weekend that a global accounting firm has had a class action lodged against it over the collapse of Lehman Brothers. In your report talk about ASA701 Key Audit Matters and how this has changed the way auditors report.

Using the reference materials available on the internet, research the topic and prepare a report for Sally, fully referenced up to 500 words.

1. Explain illegal payments under the FCPA, giving at least one specific example from an FCPA case. Are there any exceptions? Discuss advantages and disadvantages of this law in terms of US companies doing business abroad.

2. Give one specific example of an advantage, and a disadvantage, of the NAFTA regional free trade agreement. Discuss the effect of NAFTA on the US/Texas economy, both pro and con. Discuss update recommendations regarding this treaty.

3. Give an example of dumping, and explain why it is illegal. Is it good or bad for the US consumer?

4. Discuss the recent move toward the implementation of tariffs in international trade. Why are they being imposed, what is the effect on the US consumer and US businesses?

On July 1, 2016, Farm Fresh Industries purchased a specialized delivery truck for $227,000. At the time, Farm Fresh estimated the truck to have a useful life of eight years and a residual value of $35,000. On March 1, 2021, the truck was sold for $109,000. Farm Fresh uses the straight-line depreciation method for all of its plant and equipment. Partial-year depreciation is calculated based on the number of months the asset is in service. Required: 1. Prepare the journal entry to update depreciation in 2021. 2. Prepare the journal entry to record the sale of the truck. 3. Assuming that the truck was instead sold for $126,000, prepare the journal entry to record the sale.

Scenario: Imagine that you are working as a mid-level administrator within a healthcare system. You have been tasked with chairing a strategic planning task force to revise and update the healthcare system’s strategic plan. Your initial task is to call a meeting with your newly created strategic planning task force. Your first item on the agenda is to engage your task force in generating creative approaches to the strategic planning process.

Please briefly explain (in a minimum of 250 words) to your task force the overall strategic planning process and why creative thinking is important in the strategic planning process and how you will encourage it with your team.

The following activities are for a graduation party.

Buy Tableware                                  Create Guest List                        Purchase Banner                                                                                                                 

Order Food/Drink                              Decorate Venue                           Mail Invitations                                             

Update RSVP                                    Buy Balloons                                

Organize the activities in a work breakdown structure using the final end product and work packages.

Complete an Activity List and Predecessors Table

Put the activities in sequence using a network diagram. Please note there are different ways to sequence the activities. However, you must use the logical order which will fit the box pattern provided.

PUT IN JAVA PROGRAMMING

The StockB class: Design a class named StockB that contains the following properties:
• Name of company
• Number of shares owned
• Value of each share
• Total value of all shares
and the following operations:
• Acquire stock in a company
• Buy more shares of the same stock
• Sell stock
• Update the per-share value of a stock
• Display information about the holdings
• The StockB class should have the proper constructor(s).
• Create/write a client class (program) to test and use your StockB class. In the client program, you need to create objects of the StockB type and use those objects to perform some meaningful and valid stock transactions.

1. We discussed in the lecture that the coronavirus is both an AS and AD shock. Based on the lecture, draw a graph showing both of the movements. You need a properly drawn graph as you did for homework 4.

Update for clarity: For this question, we’re only capturing the effect of the virus itself. Don’t assume there are any particular policies associated with these shocks. It’s probably easiest to think of the AS shock as the reduced labor force as people get sick, and the AD shock as a reduction in consumption.

2. Draw a graph of the AS/AD model if the government becomes concerned about the deficit and decides to cut government spending. You need a properly drawn graph as you did for homework 4.

PUT IN JAVA PROGRAMMING

The StockB class:

Design a class named StockB that contains the following properties:
• Name of company
• Number of shares owned
• Value of each share
• Total value of all shares
and the following operations:
• Acquire stock in a company
• Buy more shares of the same stock
• Sell stock
• Update the per-share value of a stock
• Display information about the holdings
• The StockB class should have the proper constructor(s).
• Create/write a client class (program) to test and use your StockB class. In the client program,

you need to create objects of the StockB type and use those objects

to perform some meaningful and valid stock transactions.

Write a module that contains a function sqrt(y, tol=1e-6), which computes a square root of a number using Heron’s algorithm with guaranteed relative error less then tol. The module should run as a program that asks for user input and prints output when executed using run sqrt.py. Heron’s algorithms for finding x such that y = x^2 works as follows. First, you come up with an initial guess for x; think what it should be. Then, you update x using the following formula: xnew = 1/2 (xold + y/xold) . Computation ends once the relative deviation between x^2 and y is less then the required value.