All categories

3 years ago

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

Engineering

1 answer:

Anarel [89]3 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

When you approach an uncontrolled intersection, you should treat it as though which sign is present?

Vika [28.1K]

Answer: A yield sign

Explanation:

6 0

2 years ago

If the bolt head and the supporting bracket are made of the same material having a failure shear stress of 'Tra;i = 120 MPa, det

Nina [5.8K]

Answer:

P=361.91 KN

Explanation:

given data:

brackets and head of the screw are made of material with T_fail=120 Mpa

safety factor is F.S=2.5

maximum value of force P=??

solution:

to find the shear stress

T_allow=T_fail/F.S

=120 Mpa/2.5

=48 Mpa

we know that,

V=P

Area for shear head:

A(head)=π×d×t

=π×0.04×0.075

=0.003×πm^2

Area for plate:

A(plate)=π×d×t

=π×0.08×0.03

=0.0024×πm^2

now we have to find shear stress for both head and plate

For head:

T_allow=V/A(head)

48 Mpa=P/0.003×π ..(V=P)

P =48 Mpa×0.003×π

=452.16 KN

For plate:

T_allow=V/A(plate)

48 Mpa=P/0.0024×π ..(V=P)

P =48 Mpa×0.0024×π

=361.91 KN

the boundary load is obtained as the minimum value of force P for all three cases. so the solution is

P=361.91 KN

note:

find the attached pic

7 0

4 years ago

A tensile test uses a test specimen that has a gage length of 50 mm and an area = 206 mm2. During the test, the specimen yields

vampirchik [111]

Answer:

The percent elongation in the length of the specimen is 42%

Explanation:

Given that:

The gage length of the original test specimen $L_o$ = 50 mm

The final gage length $L_f$ = 71 mm

The area = 206 mm²

maximum load = 162,699 N

To determine the percent elongation in %, we use the formula:

$\%EL = \dfrac{L_f-L_o}{L_o}\times 100$

$\%EL = \dfrac{71 \ mm-50 \ mm}{50 \ mm}\times 100$

$\%EL = \dfrac{21 mm}{50 \ mm}\times 100$

$\%EL = 0.42 \times 100$

$\mathbf{\%EL = 42 \%}$

The percent elongation in the length of the specimen is 42%

4 0

4 years ago

When selecting the appropriate gear for intended direction of travel, automatic transmission equipped vehicles should be placed

True [87]

Answer:

Automatic transmissions should be in Drive and Manual transmissions should be in first gear.

6 0

3 years ago

Thermal energy is...

Yuki888 [10]

B because thermal has to do with temperature and it’s the amount of kinetic and potential energy in and object

4 0

3 years ago

Read 2 more answers