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
Which of the following refers to software designed to alter system files and utilities on a victim’s system with the intention o
Oksi-84 [34.3K]
The answer is Rootkits.
6 0
3 years ago
What's the monomer? Show the structure.
ivolga24 [154]

In order to understand a monomer let´s first see the structure of a polymer. As an example, in the first figure polyethylene (or polyethene) is shown. This polymer, like every other one, is composed of many repeated subunits, these subunits are called monomer. In the second figure, polyethylene's monomer is shown.  

7 0
3 years ago
A charge of +2.00 μC is at the origin and a charge of –3.00 μC is on the y axis at y = 40.0 cm . (a) What is the potential at po
Nimfa-mama [501]

a) Potential in A: -2700 V

b) Potential difference: -26,800 V

c) Work: 4.3\cdot 10^{-15} J

Explanation:

a)

The electric potential at a distance r from a single-point charge is given by:

V(r)=\frac{kq}{r}

where

k=8.99\cdot 10^9 Nm^{-2}C^{-2} is the Coulomb's constant

q is the charge

r is the distance from the charge

In this problem, we have a system of two charges, so the total potential at a certain point will be given by the algebraic sum of the two potentials.

Charge 1 is

q_1=+2.00\mu C=+2.00\cdot 10^{-6}C

and is located at the origin (x=0, y=0)

Charge 2 is

q_2=-3.00 \mu C=-3.00\cdot 10^{-6}C

and is located at (x=0, y = 0.40 m)

Point A is located at (x = 0.40 m, y = 0)

The distance of point A from charge 1 is

r_{1A}=0.40 m

So the potential due to charge 2 is

V_1=\frac{(8.99\cdot 10^9)(+2.00\cdot 10^{-6})}{0.40}=+4.50\cdot 10^4 V

The distance of point A from charge 2 is

r_{2A}=\sqrt{0.40^2+0.40^2}=0.566 m

So the potential due to charge 1 is

V_2=\frac{(8.99\cdot 10^9)(-3.00\cdot 10^{-6})}{0.566}=-4.77\cdot 10^4 V

Therefore, the net potential at point A is

V_A=V_1+V_2=+4.50\cdot 10^4 - 4.77\cdot 10^4=-2700 V

b)

Here we have to calculate the net potential at point B, located at

(x = 0.40 m, y = 0.30 m)

The distance of charge 1 from point B is

r_{1B}=\sqrt{(0.40)^2+(0.30)^2}=0.50 m

So the potential due to charge 1 at point B is

V_1=\frac{(8.99\cdot 10^9)(+2.00\cdot 10^{-6})}{0.50}=+3.60\cdot 10^4 V

The distance of charge 2 from point B is

r_{2B}=\sqrt{(0.40)^2+(0.40-0.30)^2}=0.412 m

So the potential due to charge 2 at point B is

V_2=\frac{(8.99\cdot 10^9)(-3.00\cdot 10^{-6})}{0.412}=-6.55\cdot 10^4 V

Therefore, the net potential at point B is

V_B=V_1+V_2=+3.60\cdot 10^4 -6.55\cdot 10^4 = -29,500 V

So the potential difference is

V_B-V_A=-29,500 V-(-2700 V)=-26,800 V

c)

The work required to move a charged particle across a potential difference is equal to its change of electric potential energy, and it is given by

W=q\Delta V

where

q is the charge of the particle

\Delta V is the potential difference

In this problem, we have:

q=-1.6\cdot 10^{-19}C is the charge of the electron

\Delta V=-26,800 V is the potential difference

Therefore, the work required on the electron is

W=(-1.6\cdot 10^{-19})(-26,800)=4.3\cdot 10^{-15} J

4 0
3 years ago
Nancy wants to buy a cooking stove that’s electrically insulated and resistant to heat. What material should she choose for the
astra-53 [7]

Answer:

Ceramics

Explanation:

Ceramics are used to make cooktops if you look it up and according to my engineering and design class ceramics have high heat resistance and melting points, and make good electrical insulators.

3 0
3 years ago
A three-phase wye-connected synchronous generator supplies a network through a transmission line. The network can absorb or deli
Amanda [17]

Answer:

the graph and the answer can be found in the explanation section

Explanation:

Given:

Network rated voltage = 24 kV

Impedance of network = 0.07 + j0.5 Ω/mi, 8 mi

Rn = 0.07 * 8 = 0.56 Ω

Xn = 0.5 * 8 = 4 Ω

If the alternator terminal voltage is equal to network rated voltage will have

Vt = 24 kV/√3 = 13.85 kV/phase

The alternative current is

I_{a} =\frac{40x10^{6} }{\sqrt{3}*24x10^{3}  } =926.2A

X_{s} =0.85\frac{13.85}{926.2} =12.7ohm

The impedance Zn is

\sqrt{0.56^{2}+4^{2}  } =4.03ohm

The voltage drop is

I_{a} *Z_{n} =926.2*4.03=3732.58V

r_{dc} =\frac{voltage}{2*current} =\frac{13.85}{2*926.2} =7.476ohm

rac = 1.2rdc = 1.2 * 7.476 = 8.97 Ω

The effective armature resistance is

Z_{s} =\sqrt{R_{a}^{2}+X_{s}^{2}    } =\sqrt{8.97^{2}+12.7^{2}  } =15.55ohm

The induced voltage for leading power factor is

E_{F} ^{2} =OB^{2} +(BC-CD)^{2}

if cosθ = 0.5

E_{F} =\sqrt{(13850*0.5)^{2}+(\frac{3741}{2}-926.2*12.7)^{2}   } =11937.51V

if cosθ= 0.6

EF = 12790.8 V

if cosθ = 0.7

EF = 13731.05 V

if cosθ = 0.8

EF = 14741.6 V

if cosθ = 0.9

EF = 15809.02 V

if cosθ = 1

EF = 13975.6 V

The voltage regulation is

\frac{E_{F}-V_{t}  }{V_{t} } *100

For each value:

if cosθ = 0.5

voltage regulation = -13.8%

if cosθ = 0.6

voltage regulation = -7.6%

if cosθ = 0.7

voltage regulation = -0.85%

if cosθ = 0.8

voltage regulation = 6.4%

if cosθ = 0.9

voltage regulation = 14%

if cosθ = 1

voltage regulation = 0.9%

the graph is shown in the attached image

for 10% of regulation the power factor is 0.81

8 0
3 years ago
Other questions:
  • A high-voltage direct-current (dc) transmission line between Celilo, Oregon and Sylmar, California is 845 mi in length. The line
    15·1 answer
  • You are a designer of a new processor. You have to choose between two possible implementations (called M1 and M2) of the same ar
    5·1 answer
  • The solid cylinders AB and BC are bonded together at B and are attached to fixed supports at A and C. The modulus of rigidity is
    6·1 answer
  • Help pls I don’t understand the question.
    9·1 answer
  • A paint company produces glow in the dark paint with an advertised glow time of 15 min. A painter is interested in finding out i
    11·1 answer
  • Cual es el costo del kwh
    8·1 answer
  • According to the video, what are some tasks that Construction Managers perform? Check all that apply.
    9·2 answers
  • What are the risks of biohacking? Do you think the risks of biohacking outweigh the advantages? Why or why not?
    5·1 answer
  • At a certain location, wind is blowing steadily at 7 m/s. Determine the mechanical energy of air per unit mass and the power gen
    14·1 answer
  • Conclude from the scenario below which type of documentation Holly should use, and explain why this would be the best choice
    15·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!