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
Engineering ethics is not without abstraction, but in contrast with computing, it is animated by a robust and active movement concerned with the seamless identification of ethics with practice.
<h3 /><h3>What is engineering?</h3>
This is a branch of science and technology concerned with the design, building, and use of engines, machines, and structures that uses scientific principles.
Comparing ethics in engineering and ethics in computing:
- Engineering ethics are a set of rules and guidelines. While computing ethics deals with procedures, values and practices.
- In engineering ethics, engineers must adhere to these rules as a moral obligation to their profession While in computing ethics, the ethics govern the process of consuming computer technology.
- Following these ethics for the two professions will NOT cause damage, but disobeying them causes damage.
Some practical examples in the computing field:
- Avoid using the computer to harm other people such as creating a bomb or destroying other people's work.
- Users also should not use a computer for stealing activities like breaking into a bank or company.
- Make sure a copy of the software had been paid for by the users before it is used.
Some practical examples in the engineering field:
- Integrity for oneself.
- Respect for one another.
- Pursuit of excellence and accountability.
Hence, Engineering ethics is the field of system of moral principles that apply to the practice of engineering and following them is important to the profession.
Read more about <em>engineering</em> here:
brainly.com/question/17169621
#SPJ1
Answer:
<em>the % recovery of aluminum product is 80.5%</em>
<em>the % purity of the aluminum product is 54.7%</em>
<em></em>
Explanation:
feed rate to separator = 2500 kg/hr
in one hour, there will be 2500 kg/hr x 1 hr = 2500 kg of material is fed into the machine
of this 2500 kg, the feed is known to contain 174 kg of aluminium and 2326 kg of rejects.
After the separation, 256 kg is collected in the product stream.
of this 256 kg, 140 kg is aluminium.
% recovery of aluminium will be = mass of aluminium in material collected in the product stream ÷ mass of aluminium contained in the feed material
% recovery of aluminium = 140kg/174kg x 100% = <em>80.5%</em>
% purity of the aluminium product = mass of aluminium in final product ÷ total mass of product collected in product stream
% purity of the aluminium product = 140kg/256kg
x 100% = <em>54.7%</em>
Answer:
for 1st question the answer is 5th option.
for 2nd question the answer is 2nd option
hope it helps you mate
please mark me as brainliast
Where are the statements then bbs lol
