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
<em>Logs.</em>
<em>Like data logs. Sometimes people make these logs to keep tabs on other people or to get important information put down somewhere that way it is saved and can be looked back upon later. Anytime someone makes an action on the computer, it makes a TMP file representing a log of what you want it to do before the computer quickly get's rid of the file.</em>
<em>-Ɽ3₮Ɽ0 Ⱬ3Ɽ0</em>
<em />
Answer:
Length of beam = 10in
Explanation:
We first calculate the maximum shear force.
Calculating for V, we have:
V = 3200Ib
P = 3200 *2
P = 6.4k
Let's now use the equation for the load for a length.
Using the stress equation,
Inputting figures in the equation, we have:
Solving for L, we have:
L = 10in
Length of beam will = 10in
Answer:
$681.29
Explanation:
The amortization formula seems to apply. The monthly payment on a loan of P at rate r for t years is ...
A = P(r/10)/(1 -(1 +r/12)^(-12t))
For the given loan parameters, the monthly payment is ...
A = $60,000(0.065/12)/(1 -(1 +0.065/12)^(-12·10)) ≈ $681.29
The monthly payment is $681.29.