1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
dusya [7]
3 years ago
9

Colonial Adventure Tours calculates the total price of a trip by adding the trip price plus other fees and multiplying the resul

t by the number of persons included in the reservation. List the reservation ID, trip name, customer’s last name, and total cost for all reservations where the number of persons is greater than four. Use the column name TotalCost for the calculated field.
Engineering
1 answer:
Vilka [71]3 years ago
3 0

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

You might be interested in
Most of the work that engineers do with fluids occurs in nature. True False
zlopas [31]
True depending the jobs
3 0
2 years ago
Air enters the combustor of a jet engine at p1=10 atm, T1=1000°R, and M1=0.2. Fuel is injected and burned, with a fuel/air mass
snow_lady [41]

Answer:

M2 = 0.06404

P2 = 2.273

T2 = 5806.45°R

Explanation:

Given that p1 = 10atm, T1 = 1000R, M1 = 0.2.

Therefore from Steam Table, Po1 = (1.028)*(10) = 10.28 atm,

To1 = (1.008)*(1000) = 1008 ºR

R = 1716 ft-lb/slug-ºR cp= 6006 ft-lb/slug-ºR fuel-air ratio (by mass)

F/A =???? = FA slugf/slugaq = 4.5 x 108ft-lb/slugfx FA slugf/sluga = (4.5 x 108)FA ft-lb/sluga

For the air q = cp(To2– To1)

(Exit flow – inlet flow) – choked flow is assumed For M1= 0.2

Table A.3 of steam table gives P/P* = 2.273,

T/T* = 0.2066,

To/To* = 0.1736 To* = To2= To/0.1736 = 1008/0.1736 = 5806.45 ºR Gives q = cp(To* - To) = (6006 ft-lb/sluga-ºR)*(5806.45 – 1008)ºR = 28819500 ft-lb/slugaSetting equal to equation 1 above gives 28819500 ft-lb/sluga= FA*(4.5 x 108) ft-lb/slugaFA =

F/A = 0.06404 slugf/slugaor less to prevent choked flow at the exit

5 0
2 years ago
For some transformation having kinetics that obey the Avrami equation (Equation 10.17), the parameter n is known to have a value
OleMash [197]

Answer:

t = 25.10 sec

Explanation:

we know that Avrami equation

Y = 1 - e^{-kt^n}

here Y is percentage of completion  of reaction = 50%

t  is duration of reaction = 146 sec

so,

0.50 = 1 - e^{-k^146^2.1}

0.50 = e^{-k306.6}

taking natural log on both side

ln(0.5) = -k(306.6)

k = 2.26\times 10^{-3}

for 86 % completion

0.86 = 1 - e^{-2.26\times 10^{-3} \times t^{2.1}}

e^{-2.26\times 10^{-3} \times t^{2.1}} = 0.14

-2.26\times 10^{-3} \times t^{2.1} = ln(0.14)

t^{2.1} = 869.96

t = 25.10 sec

5 0
3 years ago
Out
olchik [2.2K]

ave you ever seen a Rube Goldberg machine in action? You probably have, even if you didn’t know what it was. A Rube Goldberg machine is a contraption that uses a chain reaction to carry out a simple task. It performs a very basic job in a complicated way.

7 0
3 years ago
The flexural strength or MOR of a ceramic is 310 MPa. A block of the ceramic, which is 20 mm wide, 15 mm high, and 300 mm long,
Alja [10]

Answer:

F=6200\ \text{N}\\

Explanation:

In this problem you need to define the force that acts upon a beam in a 3 point bending problem. I put a picture of the problem taken from Wikipedia:

In this problem the flexural strength is defined with the following formula:

\sigma=\cfrac{3FL}{2bd^2}

where F is the force applied, L the length between the two rods, b the width of the ceramic block and d it's height.

The force is then defined as:

F=\cfrac{2\sigma bd^2}{3L}=6200\ \text{N}

3 0
3 years ago
Other questions:
  • What is an ip<br> Number
    12·1 answer
  • A. For a 200g load acting vertically downwards at point B’, determine the axial load in members A’B’, B’C’, B’D’, C’D’ and C’E’.
    8·1 answer
  • How was math used to determine new origami crease plans?
    10·1 answer
  • A pool of contaminated water is lined with a 40 cm thick containment barrier. The contaminant in the pit has a concentration of
    11·1 answer
  • A hot plate with a temperature of 60 C, 50 triangular profile needle wings of length (54 mm), diameter 10 mm (k = 204W / mK) wil
    6·1 answer
  • A local surf report provides the height of the wave from the trough to the crest of the wave. How does this relate to the wave’s
    11·1 answer
  • What is the best way to collaborate with your team when publishing Instagram Stories from Hootsuite?
    14·1 answer
  • What are difference between conic sectional and solids?
    15·1 answer
  • Help please!!!!!
    12·1 answer
  • Which of the following maintenance items helps to ensure the vehicles engine lasts as long as possible?
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!