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 147 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

Dinolord

  • Member
  • Posts: 313
Reply 3 on: Yesterday
Excellent

« previous next »
 

Did you know?

Multiple experimental evidences have confirmed that at the molecular level, cancer is caused by lesions in cellular DNA.

Did you know?

The familiar sounds of your heart are made by the heart's valves as they open and close.

Did you know?

No drugs are available to relieve parathyroid disease. Parathyroid disease is caused by a parathyroid tumor, and it needs to be removed by surgery.

Did you know?

In Eastern Europe and Russia, interferon is administered intranasally in varied doses for the common cold and influenza. It is claimed that this treatment can lower the risk of infection by as much as 60–70%.

Did you know?

As the western states of America were settled, pioneers often had to drink rancid water from ponds and other sources. This often resulted in chronic diarrhea, causing many cases of dehydration and death that could have been avoided if clean water had been available.

Many Natural Resources Can Be Sustained Many Natural Resources Can Be Sustained
Archaea, Eukarya, Bacteria Differences Chart Archaea, Eukarya, Bacteria Differences Chart
Differences in the antigen-processing pathways between MHC molecules class I and class II. Differences in the antigen-processing pathways between MHC molecules class I and class II.
Differences between an antigen (Ag, in red) and a superantigen (SAg, in purple) and their ... Differences between an antigen (Ag, in red) and a superantigen (SAg, in purple) and their ...
Equipment and supplies needed for manual exfoliation using natural substances. Equipment and supplies needed for manual exfoliation using natural substances.
Lipid composition in the outer leaflet (green) and inner leaflet (gold) of the plasma membrane Lipid composition in the outer leaflet (green) and inner leaflet (gold) of the plasma membrane
Video: Nervous pathway to the Neuromuscular (NMJ)

For a complete list of videos, visit our video library