A relational database contains details about journeys from United States to a variety of destinations and contains the following relations:
Operator (opCode, opName)
Journey (opCode, destinationCode,price)
Destination (destinationCode, destinationName, distance,averageFuelCost)
JourneyDetails(destinationCode, departureDate, departureTime, arrivalTime, fuelCost)
I have been told to do a stored procedure UpdateAverageFuelCost() that calculates the average fuel cost( average=fuelcost/distance) for each destination. The procedure should update the value of the averageFuelCost in table Destination and should display the following message:
The average fuel usage for Destination "X" is "Y ",
each time the average fuel cost is updated. The value of X is the destination code and Y is the average fuel cost for that particular destination.
Recently Asked Questions
- 4. What is the skydiver's velocity after two seconds? Show your work and include direction. (3 points) 19.6 ms 5. After three
- 1. Which method best describes how an organism regulates blood glucose levels after consumption of a large meal? a. using negative feedback to increase blood
- Which of the following descriptors best characterizes a non-spontaneous reaction ?