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.

***JAVA PROGRAM

Write a method called shrink that accepts an array of integers (that the user inputs) as a parameter and returns a new array containing the result of replacing each pair of integers with the sum of that pair. For example, if an array called list stores the values {7, 2, 8, 9, 4, 15, 7, 1, 9, 10}, then the call of shrink(list) should return a new array containing {9, 17, 19, 8, 19}.

The first pair from the original list is shrunken into 9 (7 + 2),

the second pair is shrunken into 17 (8 + 9), and so on.

If the list stores an odd number of elements, the final element is not collapsed. For example, if the list had been {1, 2, 3, 4, 5}, then the call would return {3, 7, 5}. Your method should not change the array that is passed as a parameter.

Be sure to have a shrink() method

*All variable names are completely up to you, as long as they’re descriptive

*Use the correct data types

*Use comments to explain what you’re coding

*Put your name in a comment

Write a MIPS program to implement the Bubble Sort algorithm, that sorts an input list of

integers by repeatedly calling a “swap” subroutine.

The original unsorted list of integers should be received from the keyboard input. Your program should first prompt the user “Please input an integer for the number of elements:”. After the user enters a number and return, your program outputs message “Now input each element and then a return:”. For example, if the user enters 8 as the number of integers, and then the sequence of integers one by one: 6,5,9,1,7,0,-3,2,-8, it should display “The elements are sorted as: -8, -3, 0, 1, 2, 4, 6, 7, 9” (the output sequence of integers should be either space-separated or comma-separated).

The final sorted list (in increasing order) should be stored in the data area, that starts with the label "list:".

You should NOT implement a different sorting algorithm (e.g. mergesort or quick sort). You will receive 0% if your program does not call subroutine "swap", or if your sorted list is in decreasing order.

Ann obtains a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $4,500,000 at 4.38%. What percent of Ann’s 20^th payment goes to interest?

If Ann obtains a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $4,500,000 at 4.38%. What percent of Ann’s 20^th payment goes to principal?v

A 95.7 kg cart initially sits at rest on a flat track. This cart of charge 0.006 C is placed in an initial potential of 276,228 V, which launches it toward a spring with a spring constant of 416.2 N/m. After being launched, the cart crashes into the spring that brings it to a stop. How far is the spring compressed in order to stop the cart?

Calculate the cell voltage for the following reaction at 25^o C:

                  2 Cr³⁺ (aqueous; 0.010 M) + H₂ (gas at 1 atm)

                                    è 2 Cr²⁺ (aqueous; 0.050 M) + 2H⁺ (aqueous; pH = 2.50)

The E^o for the reaction Cr³⁺ (aq) + e^- ==è Cr²⁺ (aq) is - 0.40 V vs. the standard hydrogen half-cell.

A coil of wire containing N turns is in an external magnetic field that is at a LaTeX: 45^o45 o angle from the plane of the coil and is steadily changing. Under these circumstances, an emf V is induced in the coil. If both the rate of change of the magnetic field and the number of turns in the coil are now doubled (but nothing else changes), what will be the induced emf in the coil?