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:
False I'm pretty sure sorry If its wrong
Answer:
it is f all of the above
Explanation:
let me know if im right
im not positive if im right but i should be right
Answer:
-50.005 KJ
Explanation:
Mass flow rate = 0.147 KJ per kg
mass= 10 kg
Δh= 50 m
Δv= 15 m/s
W= 10×0.147= 1.47 KJ
Δu= -5 kJ/kg
ΔKE + ΔPE+ ΔU= Q-W
0.5×m×(30^2- 15^2)+ mgΔh+mΔu= Q-W
Q= W+ 0.5×m×(30^2- 15^2) +mgΔh+mΔu
= 1.47 +0.5×1/100×(30^2- 15^2)-9.7×50/1000-50
= 1.47 +3.375-4.8450-50
Q=-50.005 KJ
Explanation:
The end-use industries of thermochromic materials include packaging, printing & coating, medical, textile, industrial, and others. Printing & coating is the fastest-growing end-use industry of thermochromic materials owing to a significant increase in the demand for thermal paper for POS systems. The use of thermochromic materials is gaining momentum for interactive packaging that encourages consumers to take a product off the shelf and use it.