It supporst only 4 Gigabytes of memory in the system
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
Directing, ordering, or controlling
The initial void ratio is the <em>parameter </em>which is used to show the structural foundations for each <em>specimen of sand </em>so that the method and speed of compression would be <em>measured</em>.
Relative density is the mass per unit volume of each specimen of sand which is <em>measured </em>and it has to do with the<em> relative ratio</em> of the density of the sand.
Unit weight is the the exact weight per cubic foot of the sand which is measured.
Please note that your question is incomplete so I gave you a general overview to help you better understand the concept
Read more here:
brainly.com/question/15220801