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:
Distributes a floor load or weight
Explanation:
uniform
welcome 2 Ghana African state western region
Answer:
I = 0.625 A
Explanation:
Given that,
Power of the light bulb, P = 75 W
Voltage of the circuit, V = 120 V
We need to find the current flowing through it. We know that, Power is given by :
I is the electric current
So, the current is 0.625 A.
Answer:
a.) a component item is coded at the lowest level at which it appears in the BOM structure is the correct answer.
Explanation:
- Low-level coding is a kind of programming language used in BOM structures and it carries basic commands that are identified by a computer.
- The two types of low-level coding are
- Assembly language.
- machine language.
- The advantages of using low-level coding are programs develop by using low-level code are very memory effective and quick and there no need to use interpreters for the conversion of the source to machine code.
