All categories

2 years ago

What is Join..?? Explain different types of joins.

Engineering

1 answer:

Anarel [89]2 years ago

5 0

Answer:

mainly used to combine two tables based on a specified common field between them. If we talk in terms of Relational algebra, it is the cartesian product of two tables followed by the selection operation. Thus, we can execute the product and selection process on two tables using a single join statement. We can use either 'on' or 'using' clause in MySQL to apply predicates to the join queries.

A Join can be broadly divided into two types:

Inner Join

Outer Join

Inner Join is a join that can be used to return all the values that have matching values in both the tables. Inner Join can be depicted using the below diagram.

The inner join can be further divided into the following types:

Equi Join

Natural Join

Now let us learn about these inner joins one-by-one.

You might be interested in

Chemical materials that are transported are called..

svetlana [45]

Answer:

Transport Molecules

Explanation:

I believe the answer is transport molecules because development of a cell membrane that could allow some materials to pass.

3 0

2 years ago

What does this work for

Anastaziya [24]

Answer:

it allows your dash board to light up you MPH RPM and all the other numbers on the spadomter

Explanat

8 0

2 years ago

The diameter of an extruder barrel = 85 mm and its length = 2.00 m. The screw rotates at 55 rev/min, its channel depth = 8.0 mm,

babunello [35]

Answer:

Qx = 9.10 $9.10^5 \times 10^{-6}$ m³/s

Explanation:

given data

diameter = 85 mm

length = 2 m

depth = 9mm

N = 60 rev/min

pressure p = 11 × $10^6$ Pa

viscosity n = 100 Pas

angle = 18°

so Qd will be

Qd = 0.5 × π² ×D²×dc × sinA × cosA ..............1

put here value and we get

Qd = 0.5 × π² × ( 85 $\times 10^{-3}$ )²× 9 $\times 10^{-3}$ × sin18 × cos18

Qd = 94.305 × $10^{-6}$ m³/s

and

Qb = p × π × D × dc³ × sin²A ÷ 12 × n × L ............2

Qb = 11 × $10^{6}$ × π × 85 $\times 10^{-3}$ × ( 9 $\times 10^{-3}$ )³ × sin²18 ÷ 12 × 100 × 2

Qb = 85.2 × $10^{-6}$ m³/s

so here

volume flow rate Qx = Qd - Qb ..............3

Qx = 94.305 × $10^{-6}$ - 85.2 × $10^{-6}$

Qx = 9.10 $9.10^5 \times 10^{-6}$ m³/s

8 0

2 years ago

Determine the hydraulic radius for the following rectangular open channel width =23m water depth =3m

Romashka-Z-Leto [24]

Answer:

2.379m

Explanation:

The width = 23m

The depth = 3m

The radius is denoted as R

The wetted area is = A

The perimeter perimeter = P

Hydraulic radius

R = A/P

The area of a rectangular channel

= Width multiplied by Depth

A = 23x3

A = 69m²

Perimeter = (2x3)+23

P = 6+23

P= 29

Hydraulic radius R = 69/29

= 2.379m

This answers the question

Thank you!

8 0

2 years ago

What is the force in kN of work done is 1.2 ms moves through 120m

Semmy [17]

Answer:

$\frac{1.2}{120}$

0.01

5 0

1 year ago