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:
Absolute pressure=70.72 KPa
Explanation:
Given that Vacuum gauge pressure= 30 KPa
Barometer reading =755 mm Hg
We know that barometer always reads atmospheric pressure at given situation.So atmospheric pressure is equal to 755 mm Hg.
We know that P= ρ g h
Density of
So P=13600 x 9.81 x 0.755
P=100.72 KPa
We know that
Absolute pressure=atmospheric pressure + gauge pressure
But here given that 30 KPa is a Vacuum pressure ,so we will take it as negative.
Absolute pressure=atmospheric pressure + gauge pressure
Absolute pressure=100.72 - 30 KPa
So
Absolute pressure=70.72 KPa
Answer:
Option E
Explanation:
All the given statements are true except the velocity gradients normal to the flow direction are small since these are not normally small. It's true that viscous effects are present only inside the boundary layer and the fluid velocity equals the free stream velocity at the edge of the boundary layer. Moreover, Reynolds number is greater than unity and the fluid velocity is zero at the surface of the object.
Answer:
13.95
Explanation:
Given :
Vector A polar coordinates = ( 7, 70° )
Vector B polar coordinates = ( 4, 130° )
To find A . B we will
A ( r , ∅ ) = ( 7, 70 )
A = rcos∅ + rsin∅
therefore ; A = 2.394i + 6.57j
B ( r , ∅ ) = ( 4, 130° )
B = rcos∅ + rsin∅
therefore ; B = -2.57i + 3.06j
Hence ; A .B
( 2.394 i + 6.57j ) . ( -2.57 + 3.06j ) = 13.95