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:
All Brake lights are dimmer than normal because high resistance in the brake switch could be the cause according to Technician B.
Explanation:
According to Technician A
When the bulb is faulty then no current will flow through bulb and it will be open circuit.So no light will produce in bulb .
According to Technician B
When a high resistance inserted in series circuit the voltage across each resistance is reduced and this cause the light glow dimly.
Formula of resistance in series circuit
Rt=r1+r2+r3......
Answer:
heat loss per 1-m length of this insulation is 4368.145 W
Explanation:
given data
inside radius r1 = 6 cm
outside radius r2 = 8 cm
thermal conductivity k = 0.5 W/m°C
inside temperature t1 = 430°C
outside temperature t2 = 30°C
to find out
Determine the heat loss per 1-m length of this insulation
solution
we know thermal resistance formula for cylinder that is express as
Rth =
.................1
here r1 is inside radius and r2 is outside radius L is length and k is thermal conductivity
so
heat loss is change in temperature divide thermal resistance
Q = 
Q = 
Q = 4368.145 W
so heat loss per 1-m length of this insulation is 4368.145 W
Answer:
blah blah blah sh ut up read learn
Answer:
Explanation:
The VC-T engine (for "variable compression, turbocharged") can adjust its compression ratio between 8:1 and 14:1 on the fly, offering high-compression efficiency under light loads and the low compression needed for turbocharged power under hard acceleration.