The following tables form part of a database held in a relational DBMS:

Hotel (hotelNo, hotelName, hotelAddress, country)

Room (roomNo, hotelNo, type, price)

Guest (guestNo, guestName, guestAddress, country)

Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo)

Write the SQL statements for the following questions:

1. List the rooms that are currently unoccupied at the Grosvenor Hotel, for:

(a) Use 2019-10-01 as today's date. Include all 'Grosvenor' hotels. List in hotelNo, roomNo order. Use NOT IN to perform the difference operation

(b) Use 2019-10-01 as today's date. Include all 'Grosvenor' hotels. List in hotelNo, roomNo order. Use NOT EXISTS to perform the difference operation.

(c) Use 2019-10-01 as today's date. Include all 'Grosvenor' hotels. List in hotelNo, roomNo order. Use LEFT JOIN to perform the difference operation.

(d) Use 2019-10-01 as today's date. Include all 'Grosvenor' hotels. List in hotelNo, roomNo order. Use MINUS to perform the difference operation.

Consider a two-year debt instrument with a face value of $5,000 and an annual coupon payment of $125. Suppose prevailing interest rates in the economy are 1.0%.

a. Calculate the predicted price of this instrument. Does it sell for more (a premium) or less (a discount) than $5,000?

b. Calculate the nominal yield of this bond. How does it compare to the prevailing market interest rate of 1.0%? How does this comparison relate to whether the bond is sold at a premium or discount?

c. Calculate the current yield on this bond. Is the current yield higher or lower than the nominal yield?

Use the provided concentrations and volumes to calculate the moles of each reactant.

Equation: Cu(NO3)2 + 2NaHCO3 = CuCO3 + H2O + CO2 + 2NaNO3

75mL of a 1.0 M NaHCO3 solution
15mL of a 1.0 M Cu(NO3)2 solution

1. Moles of Cu(NO3)2 used
2. Moles of NaHCO3 used
3. Which reactant is limiting?
4. How many moles of CuCO3 can actually form from the amount of starting materials used?
5. Calculate the molar mass and theoretical yield of CuCO3 (mass in g).

A thermopane window consists of two glass panes, each 0.50 cm thick, with a 1.0 cm thick sealed layer of air in between

a) if the inside surface temperature is 22.2 c and the outside surface temperature is 0.0 c determine the rate fo energy transfer through 1.35 m^2 of the window

_______W

b) compare your answer to a) with the rate of energy transfer through 1.35 m^2 of a single 1.0 cm thick pane fo glass. Disregard surface air layers( find the rate of energy transfer)

_____kW

Consider a concentration cell that is constructed from a 1.0 M iodide solution on the left and a 0.5 M iodide solution on the right, with solid iodine at both electrodes. Select every statement that is true about this concentration cell.

-Electrons are moving from the electrode with the 0.5 M solution to the electrode with the 1.0 M solution.

-As with all concentration cells, the change in enthalpy for the system is zero.

-As with all concentration cells, the change in entropy for the system is negative.

-As with all concentration cells, the net result of discharging the cell will be to absorb heat from the surroundings and convert it into electrical work.

Two sinusoidal waves combining in a medium are described by the following wave functions, where x is in centimeters and t is in seconds. y1 = (1.0 cm) sin π(x + 0.20t) y2 = (1.0 cm) sin π(x - 0.20t) Determine the maximum transverse position of an element of the medium at the following positions. (a) x = 0.270 cm cm (b) x = 0.400 cm cm (c) x = 1.80 cm cm (d) Find the three smallest values of x corresponding to antinodes. cm (smallest) cm (second smallest) cm (third smallest)

Two 2.5-mm-diameter beads, C and D, are 11 mm apart, measured between their centers. Bead C has mass 1.0 g and charge 1.8 nC .Bead D has mass 2.5 g and charge -1.0 nC.

If the beads are released from rest, what is the speed vC of C at the instant the beads collide?

Express your answer to two significant figures and include the appropriate units.

What is the speed vD of D at the instant the beads collide?

Express your answer to two significant figures and include the appropriate units.

Suppose your firm has decided to use a divisional WACC approach to analyze projects. The firm currently has four divisions, A through D, with average betas for each division of 0.5, 1.0, 1.2, and 1.5, respectively. Assume all current and future projects will be financed with 60 debt and 40 equity, the current cost of equity (based on an average firm beta of 1.0 and a current risk-free rate of 3 percent) is 15 percent and the after-tax yield on the company’s bonds is 9 percent. What will the WACCs be for each division?