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
Answer:
(A)-Light-Bulb, Automobile Engine, Power Plant, Electric Motor
Explanation:
To get the least efficient to the most efficient the chart below explains how to the get it
Incandescent light bulb-5%
Florescent light bulb-20%
Electric motor-90%
Power plant-35%
Automobile engine-25%
Home oil furnace-80%
Answer:
Upper bounds 22.07 GPa
Lower bounds 17.59 GPa
Explanation:
Calculation to estimate the upper and lower bounds of the modulus of this composite.
First step is to calculate the maximum modulus for the combined material using this formula
Modulus of Elasticity for mixture
E= EcuVcu+EwVw
Let pug in the formula
E =( 110 x 0.40)+ (407 x 0.60)
E=44+244.2 GPa
E=288.2GPa
Second step is to calculate the combined specific gravity using this formula
p= pcuVcu+pwTw
Let plug in the formula
p = (19.3 x 0.40) + (8.9 x 0.60)
p=7.72+5.34
p=13.06
Now let calculate the UPPER BOUNDS and the LOWER BOUNDS of the Specific stiffness
UPPER BOUNDS
Using this formula
Upper bounds=E/p
Let plug in the formula
Upper bounds=288.2/13.06
Upper bounds=22.07 GPa
LOWER BOUNDS
Using this formula
Lower bounds=EcuVcu/pcu+EwVw/pw
Let plug in the formula
Lower bounds =( 110 x 0.40)/8.9+ (407 x 0.60)/19.3
Lower bounds=(44/8.9)+(244.2/19.3)
Lower bounds=4.94+12.65
Lower bounds=17.59 GPa
Therefore the Estimated upper and lower bounds of the modulus of this composite will be:
Upper bounds 22.07 GPa
Lower bounds 17.59 GPa
Answer:
Three objectives of a tariff are
1) To control trade between countries
2) To protect domestic industries
3) To provide a source of income
Three characteristics of a tariff are;
1) Adequate return
2) Attractive
3) Fairness
Explanation:
A tariff is an import or export tax placed on goods traded between countries, it serves to control the foreign trade between the two countries and to protect or develop local industry
A Tariff is an important source of income to countries
Three characteristics of a tariff are;
1) Adequate return
Proper return from the consumer should be factored in a tariff to account for the alternatives or normal expense pattern
2) Attractive
The tariff should be attractive to encourage consumption of electricity or complimentary goods
3) Fairness
Based on the consumption of related resources brought about by large scale utilization, large consumer tariff should be lower than those that consume less complementary resources.
