Design a VHDL module

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

Vilka [71]

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

3 0

3 years ago

What is a problem that technology can help solve that problem?

Maslowich

Seeing what the other side of the world is doing right now

8 0

3 years ago

Read 2 more answers

Which of the following ranges depicts the 2% tolerance range to the full 9 digits provided?

Lyrx [107]

Answer:

the only one that meets the requirements is option C .

Explanation:

The tolerance of a quantity is the maximum limit of variation allowed for that quantity.

To find it we must have the value of the magnitude, its closest value is the average value, this value can be given or if it is not known it is calculated with the formula

x_average = ∑ $x_{i}$ / n

The tolerance or error is the current value over the mean value per 100

Δx₁ = x₁ / x_average

tolerance = | 100 -Δx₁ 100 |

bars indicate absolute value

let's look for these values for each case

a)

x_average = (2.1700000+ 2.258571429) / 2

x_average = 2.2142857145

fluctuation for x₁

Δx₁ = 2.17000 / 2.2142857145

Tolerance = 100 - 97.999999991

Tolerance = 2.000000001%

fluctuation x₂

Δx₂ = 2.258571429 / 2.2142857145

Δx2 = 1.02

tolerance = 100 - 102.000000009

tolerance 2.000000001%

b)

x_average = (2.2 + 2.29) / 2

x_average = 2,245

fluctuation x₁

Δx₁ = 2.2 / 2.245

Δx₁ = 0.9799554

tolerance = 100 - 97,999

Tolerance = 2.00446%

fluctuation x₂

Δx₂ = 2.29 / 2.245

Δx₂ = 1.0200445

Tolerance = 2.00445%

c)

x_average = (2.211445 +2.3) / 2

x_average = 2.2557225

Δx₁ = 2.211445 / 2.2557225 = 0.9803710

tolerance = 100 - 98.0371

tolerance = 1.96%

Δx₂ = 2.3 / 2.2557225 = 1.024624

tolerance = 100 -101.962896

tolerance = 1.96%

d)

x_average = (2.20144927 + 2.29130435) / 2

x_average = 2.24637681

Δx₁ = 2.20144927 / 2.24637681 = 0.98000043

tolerance = 100 - 98.000043

tolerance = 2.000002%

Δx₂ = 2.29130435 / 2.24637681 = 1.0200000017

tolerance = 2.0000002%

e)

x_average = (2 +2,3) / 2

x_average = 2.15

Δx₁ = 2 / 2.15 = 0.93023

tolerance = 100 -93.023

tolerance = 6.98%

Δx₂ = 2.3 / 2.15 = 1.0698

tolerance = 6.97%

Let's analyze these results, the result E is clearly not in the requested tolerance range, the other values may be within the desired tolerance range depending on the required precision, for the high precision of this exercise the only one that meets the requirements is option C .

4 0

3 years ago

A water-filled manometer is used to measure the pressure in an air-filled tank. One leg of the manometer is open to atmosphere.

ddd [48]

Answer:

$P = 150.335\,kPa$ (Option B)

Explanation:

The absolute pressure of the air-filled tank is:

$P = 101.3\,kPa + \left(1000\,\frac{kg}{m^{3}} \right)\cdot \left(9.807\,\frac{kg}{m^{3}} \right)\cdot (5\,m)\cdot \left(\frac{1\,kPa}{1000\,Pa} \right)$

$P = 150.335\,kPa$

4 0

3 years ago

Case Study # 1: Cadbury Crisis Management (Worm Controversy)

Rasek [7]

H is the answer
Step by step

3 0

2 years ago