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
A centrifugal pump is required to pump water to an open water link situated 4 km away from the location of the pump through a pi
11111nata11111 [884]

Answer:

P= 5.5 bar

Explanation:

Given that

L= 4000 m

d= 0.2 m

Friction factor(F) = 0.01

speed V= 2 m/s

Head = 5 m

Head loss due to friction

h_f=\dfrac{FLV^2}{2gd}

h_f=\dfrac{0.01\times 4000\times 2^2}{2\times 9.81\times 0.2}

h_f=40.77m

So the total head(H) = 5 + 40.77 + 10.3 =56.07

Where 10.3 m is the atmospheric head.

We know that

P=ρ g H

So total Pressure

P= 1000 x 9.81 x 56.07 Pa

P=5.5\times 10^5\ Pa

P= 5.5 bar

5 0
3 years ago
Consider two different types of motors. Motor A has a characteristic life of 4100 hours (based on a MTTF of 4650 hours) and a sh
Daniel [21]

Answer:B

Explanation:

Given

For motor A

Characteristic life(r)=4100 hr

MTTF=4650 hrs

shape factor(B )=0.8

For motor B

Characteristic life(r)=336 hr

MTTF=300 hr

Shape Factor (B)=3

Reliability for 100 hours

R_a=e^{-\left ( \frac{T-r}{n}\right )B}

R_a=e^{-\left ( \frac{4650-4100}{100}\right )0.8}

R_a=e^{-4.4}=0.01227

For B

R_b=e^{-\left ( \frac{300-336}{100}\right )3}

R_b=e^{1.08}=2.944

B is better for 100 hours

(b)For 750 hours

R_a=e^{-0.5866}=0.55621

R_b=e^{0.144}=1.154

So here B is more Reliable.

3 0
3 years ago
If a signal is transmitted at a power of 250 mWatts (mW) and the noise in the channel is 10 uWatts (uW), if the signal BW is 20M
Bess [88]

Answer:

C = 292 Mbps

Explanation:

Given:

- Signal Transmitted Power P = 250mW

- The noise in channel N = 10 uW

- The signal bandwidth W = 20 MHz

Find:

what is the maximum capacity of the channel?

Solution:

-The capacity of the channel is given by Shannon's Formula:

                            C = W*log_2 ( 1 + P/N)

- Plug the values in:

                            C = (20*10^6)*log_2 ( 1 + 250*10^-3/10)

                            C = (20*10^6)*log_2 (25001)

                            C = (20*10^6)*14.6096

                           C = 292 Mbps

3 0
3 years ago
How to code the round maze in CoderZ?
dlinn [17]

Answer:

hola

Explanation:

5 0
2 years ago
What are Tresca and Von Mises yield criteria?
elena-s [515]

Answer

For isotropic material plastic yielding depends upon magnitude of the principle stress not on the direction.

Tresca and Von Mises yield criteria are the yield model which is widely used.

The Tresca yield criterion stated that yielding will occur in a material only when the greatest maximum shear stress reaches a critical value.

max{|σ₁ - σ₂|,|σ₂ - σ₃|,|σ₃ - σ₁|} = σ_f

under plane stress condition

  |σ₁ - σ₂| = σ_f

The Von mises yielding criteria stated that the yielding will occur when elastic energy of distortion reaches critical value.

σ₁² - σ₁ σ₂ + σ₂² =  σ²_f

5 0
3 years ago
Other questions:
  • Where are revolved sections placed in a print? A) in between break lines B) cutting planes are used to identify their locations
    12·1 answer
  • 7. Which power source is an important transition between
    7·1 answer
  • Students are expected to respond to one of the two questions described below. Students should provide examples to clarify their
    12·1 answer
  • Use the overall heat-transfer resistance presented by the external air and the glass itself to determine the heat flux in W/m2 i
    10·1 answer
  • 6
    5·1 answer
  • Why do you think there are so many different kinds of can openers?
    10·1 answer
  • 3
    6·1 answer
  • When a company in the United States employs people in India to answer their customer service calls this is an example of
    9·1 answer
  • What type of social engineering targets particular?.
    11·1 answer
  • The centre of the circumstancribing circle of a triangle can be found by using the
    5·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!