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 supercapacitor, also called an ultracapacitor, is a high-capacity capacitor with a capacitance value much higher than other capacitors, but with lower voltage limits, that bridges the gap between electrolytic capacitors and rechargeable batteries.
Explanation:
U mean how to connect them to your phone?
Answer:
a) V = 0.354
b) G = 25.34 GPA
Explanation:
Solution:
We first determine Modulus of Elasticity and Modulus of rigidity
Elongation of rod ΔL = 1.4 mm
Normal stress, δ = P/A
Where P = Force acting on the cross-section
A = Area of the cross-section
Using Area, A = π/4 · d²
= π/4 · (0.0020)² = 3.14 × 10⁻⁴m²
δ = 50/3.14 × 10⁻⁴ = 159.155 MPA
E(long) = Δl/l = 1.4/600 = 2.33 × 10⁻³mm/mm
Modulus of Elasticity Е = δ/ε
= 159.155 × 10⁶/2.33 × 10⁻³ = 68.306 GPA
Also final diameter d(f) = 19.9837 mm
Initial diameter d(i) = 20 mm
Poisson said that V = Е(elasticity)/Е(long)
= - <u>( 19.9837 - 20 /20)</u>
2.33 × 10⁻³
= 0.354,
∴ v = 0.354
Also G = Е/2. (1+V)
= 68.306 × 10⁹/ 2.(1+ 0.354)
= 25.34 GPA
⇒ G = 25.34 GPA
Answer:
28 , 24-inch screwdrivers
Explanation:
The total number of screwdrivers that can be purchased is = 70
4 - inch length screwdrivers = 10
6- inch length screwdrivers = 12
8- inch length screwdrivers = 20
Total = 20 +12 +10 = 42
Remaining = 70-42 = 28
So, heavy 24-inch screwdrivers = 28
