Answer:
The following query is used to display TripName. Reservationld, FirstName. LastName and TotalCost of trip by adding the trip price plus other fees and multiplying the result by the number of persons which have number of persons >4.
Query:
SELECT ReservationlD, Trip.TripName. Customer.LastName. Customer.FirstName. (TripPrice+OtherFees) 'NumPersons as TotalCost FROM Reservation, Trip, Customer WHERE NumPersons>4 AND Reservation.TriplD=Trip.TriplD AND
Customer. CustomerNum=Reservation.CustomerNum:
Explanation:
- Select clause is used to retrieve data from specified database table or relation and returns the data in the form of table.
- ReservationID. Trip.TripName. Customer.LastName. Customer.FirstName are the column name of table.
- (TripPrice+OtherFees) 'NumPersons will calculate the total cost of the Trip and stored it into TotalCost column.
- As clause is used to give new name TotalCost to resultant column.
- FROM clause specifies one or more table from where records to be retrieved. o Reservation. Trip and Customer are the table name.
- WHERE clause is used in SQL query to retrieve only those records that satisfy the specified condition
Answer:
See attachment and explanation.
Explanation:
- The following question can be solved better with the help of a MATLAB program as follows. The code is given in the attachment.
- The plot of the graph is given in attachment.
- The code covers the entire spectrum of the poly-tropic range ( 1.2 - 1.6 ) and 20 steps ( cases ) have been plotted and compared in the attached plot.
Answer:
a. 1.91 b. -8.13 mm
Explanation:
Modulus =stress/strain; calculating stress =F/A, hence determine the strain
Poisson's ratio =(change in diameter/diameter)/strain
Answer:
A) About 
newtons
B) 76.518 newtons
C) 111.834 newtons
Explanation:
A) 
, where G is the universal gravitational constant, M 1 and 2 are the masses of both objects in kilograms, and r is the radius in meters. Plugging in the given numbers, you get:
B) You can find the weight of each object on Earth because you know the approximate acceleration due to gravity is 9.81m/s^2. Multiplying this by the mass of each object, you get a weight for the first particle of 76.518 newtons.
C) You can do a similar thing to the previous particle and find that its weight is 11.4*9.81=111.834 newtons.
Hope this helps!
