Answer:
1. The net power developed=9370.773KW
2. Thermal Efficiency= 0.058
Explanation
Check attachment
Answer: The total vehicle delay is
39sec/veh
Explanation: we shall define only the values that are important to this question, so that the solution will be very clear for your understanding.
Effective red time (r) = 25sec
Arrival rate (A) = 900veh/h = 0.25veh/sec
Departure rate (D) = 1800veh/h = 0.5veh/sec
STEP1: FIND THE TRAFFIC INTENSITY (p)
p = A ÷ D
p = 0.25 ÷ 0.5 = 0.5
STEP 2: FIND THE TOTAL VEHICLE DELAY AFTER ONE CYCLE
The total vehicle delay is how long it will take a vehicle to wait on the queue, before passing.
Dt = (A × r^2) ÷ 2(1 - p)
Dt = (0.25 × 25^2) ÷ 2(1 - 0.5)
Dt = 156.25 ÷ 4 = 39.0625
Therefore the total vehicle delay after one cycle is;
Dt = 39
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
