USE ORACLE - SQL

List the name and salary of employees who work for division 3.

List the name of project whose budget is between 5000-7000

List the total number of employee whose initial of name is 's'. (hint, using LIKE operator and wildcard character)

List the total number of employee whose initial of name is NOT 's' for each division, including division ID

List the total project budget for each division, including division ID.

List the ID of the division that has two or more projects with budget over $6000.

List the ID of division that sponsors project "Web development", List the project budget too.

List the total number of employee whose salary is above $40000 for each division, list division ID.

List the total number of project and total budget for each division, show division ID

List the ID of employee that worked on more than three projects.

List the ID of each division with its highest salary..

List the total number of project each employee works on, including employee's ID and total hours an employee spent on project.

List the total number of employees who work on project 1.

List names that are shared by more than one employee and list the number of employees who share that name.

List the total number of employee and total salary for each division, including division name (hint: use JOIN operation, read the text for join operation)

Answers

Answer 1

To answer your questions using Oracle SQL, you can use the following queries:



1. SELECT name, salary FROM employees WHERE division_id = 3;

2. SELECT name FROM projects WHERE budget BETWEEN 5000 AND 7000;

3. SELECT COUNT(*) FROM employees WHERE name LIKE 's%';

4. SELECT division_id, COUNT(*) FROM employees WHERE name NOT LIKE 's%' GROUP BY division_id;

5. SELECT division_id, SUM(budget) FROM projects GROUP BY division_id;

6. SELECT division_id FROM projects WHERE budget > 6000 GROUP BY division_id HAVING COUNT(*) >= 2;

7. SELECT division_id, budget FROM projects WHERE name = 'Web development';

8. SELECT division_id, COUNT(*) FROM employees WHERE salary > 40000 GROUP BY division_id;

9. SELECT division_id, COUNT(*), SUM(budget) FROM projects GROUP BY division_id;

10. SELECT employee_id FROM project_assignments GROUP BY employee_id HAVING COUNT(project_id) > 3;

11. SELECT division_id, MAX(salary) FROM employees GROUP BY division_id;

12. SELECT employee_id, COUNT(project_id), SUM(hours_worked) FROM project_assignments GROUP BY employee_id;

13. SELECT COUNT(*) FROM project_assignments WHERE project_id = 1;

14. SELECT name, COUNT(*) FROM employees GROUP BY name HAVING COUNT(*) > 1;

15. SELECT d.name, COUNT(e.employee_id), SUM(e.salary) FROM divisions d JOIN employees e ON d.division_id = e.division_id GROUP BY d.name;

learn more about Oracle SQL here:

https://brainly.com/question/15089732

#SPJ11


Related Questions

Determine the magnitude of the moment of the force F={ F = { 50i− i − 26 j j − − 80k}N k } N about the base line CA C A of the tripod. (Figure 1)

Answers

To determine the magnitude of the moment of the force F={ F = { 50i− i − 26 j j − − 80k}N k } N about the base line CA C A of the tripod, we need to first find the perpendicular distance from the force to the base line. We can use the cross product of the vector representing the force and a vector perpendicular to the base line to find this distance.


Let's define the vector representing the base line as CA = {0, 0, 1} (assuming the z-axis is vertical) and a vector perpendicular to CA as n = {1, 0, 0}.

Taking the cross product of n and F, we get:

n x F = {-26j + 80k, 50i + 26k, -50i}

The perpendicular distance from the force to the base line is the magnitude of the projection of this vector onto the unit vector in the direction of CA. Since CA is already a unit vector, we can simply take the dot product:

|n x F| · CA = |-50i| = 50

Therefore, the magnitude of the moment of the force F about the base line CA of the tripod is:

|M| = |F| · d = |{50, -1, -26}| · 50 = 2613.8 Nm (rounded to one decimal place)

So, the magnitude of the moment of the force F about the base line CA of the tripod is 2613.8 Nm.

learn more about tripod here:

https://brainly.com/question/27030396

#SPJ11

For a continuous and aligned-fiber composite, the moduli of elasticity of fiber, matrix, and composite in the longitudinal direction are 100 GPa, 5 GPa, and 33.5 GPa, respectively. 2.1. Determine the volume fraction of the fiber phase. 2.2. The total load sustained by the composite is 10,000 N. What is the magnitude of the load carried by each phase

Answers

Calculation of the volume fraction of the fiber phase: The rule of mixtures can be used to calculate the volume fraction of the fiber phase:

E_c/E = V_f/E_f + (1-V_f)/E_m

where E_c is the modulus of elasticity of the composite, E_f is the modulus of elasticity of the fiber, E_m is the modulus of elasticity of the matrix, and V_f is the volume fraction of the fiber phase.Substituting the given values:33.5 GPa / 100 GPa = V_f / 5 GPa + (1 - V_f) / 5 GPaSolving for V_f:V_f = 0.7 or 70%Therefore, the volume fraction of the fiber phase is 70%.Calculation of the load carried by each phaseThe load carried by each phase can be determined by considering the stress in each phase. The stress in the fiber phase and matrix phase is assumed to be equal due to the assumption of perfect bonding between the phases. Therefore, the stress in the composite can be calculated as:

To learn more about  click on the link below:

brainly.com/question/12646219

#SPJ11

A depositional feature that has been built on the inside of a stream channel curve because of lower velocity is

Answers

A depositional feature that has been built on the inside of a stream channel curve due to lower velocity is called a point bar.A depositional feature that has been built on the inside of a stream channel curve because of lower velocity is known as a point bar. Point bars are formed due to the slower flow of water on the inside curve of the stream channel, which causes the sediment to settle and accumulate over time.

This results in the formation of a long, curved bank or bar of sediment that is often covered in vegetation. The point bar typically extends from the inner bank of the stream channel and can be several meters high and tens of meters wide. Overall, the formation of point bars is an important natural process that contributes to the formation and maintenance of healthy stream ecosystems.

A point bar is a crescent-shaped deposit of sediment that accumulates on the inside of a stream channel bend, where the water velocity is lower. As the water flows around the bend, it loses energy and drops the sediment it has been carrying, causing the formation of a point bar. Over time, point bars can grow and extend outward into the stream channel, creating a natural levee that helps contain the water within the channel during flooding events.

To know more about curve visit :-

https://brainly.com/question/30100574

#SPJ11

Air is to be cooled in the evaporator section of a refrigerator by passing it over a bank of 0.8-cm-outer-diameter and 0.4-m-long tubes inside which the refrigerant is evaporating at 2208C. Air approaches the tube bank in the normal direction at 08C and 1 atm with a mean velocity of 4 m/s. The tubes are arranged in-line with longitudinal and transverse pitches of SL 5 ST 5 1.5 cm. There are 30 rows in the flow direction with 15 tubes in each row. Determine (a) the refrigeration capacity of this system and (b) pressure drop across the tube bank. Evaluate the air properties at an assumed mean temperature of 258C and 1 atm. Is this a good assumption

Answers

The given information is about an evaporator section of a refrigerator with air cooling over a bank of tubes containing refrigerant. To determine the refrigeration capacity and pressure drop, we will need to use the given tube dimensions, air properties, and tube arrangement. a) Refrigeration capacity depends on the heat transfer rate between the air and the refrigerant.

For this, we need to find the convective heat transfer coefficient and the overall heat transfer area. With the provided tube dimensions and arrangement, we can calculate the overall heat transfer area (A) by multiplying the tube outer perimeter (P = πD) by the tube length (L), number of tubes (N), and rows (R): A = P * L * N * R. Using the given air properties (mean temperature of 25°C and 1 atm), we can find the convective heat transfer coefficient (h) using appropriate correlations (e.g., Nusselt number for forced convection over cylinders). Once we have h and A, we can calculate the overall heat transfer rate (Q) and thus the refrigeration capacity.

b) Pressure drop across the tube bank can be calculated using appropriate pressure drop correlations for the given tube arrangement (in-line with longitudinal and transverse pitches). These correlations usually involve dimensionless parameters such as Reynolds number (Re) and friction factor (f), which can be determined using the given air properties. Evaluating air properties at an assumed mean temperature of 25°C and 1 atm is a reasonable assumption for this problem since the air temperature range is relatively narrow (0-25°C), and the pressure is constant at 1 atm.

Learn more about temperature here-

https://brainly.com/question/11464844

#SPJ11

Typical sheet-metal thicknesses are between 0.4 mm (1/64 in) and 6 mm (1/4 in). When thickness exceeds the upper limit of this range, the stock is usually referred to as

Answers

When the thickness of sheet metal exceeds 6 mm (1/4 in), the stock is usually referred to as plate.

The main difference between sheet metal and plate is their thickness. Sheet metal is typically thin and flexible, while plate is thicker and more rigid. The thickness of plate can range from 6 mm (1/4 in) to several inches, depending on the application. Plate is commonly used in heavy-duty construction projects, such as building bridges, ships, and large industrial machinery. Plate is also used in the manufacturing of structural components, pressure vessels, and storage tanks that require high strength and durability.

To learn more about exceeds  click on the link below:

brainly.com/question/15116264

#SPJ11

What is the degree of curvature, by the arc definition, for a circular curve of radius 350, 1400, 2700 ft.

Answers

The degree of curvature, by the arc definition, is defined as the central angle subtended by an arc of one station length (100 ft) along a circular curve. It is expressed in degrees, minutes, and seconds. To calculate the degree of curvature for a circular curve of radius 350 ft, we first need to determine the arc length of one station.

We can use the formula: Arc length = (2πr) (Degree of curvature / 360) Where r is the radius of the circular curve. For a radius of 350 ft, the arc length of one station is: Arc length = (2π x 350) (100 / 360) = 191.78 ft  To find the degree of curvature, we can use the formula: Degree of curvature = (360 x Arc length) / (2πr)  Plugging in the values, we get: Degree of curvature = (360 x 191.78) / (2π x 350) = 32° 32' 38.3" Similarly, for a radius of 1400 ft, the arc length of one station is: Arc length = (2π x 1400) (100 / 360) = 766.11 ft  Degree of curvature = (360 x 766.11) / (2π x 1400) = 8° 29' 17.9" And for a radius of 2700 ft: Arc length = (2π x 2700) (100 / 360) = 1479.17 ft  Degree of curvature = (360 x 1479.17) / (2π x 2700) = 4° 45' 31.9" Therefore, the degree of curvature for a circular curve of radius 350, 1400, and 2700 ft is 32° 32' 38.3", 8° 29' 17.9", and 4° 45' 31.9", respectively, by the arc definition.

Learn more about radius here-

https://brainly.com/question/13449316

#SPJ11

a phase angle of 120◦ was added to a 3 mhz signal, causing its waveform to shift by delta t along the time axis. in what direction did it shift [ select ] ?and by how much [ select ] ? 1. PLEASE SHOW PHASOR BEFORE AND AFTER SHIFT.

2. PLOT TIME DOMAIN AND PHASOR DOMAIN DIAGRAMS.

Answers

The given 3 MHz signal can be represented by a phasor, which is a complex number that has a magnitude and a phase angle. The phasor diagram before the phase angle shift would have a magnitude of the signal amplitude and a phase angle of 0 degrees, since the signal is in phase with the reference.

In the time domain, this phase shift will cause the waveform to shift to the left or right depending on the sign of delta t. If delta t is positive, the waveform will shift to the left, and if delta t is negative, the waveform will shift to the right. The amount of the shift can be calculated using the formula delta t = delta phi / (2pif), where delta phi is the phase angle shift in radians, f is the frequency of the signal.In summary, the phasor diagram before the phase shift will have a magnitude of the signal amplitude and a phase angle of 0 degrees. After the phase shift, the phasor diagram will shift by 120 degrees in the counterclockwise direction, while the magnitude of the phasor will remain the same. The waveform will shift to the left or right depending on the sign of delta t, and the amount

To learn more about represented  click on the link below:

brainly.com/question/14673216

#SPJ11

The sleek design and the superb engineering of our latest hybrid vehicle ____ it appealing to a wide range of customers.

Answers

The sleek design and the superb engineering of our latest hybrid vehicle make it appealing to a wide range of customers.

The design and engineering of our hybrid vehicle are top-notch, combining both form and function. The sleek exterior is not only visually appealing but also aerodynamically efficient, while the hybrid technology under the hood is engineered to provide maximum fuel efficiency and performance.

As a result, our latest hybrid vehicle is sure to appeal to a wide range of customers who are looking for a stylish, efficient, and environmentally friendly vehicle. Whether they are concerned about reducing their carbon footprint, saving money on gas, or simply looking for a high-performance vehicle, our hybrid model is sure to satisfy their needs.

To know more about engineering visit:

https://brainly.com/question/31140236

#SPJ11

A natural stream with little vegetation has two sections carrying equal amounts of water. You can assume each cross section can be modeled as a rectangle. The first segment (upstream) of the stream has a width of 2m and water depth of 0.5m. The stream bed drops 10m over a distance of 500m. a. What is the velocity of the water flowing? b. What is the flow rate?

Answers

A natural stream with two rectangular cross sections carrying equal amounts of water is analyzed. The upstream section has a width of 2 meters and a water depth of 0.5 meters. Over a distance of 500 meters, the stream bed drops by 10 meters.

a. To find the velocity of the water flowing, we can use the formula v = √(2gh), where v is the velocity, g is the gravitational acceleration (approximately 9.81 m/s²), and h is the vertical drop in height. In this case, h = 10 meters.  v = √(2 × 9.81 × 10) v ≈ 14.0 m/s The velocity of the water flowing in the stream is approximately 14.0 meters per second. b. To calculate the flow rate, we use the formula Q = A × v, where Q is the flow rate, A is the cross-sectional area of the stream, and v is the velocity. The area A can be determined by multiplying the width and depth of the stream: A = 2m × 0.5m = 1 m². Q = 1 m² × 14.0 m/s Q = 14.0 m³/s The flow rate of the stream is 14.0 cubic meters per second.

Learn more about velocity here-

https://brainly.com/question/17127206

#SPJ11

Consider a two-stage cascade refrigeration system operating between the pressure limits of 0.8 and 0.14 MPa. Each stage operates on the ideal vapor-compression refrigeration cycle with refrigerant-134a as the working fluid. Heat rejection from the lower cycle to the upper cycle takes place in an adiabatic counterflow heat exchanger where both streams enter at about 0.4 MPa. If the mass flow rate of the refrigerant through the upper cycle is 0.24 kg/s, determine (a) the mass flow rate of the refrigerant through the lower cycle, (b) the rate of heat removal from the refrigerated space and the power input to

Answers

(a)  The mass flow rate of the refrigerant through the upper cycle is 0.24 kg/s. Due to the lack of information on enthalpy values or temperature, a specific numerical answer cannot be provided.

(b)  With this information, we could calculate the heat absorbed in the evaporators and the power consumed by the compressors.

In a two-stage cascade refrigeration system operating between pressure limits of 0.8 MPa and 0.14 MPa with refrigerant-134a as the working fluid, and heat rejection from the lower cycle to the upper cycle taking place in an adiabatic counterflow heat exchanger with both streams entering at about 0.4 MPa:

(a) To determine the mass flow rate of the refrigerant through the lower cycle, we need to use the energy balance equation for the adiabatic counterflow heat exchanger. Since both streams enter at the same pressure (0.4 MPa), their enthalpy values must be equal.

Given the mass flow rate of the refrigerant through the upper cycle is 0.24 kg/s, we can solve for the mass flow rate of the refrigerant through the lower cycle.

However, due to the lack of information on enthalpy values or temperature, a specific numerical answer cannot be provided.

(b) To calculate the rate of heat removal from the refrigerated space and the power input to the system, we would need more information about the operating temperatures and the enthalpy values at different points in the cycle.

With this information, we could calculate the heat absorbed in the evaporators and the power consumed by the compressors.

However, without the additional data, we cannot provide specific values for the heat removal rate and power input.

Know more about the mass flow rate

https://brainly.com/question/23946677

#SPJ11

What is the condition of the refrigerant as it leaves the evaporator of a vapor-cycle cooling system

Answers

At the exit of the evaporator in a vapor-cycle cooling system, the refrigerant is in a low-pressure and low-temperature vapor state that serves as a cooling agent for the conditioned space.

As the refrigerant leaves the evaporator in a vapor-cycle cooling system, it is in a low-pressure, low-temperature gaseous state. The evaporator absorbs heat from the surrounding space, causing the refrigerant to evaporate and become a low-pressure gas. This gas is then drawn into the compressor, where it is compressed and heated before being sent to the condenser. In the condenser, the high-pressure, high-temperature gas gives off heat to the environment and condenses back into a liquid. The liquid then passes through an expansion valve, which reduces its pressure and temperature, preparing it to enter the evaporator again and restart the cycle.

Learn more about temperature here; https://brainly.com/question/11464844

#SPJ11

water at 60 degrees celsius flows between two large flat plates. The lower plate moves to the left at a speed 0.3 m/s; the upper plate is stationary. the plate spacing is 3mm, and the flow is laminar. Determine the pressure gradient required to produce zero net flow at a cross section

Answers

Based on the given information, we can assume that this is a steady-state flow between two parallel plates and that the flow is laminar.

This means that the velocity of the fluid is constant at every point in the flow and that there are no turbulent fluctuations.
To determine the pressure gradient required to produce zero net flow at a cross-section, we can use the following formula:
ΔP/Δx = (12μVh)/(L^2)
where:
ΔP/Δx = pressure gradient (Pa/m)
μ = dynamic viscosity of the fluid (Pa s)
V = velocity of the lower plate (m/s)
h = distance between the plates (m)
L = length of the plates (m)
Plugging in the given values, we get:
ΔP/Δx = (12 x 0.001 x 0.3 x 0.003)/(1^2)
ΔP/Δx = 0.000324 Pa/m
Therefore, a pressure gradient of 0.000324 Pa/m is required to produce zero net flow at a cross-section.
To produce zero net flow in this scenario, the pressure gradient must counteract the shear stress induced by the lower plate moving at 0.3 m/s. Since the flow is laminar, we can use the following relationship between shear stress (τ), dynamic viscosity (μ), and velocity gradient (dv/dy):
τ = μ(dv/dy)
For a Couette flow (flow between two parallel plates), the velocity gradient can be expressed as:
dv/dy = Δv/Δy = (v_upper - v_lower) / plate_spacing
In this case, v_upper = 0 m/s (stationary upper plate), v_lower = 0.3 m/s, and plate_spacing = 0.003 m (3mm). Therefore:
dv/dy = (0 - 0.3) / 0.003 = -100 s⁻¹
Now, we need the dynamic viscosity of water at 60°C, which is approximately 0.000464 Pa·s. Using the relationship between shear stress and velocity gradient:
τ = (0.000464 Pa·s) * (-100 s⁻¹) = -0.0464 Pa
Finally, we can find the pressure gradient (ΔP/Δx) required to produce zero net flow. The shear force due to the pressure gradient must be equal and opposite to the shear stress:
ΔP/Δx = τ / plate_spacing = -0.0464 Pa / 0.003 m
ΔP/Δx ≈ -15.47 Pa/m
So, a pressure gradient of approximately -15.47 Pa/m is required to produce zero net flow at a cross-section in this laminar flow situation.

Learn more about laminar here:

https://brainly.com/question/23008935

#SPJ11

Air at 25 8 C blows over a heated steel plate with its surface maintained at 200 8 C. The plate is 50 3 40 cm and 2.5 cm thick. The convective heat-transfer coefficient at the top surface is 20 W/(m 2 K). The thermal conductivity of steel is 45 W/(m K). Calculate the heat loss per hour from the top surface of the plate.

Answers

To calculate the heat loss per hour from the top surface of the steel plate, we need to use the formula for convective heat transfer:

Q = h * A * (T_s - T_inf)

where Q is the heat loss per hour, h is the convective heat transfer coefficient, A is the surface area of the plate, T_s is the temperature of the plate surface, and T_inf is the temperature of the air.We can start by calculating the surface area of the plateA = l * w = (0.5 m) * (0.4 m) = 0.2 m^Next, we need to calculate the temperature difference between the plate and the air:delta_T = T_s - T_inf = (200°C - 25°C) = 175°CNow we can use the given convective heat transfer coefficient to calculate the heat loss per hour:Q = h * A * delta_T = (20 W/(m^2*K)) * (0.2 m^2) * (175°C) = 700 WTo convert this to kilowatt-hours per hour, we need to divide by 1000:Q = 0.7 kWh/hourTherefore, the heat loss per hour from the top surface of the steel plate is 0.7 kWh/hour.

To learn more about convective click on the link below:

brainly.com/question/13354186

#SPJ11

Determine whether the following pairs of expressions are logically equivalent. Prove your answer. If the pair is logically equivalent, then use a truth table to prove your answer.

(a) ¬(p ∨ ¬q) and ¬p ∧ q

(b) ¬(p ∨ ¬q) and ¬p ∧ ¬q

(c) p ∧ (p → q) and p → q

(d)p ∧ (p → q) and p ∧ q

Answers

To determine the logical equivalence of the given pairs of expressions, we will analyze each pair and provide a concise explanation of their equivalence or non-equivalence.

(a) ¬(p ∨ ¬q) and ¬p ∧ q: These expressions are logically equivalent. Using De Morgan's Law, we can simplify the first expression as follows: ¬(p ∨ ¬q) ≡ ¬p ∧ ¬¬q ≡ ¬p ∧ q (b) ¬(p ∨ ¬q) and ¬p ∧ ¬q: These expressions are not logically equivalent. As shown in (a), ¬(p ∨ ¬q) simplifies to ¬p ∧ q, which is different from ¬p ∧ ¬q. (c) p ∧ (p → q) and p → q: These expressions are not logically equivalent. The first expression requires both p to be true and p → q to be true (which implies q must be true when p is true). The second expression only requires that when p is true, q must be true. (d) p ∧ (p → q) and p ∧ q: These expressions are logically equivalent. We can analyze the first expression using the definition of the conditional operator (→): p ∧ (p → q) ≡ p ∧ (¬p ∨ q) ≡ (p ∧ ¬p) ∨ (p ∧ q) ≡ False ∨ (p ∧ q) ≡ p ∧ q Thus, all pairs except for (b) and (c) are logically equivalent.

Learn more about De Morgan's Law here-

https://brainly.com/question/29102868

#SPJ11

________ of large or complex electrical systems must always include line numbers, cross reference numbers, terminal numbers, and as much other information as needed.

Answers

Documentation of large or complex electrical systems must always include line numbers, cross reference numbers, terminal numbers, and as much other information as needed.

Documentation is the architect's blueprint and the conductor's score of the electrical symphony, meticulously capturing the essence of complex systems in written form.

Like a detailed map through a labyrinth, it provides a roadmap for engineers and technicians, guiding their hands and minds with precision. It weaves together essential details such as line numbers, cross-reference numbers, and terminal numbers, unveiling the inner workings of intricate circuits.

This symphony of information not only ensures smooth installations and maintenance but also safeguards against dissonance and chaos. In the realm of electrical engineering, documentation reigns as the guardian of harmony and coherence.

Learn more about symphony here:

https://brainly.com/question/34195578

#SPJ12

Which architectural pattern has the highest recovery time objective (RTO) and recovery point objective (RPO)

Answers

The architectural pattern that typically has the highest recovery time objective (RTO) and recovery point objective (RPO) is the Disaster Recovery (DR) pattern.

This pattern involves duplicating critical systems and data in a separate location, often in a different geographic region, to ensure that in the event of a catastrophic failure or disaster, operations can be restored quickly and with minimal data loss. However, it's important to note that the RTO and RPO for DR can vary depending on the specific implementation and the level of redundancy and failover capabilities that are put in place.

To know about disaster recovery pattern, visit:

https://brainly.com/question/29749884

#SPJ11

The osmotic pressure of an aqueous solution is determined to be 150 kPa at 350 K. Compute the freezing and boiling temperatures of the mixture.

Answers

To compute the freezing and boiling temperatures of the mixture, we need to consider the osmotic pressure and the colligative properties of the solution.

The osmotic pressure (150 kPa) affects the freezing and boiling points of the solution due to the presence of solutes in the aqueous mixture.
For freezing point depression, the formula is:
ΔTf = Kf * molality * i
For boiling point elevation, the formula is:
ΔTb = Kb * molality * i
Here, ΔTf and ΔTb are the changes in freezing and boiling points, Kf and Kb are the cryoscopic and ebullioscopic constants, molality is the molal concentration of the solution, and i is the van't Hoff factor.
Since the osmotic pressure is given, we can use the formula:
Π = n * R * T / V

Where Π is the osmotic pressure (150 kPa), n is the number of moles, R is the gas constant (8.31 J/mol·K), T is the temperature (350 K), and V is the volume. We can solve for the number of moles and use it to determine the molality.
However, without the specific solute, the cryoscopic and ebullioscopic constants (Kf and Kb) for water cannot be used to calculate the exact freezing and boiling points. If you provide the solute and its molar mass, I can help you find the freezing and boiling temperatures of the mixture.

Learn more about  molality here: https://brainly.com/question/30640726

#SPJ11

Technician A says when the left-side axle shaft on an FWD vehicle is longer than the right side, torque steer is reduced. Technician B says the torsional damper on the axle shaft automatically balances the shaft. Who is correct

Answers

Technician A is correct because when the left-side axle shaft on an FWD vehicle is longer than the right side, torque steer is reduced. Technician B's statement about the torsional damper automatically balancing the shaft is incorrect.

Torque steer is a phenomenon in front-wheel-drive vehicles where the engine's torque causes the car to pull to one side during acceleration. This occurs because of the unequal length of the axle shafts, which results in different amounts of torque being applied to each wheel. When the left-side axle shaft is longer than the right side, the torque is distributed more evenly between the wheels, reducing torque steer.

On the other hand, a torsional damper is designed to reduce vibrations and noise in the drivetrain, not to balance the axle shafts. Therefore, Technician A's statement is accurate, while Technician B's statement is incorrect.

Learn more about torque here:

https://brainly.com/question/31248352

#SPJ11

8 mm A steel bar (Es = 210 GPa) and an aluminum bar (Eg = 70 GPa) are bonded together to form the composite bar shown. Determine the maximum stress in (a) the aluminum, (b) the steel, when the bar is bent about a horizontal axis, with M= 60 N.m.

Answers

Calculate the values for the given dimensions and material properties to find the maximum stress in both the aluminum and steel bars when the composite bar is bent about a horizontal axis with M = 60 N.m.

To determine the maximum stress in both the aluminum and steel bars, we can use the flexure formula:

σ = (M * y) / I

where σ is the stress, M is the bending moment (60 N.m), y is the distance from the neutral axis to the outer fiber, and I is the moment of inertia.

For the composite bar, we first need to find the neutral axis, y_n. Since the materials are bonded together, we can assume that they have the same strain. Then we can find the distance of the neutral axis from the top fiber as:

y_n = [(A_steel * y_steel) + (A_aluminum * y_aluminum)] / (A_steel + A_aluminum)

where A_steel and A_aluminum are the areas of the steel and aluminum bars, respectively, and y_steel and y_aluminum are the distances from the top fiber to the centroid of the steel and aluminum bars, respectively.

Once we find the neutral axis, we can calculate the moment of inertia, I, for the composite bar:

I = I_steel + A_steel * (y_steel - y_n)^2 + I_aluminum + A_aluminum * (y_aluminum - y_n)^2

Now, we can use the flexure formula to find the maximum stress in the aluminum and steel bars. For the aluminum bar:

σ_aluminum = (M * (y_n - y_aluminum)) / I

And for the steel bar:

σ_steel = (M * (y_steel - y_n)) / I

learn more about material properties here:

https://brainly.com/question/13495300

#SPJ11

a continuous wave modulated signal is transmitted over a noisy channel with the given the power spectral density of the noise is. The carrier signal is c(t0, frequency sensitivity is and the input message signal is. a. Determine the minimum value of carrier amplitude for FM modulation that will yield. b. What are the average signal and noise powers at the input and the output of FM demoudation

Answers

The given information is not complete to solve the problem. The power spectral density of the noise and the message signal are missing.

Without this information, we cannot determine the minimum value of carrier amplitude for FM modulation or the average signal and noise powers at the input and output of FM demodulation. Please provide the missing information so that we can solve the problem.a continuous wave modulated signal is transmitted over a noisy channel with the given the power spectral density of the noise is. The carrier signal is c(t0, frequency sensitivity is and the input message signal.

To learn more about noise click the link below:

brainly.com/question/30835381

#SPJ11

Are neural networks easier to train than polynomial models?

Answers

It is not necessarily true that neural networks are easier to train than polynomial models.

The ease of training depends on the complexity of the model and the amount and quality of the training data. Simple polynomial models with low degrees may be easier to train than complex neural networks with many layers and parameters. Conversely, if the data has complex nonlinear relationships, a neural network may be better suited to capture those relationships than a polynomial model. Ultimately, the choice between these models depends on the specific problem and the available resources for training and computation.

To learn more about necessarily  click on the link below:

brainly.com/question/30011862

#SPJ11

Calculate the number of kilowatt-hours (kW-hrs) consumed in a weekend (two days) by an 600-Watt microwave oven that is used for 7 hours each day. Group of answer choices 0.42 kW-hrs 4.2 kW-hrs 8.4 kW-hrs 0.84 kW-hrs

Answers

To calculate the number of kilowatt-hours consumed by a 600-Watt microwave oven that is used for 7 hours each day over a weekend (two days), we can use the following formula:

Energy (kWh) = Power (kW) x Time (hours)First, we need to convert the power of the microwave oven from watts to kilowatts by dividing it by 1000:Power (kW) = 600 W / 1000 = 0.6 kWNext, we can calculate the energy consumed by the microwave oven over the weekend:Energy (kWh) = 0.6 kW x 7 hours x 2 days = 8.4 kWhTherefore, the number of kilowatt-hours consumed by the microwave oven over the weekend is 8.4 kWh.

To learn more about consumed click on the link below:

brainly.com/question/13381217

#SPJ11

Determine the stress concentration factor in a 0.2 inch thick flat bar with two symmetric grooves (semi-circular notches) of radius 0.3 inches and width 2.6 inches. Notched rectangular bar in tension or simple compression. sigma_0 = F/A, where A = dt and t is the thickness.

Answers

In order to determine the stress concentration factor in a notched rectangular bar, we must first understand what stress concentration is.

Stress concentration occurs when there is a localized increase in stress due to a change in the geometry of the material. This can happen when there are notches, holes, or other irregularities in the material. In this case, we are dealing with a flat bar with two symmetric grooves (semi-circular notches) of radius 0.3 inches and width 2.6 inches. We need to determine the stress concentration factor for this bar in tension or simple compression. To do this, we use the formula Kt = sigma_max / sigma_0, where Kt is the stress concentration factor, sigma_max is the maximum stress at the notch, and sigma_0 is the stress at the unnotched section of the bar.

We can determine sigma_0 using the formula sigma_0 = F/A, where A = dt and t is the thickness of the bar. Let's assume that we have a force of 10,000 pounds acting on the bar. The area of the unnotched section is A = (0.2)(2.6) = 0.52 square inches. Therefore, sigma_0 = 10,000 / 0.52 = 19,230 psi. To determine sigma_max, we need to use a stress concentration factor chart or formula that takes into account the geometry of the notches. For a rectangular bar with semi-circular notches, we can use the formula Kt = 1 + 2(a/b)^0.5, where a is the radius of the notch and b is the width of the bar. Plugging in our values, we get Kt = 1 + 2(0.3/2.6)^0.5 = 1.53.

Therefore, sigma_max = Kt * sigma_0 = 1.53 * 19,230 = 29,410 psi. Finally, we can calculate the stress concentration factor: Kt = sigma_max / sigma_0 = 29,410 / 19,230 = 1.53. This means that the maximum stress at the notches is 1.53 times greater than the stress at the unnotched section of the bar.

Learn more about stress  here: https://brainly.com/question/31366817

#SPJ11

A sugar solution undergoes laminar flow from a reservoir to a product preparation vessel through a(n) 3.0-in. diameter pipe. The pipe needs replacing and a vendor suggests replacing the 3.0-in. pipe with a number of 1.5-in. diameter pipes. How many 1.5-in. pipes will it take to provide the same flow rate as one 3.0-in. pipe

Answers

Both technicians are partially correct, as both statements are true and related to the charging system output test.

Technician A is correct in stating that the regulated voltage should be between the manufacturer's specified minimum and maximum voltage. This is important because if the voltage is too low, the battery may not be properly charged, while if the voltage is too high, it could damage the battery and other electrical components.Technician B is also correct in stating that if the regulated voltage is incorrect, it's necessary to verify that there are no voltage drops on the alternator and regulator wires/cables. Voltage drops in these wires can result in a lower than expected voltage output and can cause charging system issues. Checking these wires is an important step in troubleshooting the charging system if the regulated voltage is incorrect.Therefore, the correct answer is that both technicians are correct, and their statements are complementary to each other.

To learn more about  partially click on the link below:

brainly.com/question/14292577

#SPJ11

Consider the following class definitions. public class Artifact private String title; private int year public Artifact(string t, int y title = t; year = y; > public void printInfo() System.out.print(title" (" + year")); ) > public class Arbork extends Artifact . private String artist; public arbork(stringt, int y, Stringa) { super(t.); artist = a; > public void printinfo) /* missing implementation The following code segment appears in a method in another class Artwork starry - nox artwork("The Starry Night", 1989, Van Gogh"); starry.printinfo(); The code segment is intended to produce the following output The starry Night (1889) by van Gogh Which of the following can be used to replace le missing implementation in the printinfo method in the Arbuork done so that the code segment produces the itended cutput System.out.print(title . (year) by artist); super.printinfo(artist); c System.out.print(super.printinfo() by artist); Super(); System.out.print(" by artist); Super.print Info System.out.print by artist)

Previous question

Next quest

Answers

The Artifact class has two private instance variables, title and year, along with a constructor and a printInfo() method that prints the title and year of the artifact. The Arbork class extends Artifact and adds an artist instance variable along with a constructor that calls the super constructor and sets the artist variable.

However, the printinfo() method in Arbork is missing an implementation. In the code segment provided, an Artwork object is created with the title "The Starry Night", the year 1989, and the artist "Van Gogh". The printinfo() method is then called on this object to print the title, year, and artist. To produce the intended output of "The Starry Night (1889) by Van Gogh", we need to implement the printinfo() method in Arbork. We can do this by calling the printInfo() method of the super class Artifact using the super keyword and adding the artist variable to the print statement. Therefore, the correct option to replace the missing implementation in the printinfo() method in Arbork is: System.out.print(super.printInfo() + " by " + artist); This will call the printInfo() method of the super class to print the title and year and add the artist variable to the print statement.

Learn more about Artifact here-

https://brainly.com/question/7195661

#SPJ11

What are the primary advantages of pneumatic (air turbine) starters over comparable electric starters for turbine engines

Answers

There are several primary advantages of pneumatic (air turbine) starters over comparable electric starters for turbine engines.

Firstly, pneumatic starters are generally more reliable than electric starters, as they have fewer moving parts and are less susceptible to wear and tear. This makes them less likely to fail or require maintenance, which can be especially important in critical applications such as aircraft engines.

Secondly, pneumatic starters are often more compact and lightweight than electric starters, which can be beneficial in applications where space and weight are at a premium. This can help to reduce the overall weight and size of the engine, making it more efficient and easier to install.

Thirdly, pneumatic starters are generally more efficient than electric starters, as they are able to provide a higher starting torque with less power input. This means that they can start the engine more quickly and with less strain on the electrical system, which can be important in applications where power is limited or expensive.

Overall, pneumatic starters offer several key advantages over comparable electric starters for turbine engines, including greater reliability, compactness, and efficiency.


To know more about turbine visit:

https://brainly.com/question/928271

#SPJ11

Which type of expansion card enables communication on 802.11 networks? A. WLAN B. Riser card. C. WPAN D. WWAN.

Answers

The type of expansion card that enables communication on 802.11 networks .A WLAN expansion card is a type of expansion card that allows a computer or device to connect to a wireless network using the 802.11 wireless networking standard.

This type of expansion card typically contains an antenna and supports various wireless protocols, such as 802.11a, 802.11b, 802.11g, or 802.11n.WLAN expansion cards are commonly used in laptops and other portable devices that do not have built-in wireless connectivity. They can be installed in an available expansion slot, such as a PC Card slot or an ExpressCard slot, or connected externally through a USB port.WLAN expansion cards are widely used in homes, offices, and public spaces to provide wireless connectivity to devices such as laptops, smartphones, and tablets. They are also used in enterprise networks to provide wireless access to employees and guests.

Learn more about communication about

https://brainly.com/question/22558440

#SPJ11

the gear train at the right consists of a 40-tooth (input), 20-tooth, and 30-tooth (output) gear. If the input gear rotates 15 times, how many times will the output gear rotate

Answers

In a gear train, the ratio of the number of teeth on the input gear to the number of teeth on the output gear determines the gear ratio.

The gear ratio is a measure of how much the output gear rotates in relation to the input gear.In this gear train, the input gear has 40 teeth and the output gear has 30 teeth. The gear ratio can be calculated as:Gear Ratio = Number of Teeth on Input Gear / Number of Teeth on Output Gear

= 40 / 30

= 4 / 3This means that for every 4 rotations of the input gear, the output gear will rotate 3 timeSince the input gear rotates 15 times, the number of times the output gear will rotate can be calculated as:Output Gear Rotations = Input Gear Rotations * Gear Rati = 15 * (3 / 4= 11.25 timesTherefore, the output gear will rotate 11.25 times when the input gear rotates 15 times in this gear train.

To learn more about determines  click on the link below:

brainly.com/question/14455728

#SPJ11

Air is compressed in an isentropic compressor from 15 psia and 70o F to 200 psia. Determine the outlet temperature [ o F] and the work consumed by this compressor per unit mass of air{Btu/lbm]. Assume constant specific heats.

Answers

Since the process is isentropic, we know that the entropy remains constant, and we can use the isentropic process equations to determine the outlet temperature and work consumed.

First, we need to determine the specific heat ratio (gamma) for air. Assuming constant specific heats, gamma can be calculated as the ratio of the specific heat at constant pressure to the specific heat at constant volume. For air, gamma is approximately 1.4.Next, we can use the isentropic process equations to determine the outlet temperature and work consumed.T2 = T1 * (P2/P1)^((gamma-1)/gamma)where T1 is the inlet temperature (70°F + 459.67 = 529.67 R), P1 is the inlet pressure (15 psia), P2 is the outlet pressure (200 psia), and gamma is the specific heat ratio for air (1.4).Plugging in the values, we get:T2 = 529.67 * (200/15)^((1.4-1)/1.4) = 950.57 RTherefore, the outlet temperature is 950.57 - 459.67 = 490.9°F.To determine the work consumed per unit mass of air, we can use the following equation:W/m = C_p * (T2 - T1)where C_p is the specific heat at constant pressure for air, which can be assumed to be 1.005 Btu/lbm·°FPlugging in the values, we getW/m = 1.005 * (490.9 - 529.67) = -39.09 Btu/lbmNote that the negative sign indicates that work is being consumed by the compressor (i.e., the compressor is doing work on the air).Therefore, the outlet temperature is 490.9°F, and the work

To learn more about isentropic  click on the link below:

brainly.com/question/22937109

#SPJ11

A new mobile cooling system has been presented to you to be evaluated. It is stated that the engine to run the refrigeration system makes 1.4 hp when it is supplied heat at the rate of 100 BTU/min from a source at 1540 deg F. The engine rejects heat to a source at 200 deg F. It is stated that the cooling system has a cooling capacity of 1 ton while operating between a refrigerated region of 0 deg F and a reservoir at 200 deg F. How would you evaluated this system

Answers

Based on the information provided, we can evaluate this mobile cooling system by calculating its coefficient of performance (COP).

The COP (coefficient of performance) is a measure of how efficiently the cooling system operates and is calculated by dividing the cooling capacity by the power input to the system.

In this case, the cooling capacity is given as 1 ton, which is equivalent to 12,000 BTU/hr. The power input to the system is 1.4 hp, which is equivalent to 1,044 watts.
Using these values, we can calculate the COP as follows:


COP = Cooling capacity / Power input
COP = 12,000 BTU/hr / 1,044 watts
COP = 11.5

A COP of 11.5 is quite high, which suggests that this mobile cooling system is very efficient at removing heat from the refrigerated region. However, we should also consider the cost of running the engine and the refrigeration system, as well as the durability and reliability of the system over time.

To learn more about coefficient of performance:

https://brainly.in/question/16614938

#SPJ11

Other Questions
what makes art controversial? Campaigns that are based on environments or activities where the subject is not aware that she or he is the target of a marketing campaign is known as .HELPPPPPPPPPPPPPPPPP what violetn strike between 1891-93 began when the company attempted to use convicts to replace free labor in East tennessee mines The list/center that contains a file for each company from which goods and services are purchased is the the headquarters of USG agencies, intergovernmental organizations, and nongovernmental organizations work directly with their field representatives and embassies. This _____. Experiments evaluating the impact of subliminal self-help recordings for improving memory indicated that they Bhavik used management by objectives to set goals for his department and clearly communicated goals to all of his employees. However, very few of his employees actually achieved their goals. Why might have Bhavik's goal setting process failed In the long run, assume a firm both labor and capital to produce 25 units of output. The marginal product of the last unit of a labor being empolyed is 100; the marginal product of the last unit of capital being employed is 500. The wage rate of labor is $10. If the firm is minimizing the cost of producing 25. units of output, what must be the unit price of capital According to the Quantity Theory, what would happen to prices if the money supply was increasing at the rate of 4 percent per year and real GDP was growing at 6 percent? water with an alkalinity of 2.00 10-3 mol/l has a ph of 7.65. calculate [co2], [hco3-], [co32-], [h3o ] and [oh-]. An important contingency of power in social networks that refers to where you are located in the network is ______. In comparison to the percentage of students with most other disabilities, students with E/BD are more likely to be educated in Which of the following has made external integration more difficult to achieve? a. Identifying key trading partners b. Increased number of franchise operators c. Problems with internal integration efforts d. Lack of software applications to coordinate the effort Kingbird, Inc. reported net income of $368000 for the year. During the year, accounts receivable increased by $27000, accounts payable decreased by $11000 and depreciation expense of $57000 was recorded. Net cash provided by operating activities for the year is 1. Predict the output of the following code. void main() { int i; for(i=1;i Which statement best describes both the positive and negative effectslobbyists have on the democratic process?O A. Lobbyists give small groups a voice in U.S. politics but mayinfluence lawmakers to support policies that do not benefit thepublic in general.O B. Lobbyists make the role of money in politics more transparent butallow the majority to more easily deny rights to vulnerable minoritygroups.C. Lobbyists help voters learn more about candidates for office, butprevent third parties from successfully challenging the two-partysystem.D. Lobbyists help political leaders spread their messages to voters,but rely heavily on donations from corporations and super PACS. The skeleton of most chordates is composed of bone and cartilage and is located ______ the body, whereas the skeleton of many invertebrates is located ______ the body. Linda put 15% of her pay check in a Roth 401k plan administered by her employer. Linda earns $60000/year and is in the 28% tax bracket. What tax savings does she get from her contribution an eye-tracking study found that people are more likely to use ___ to spontaneously and quickly assess men's formidability than other body parts