This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: Discuss the differences between an equi-join, natural join and outer join. What will be an ideal ... (Read 158 times)

Evvie72

  • Hero Member
  • *****
  • Posts: 519
on: Jul 7, 2018
Discuss the differences between an equi-join, natural join and outer join.
 
  What will be an ideal response?

Question 2

Restrictions on removable media should be enforced by relying on user behavior, rather than technological restrictions.
 
  Indicate whether the statement is true or false.


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

spencer.martell

  • Sr. Member
  • ****
  • Posts: 342
Reply #1 on: Jul 7, 2018
Answer to Question 1

Both a natural join and an equi-join create a join based upon equality between some common columns. While the equi-join keeps the redundant columns that are used for the match, the natural join removes duplicates. There are situations where one table may contain information that is not in the other table. However, it is necessary to display both matching data as well as records which do not have a match in the second table. This situation is where we would use an outer join.

Answer to Question 2

Answer: FALSE


Evvie72

  • Member
  • Posts: 519
Reply 2 on: Jul 7, 2018
YES! Correct, THANKS for helping me on my review

kusterl

  • Member
  • Posts: 315
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

There are more nerve cells in one human brain than there are stars in the Milky Way.

Did you know?

Adolescents often feel clumsy during puberty because during this time of development, their hands and feet grow faster than their arms and legs do. The body is therefore out of proportion. One out of five adolescents actually experiences growing pains during this period.

Did you know?

If all the neurons in the human body were lined up, they would stretch more than 600 miles.

Did you know?

The first successful kidney transplant was performed in 1954 and occurred in Boston. A kidney from an identical twin was transplanted into his dying brother's body and was not rejected because it did not appear foreign to his body.

Did you know?

The training of an anesthesiologist typically requires four years of college, 4 years of medical school, 1 year of internship, and 3 years of residency.

The Grants and natural selection of beak size among the medium ground finch. The Grants and natural selection of beak size among the medium ground finch.
The Tsavo Man-Eaters on display in the Field Museum of Natural History in Chicago, Illinois. The Tsavo Man-Eaters on display in the Field Museum of Natural History in Chicago, Illinois.
The path of sound waves through the outer, middle, and inner ear. The path of sound waves through the outer, middle, and inner ear.
Natural Hazards Natural Hazards
Why did these young volunteers of the First Virginia Militia join the Confederate army in 1861? “It Why did these young volunteers of the First Virginia Militia join the Confederate army in 1861? “It
Video: Electrical Conduction System of the Heart

For a complete list of videos, visit our video library