Table Product:

Table Vendor:

Please write the SQL script and provide screenshots of results for these below queries. Please include the SQL in text format, and all screenshots in one single document.

1. Find the total number of table products
2. Find the average price of all tables
3. Find the total number of products from each vendor
4. Find the average prices by vendors (please include vendor names in the query result)
5. Find the average prices by states

1) Please state which function of money is being used by each of the following activities: Unit of Account (Standard of Value, Medium of Exchange or Store of Value.  Please explain the reasoning behind each answer.

(a) Brenda puts $600 into her cookie jar for a rainy day.

(b) Brenda records the money she has spent on gasoline this year.   

(c) Brenda buys a $100 Savings Bond.

(d) Brenda uses $2,400 to pay her rent.

2)

(a) Please provide a description of Bank Runs.

(b) Explain the main cause of Bank Runs.

(c) Why do you think we no longer see many Bank Runs today.

what does an increase or decrease in the following ratios have on the value of a firm:

1. Cost of goods sold to sales

2. SGA to Sales

3.Gross Profit Margin

4. Asset Turnover

5. Days Sales Outstanding

6.Days sales of Inventory

7. Days Payable Outstanding

8. Inventory Turnover

9.Current Ratio

An asset has an average historical rate of return of 12.1 percent and a variance of 0.01089091. What is the upper percentage range of returns would you expect to see approximately two-thirds of the time? (Round your answer to 2 decimal places. Omit the "%" sign in your response.)

Language: C++
In your main(), use printf() to print out the floating point values for
   some hex data.
   a. To print 1.0, do
         printf("One:      %f\n",0x3FF0000000000000);
      The compiler will give you a warning about the argument being a different
      type than the format, but that is ok.
   b. To print 2.0, do
         printf("Two:      %f\n",0x4000000000000000);
      Remember, to multiply by two, you just add one to the exponent.
   c. Print 4.0, 8.0, and 16.0 (with nice labels, of course).
   d. We can also go the other way. To divide by two, just decreas the 
      exponent by one.  So for 1/2, do
         printf("Half:     %f\n",0x3FE0000000000000);
   e. Print 1/4, 1/8, 1/16.
   f. Negative values have a 1 in the leading bit instead of 0.  A leading 1
      in the bits for a hex digit has value 8, so -1.0 is BFF0000000000000.
      So to print -1.0, do
         printf("Neg One:      %f\n",0xBFF0000000000000);
   g. Print -2, -4, -8, -1/2, -1/4, -1/8 (with nice labels, of course).

*MUST SHOW WORK

1) What mass of hydrogen gas will be produced rom 4.76g of NO and 3.23 g of CH4?

2NO(g)+2CH4(g)-->2HCN(g)+2H2O(g)+H2(g)


2) A 250.0g sample of a metal with a specific heat 0.95 J/g-C is heated to 80.0 C and then placed in a calorimeter with water. The initial temperature of the water is 19.0C and the final temperature of the system is 25.1 C. The heat loss to the calorimeter is negligible. What is the mass of the water?

3) Determine the volume and density of 45.0 g of ethane, C2H6, at STP.

4) A sample of sulfur dioxide occupies 12.0L at 258C and 1.27 psi. What volume will it occupy at STP?

1. Find the balance on the credit card after 3 months with the following information:

APR = 15.99%

Carry-Over balance for month 1 = $793.16

Minimum payment is $50 or 8%, whichever is greater

In a BestFriendSimulation driver class, define and initialize a reference variable called myBestFriends referencing an ArrayList ofBestFriend objects. Then, create a menu that will continue to display itself, and process the requests of the user, until the user requests to exit the menu (loop).

The menu should have 5 menu options:

1.) Add a BestFriend to the arrayList called myBestFriends; 2.) Change a BestFriend in the arrayList; 3.) Remove a BestFriend from the arrayList; 4.) Display all the objects in the myBestFriends arrayList. 5.) Exit

For each of these menu options, be sure to prompt the user for the necessary information such as BestFriend's first name, last name, nickname, and cell phone number.

Hint: In order to be able to change a BestFriend's information or remove a BestFriend from the arrayList, you will have to create a loop that will search the myBestFriends arrayList from beginning to end, and store the index position of the BestFriend that will be updated or removed. If the desired BestFriend is not found, a -1 will be returned from the search, or a not found flag will be set. If the BestFriend is found, use that index position to either change or remove that object from the myBestFriends arrayList.

Make sure you test each of your menu options, and then select the option that prints the table immediately afterwards, to ensure the PhoneBook looks correctly.

1. Create the BestFriend Domain Class
Define and/or instantiate the private static and non-static fields.

Create the constructor

public class BestFriend

{ private static int friendNumber = 0;

     private int friendIdNumber;

     private String firstName;

     private String lastName;

     private String nickName;

     private String cellPhoneNumber;

     public BestFriend (String aFirstName, String aLastName, String aNickName, String aCellPhoneNumber)

    {    firstName = aFirstName;

         lastName = aLastName;

         nickName = aNickName;

         cellPhoneNumber = aCellPhoneNumber;
friendNumber++;

friendIdNumber = friendNumber;

    }

    public String toString( )

    {   

         return friendIdNumber + ". " + nickName + " "  + firstName + " " + lastName + " " + cellPhoneNumber;

    }

Create the set methods (setters)
Create the get methods (getters)

public boolean equals(Object another)
{
      if (another instanceof BestFriend )
     {

     BestFriend anotherBFF = (BestFriend) another;
      if (firstName.equalsIgnoreCase(anotherBFF.firstName) &&
          lastName.equalsIgnoreCase(anotherBFF.lastName)
   //     && nickname.equalsIgnoreCase(anotherBFF.nickName) &&
   //      cellphone.equalsIgnoreCase(anotherBFF.cellPhone))
              return true;
}

         return false;

}

2. Create the BestFriendSimulation Driver Class:
Instantiate an arrayList  called myBFFs

Create a Do …… While loop to create a menu of 5 choices (add, change, remove, display, exit)
Allow the user to input the choice.
Use an if statement (or switch) to execute the user’s choice.

There are many ways to accomplish this task:

Technique #1.) Create a Helper class that defines the arrayList of BestFriends in its constructor, and then also defines the add, change, display, remove, and error methods as instance methods. Instantiate the Helper class from the driver (main) class. Also in the driver class, create the loop to display and process the menu options. When any specific menu option is selected, call the method from the Helper class.

Technique #2.) Instantiate the driver class in the main method (instantiate its own self). Then, define instance methods in the driver class for the add, change, display, remove, and error methods. Call them from the menu loop.

Technique #3.) In the driver class, create static methods for the add, change, display, remove, and error methods. Call them from the menu loop.

In any of the above 3 techniques, the arrayList of BestFriends can be defined as a global variable, so that it does not have to be passed as a parameter to each of the add, change, display, remove, and error methods. Similarly, the Scanner keyboard object should also be defined as a global variable too.

The alternative to defining the arrayList and Scanner keyboard as global variables is to pass these as parameters to each method call. For example:

addBFF(myBFFs, keyboard);

facilities services use a “cooling with dehumidification” system campus-wide. The system is designed to have two stages where in the first stage, the moist air is cooled down while the condensate is exctracted to dehumidify the mixture. Then, in the second stage, the saturated moist air is heated up using heating coils that utilize steam. Assume that the operating pressure is uniform at 1 atm. On a typical hot and humid summer day, air enters the air-conditioning system at 30◦ C with 90% relative humidity and is supplied to the air-conditioned spaces at 18◦ C and 60% relative humidity:

(a) Clearly mark the inlet and exit states of this air-conditioning process on a standard psychrometric chart (use Figure A-31 from your textbook). Also, show on this chart the complete air-conditioning process in between the inlet and exit states.

(b) Calculate the amount of condensed water that will be extracted from the moist air per unit mass of the dry air (in kg H2O/kg of dry air) inside the dehumidifier?

(c) Assume that moist air enters this system at a volumetric flow rate of 100 m3/min. Determine the mass flow rate of dry air (in kg/s) throughout the system.

(d) Determine the rate of heat removed from moist air in the cooling/dehumidifier section (in kJ/s or kW)

(e) Determine the rate of heat added to moist air in the heating section (in kJ/s or kW)

(f) Assume the steam system that is used for heating the moist air stops working due to a malfunction. Determine the temperature of the saturated moist air that will be supplied to conditioned spaces (in ◦ C)

(g) Technicians work on restoring the steam power for the heating section but the system is at 50% operational conditions. Determine the temperature (in ◦ C) and the relative humidity of the moist air that will be supplied to the conditioned spaces.

A floating (strike) European lookback call and a floating (strike) European lookback put, on a nondividend paying stock, both expire at date T. At date t<=T, the underlying stock price approaches zero. [a] Please deduce the lookback call price at t, c(t). Please justify your reasoning without using complex formulas. [b] Please deduce the lookback put price at t, p(t). Please justify your reasoning without using complex formulas.

Copper(II) forms a 1:1 complex with the organic complexing agent R in acidic medium. The formation of the complex can be monitored by spectrophotometry at 480 nm. Use the following data collected under psuedo-first-order conditions to construct a calibration curve of rate versus concentration of R. Find the concentration of copper(II) in an unkown whose rate under the same conditions was 6.2x10^-3 A s-1. Also find the standard deviation of the concentration

Simmons Inc. has an expected net income of 4 million Euros at the end of the year. The company is currently all equity financed but it is planning to buy back equity and undertake some debt so that the debt- to-equity ratio will become 0.5. The debt-to-equity ratio will be kept constant. The assets will be fully depreciated in the next three years, with annual depreciation installments of 1,000,000 Euro each. The company does not plan to acquire any asset. The expected return on unlevered equity for Simmons is 9.25% and the cost of debt is 5.25%. The tax rate on corporate earnings is 32%. What is the value of Simmons’ debt, if the expected EBITDA of the company is perpetual and constant every year? (Assume that the depreciation tax shield is as risky as the rest of the unlevered cash flow)

(a) 15,829,380 Euro
(b) 16,032,251 Euro
(c) 17,987,342 Euro
(d) 18,223,172 Euro

The answer is D: 18,223,171 Euro
Thumb up for correct step-by-step solution. Many thanks.

Question 1 (1 point)

You are likely to buy a larger share of Apple stock in all of the cases below, EXCEPT if:

Question 1 options:

Question 2 (1 point)

If we sort the following assets starting with the most liquid asset, we have:

Question 2 options:

Question 3 (1 point)

Liquidity is:

Question 3 options:

Question 4 (1 point)

The Federal Reserve announces that it wants to increase interest rates at a faster pace than it said previously. In this case, people want to:

Question 4 options:

Question 5 (1 point)

New data come in showing an increase in the inflation rate. You worry that inflation over the next year will be much higher than you thought previously.

Question 5 options:

Question 6 (1 point)

The bond demand curve will shift to the left in all cases below, EXCEPT when:

Question 6 options:

Question 7 (1 point)

The supply curve for bonds will shift out in all cases below, EXCEPT when:

Question 7 options:

Question 8 (1 point)

If bond demand increases,

Question 8 options:

Question 9 (1 point)

You analyze the bond market. One day you observe that bond prices go down while bond market yield increases. The reason could be that:

Question 9 options:

Question 10 (1 point)

Assume that the Fed announces the economy is so strong, they will increase interest rates more times in the coming year than previously announced. This means that:

Question 10 options:

Question 11 (1 point)

A government budget deficit will lead to an ______ in the ______ for/of bonds. This will lead to a(n) ________ in interest rates.

Question 11 options:

Veronica Mars, a recent graduate of Bell’s accounting program, evaluated the operating performance of Dunn Company’s six divisions. Veronica made the following presentation to Dunn’s board of directors and suggested the Percy Division be eliminated. “If the Percy Division is eliminated,” she said, “our total profits would increase by $26,500.”

In the Percy Division, cost of goods sold is $60,500 variable and $16,300 fixed, and operating expenses are $29,100 variable and $20,600 fixed. None of the Percy Division’s fixed costs will be eliminated if the division is discontinued.

Is Veronica right about eliminating the Percy Division? Prepare a schedule to support your answer. (Enter negative amounts using either a negative sign preceding the number e.g. -45 or parentheses e.g. (45).)

Intro to Python

1. Draw a structure chart for one of the solutions to the programming projects of Chapters 4 and 5. The program should include at least two function definitions other than the main function.

2.Describe the processes of top-down design and stepwise refinement. Where does the design start, and how does it proceed?