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

mammy1697

  • Member
  • Posts: 341
Reply 3 on: Yesterday
Wow, this really help

« previous next »
 

Did you know?

Malaria mortality rates are falling. Increased malaria prevention and control measures have greatly improved these rates. Since 2000, malaria mortality rates have fallen globally by 60% among all age groups, and by 65% among children under age 5.

Did you know?

It is believed that the Incas used anesthesia. Evidence supports the theory that shamans chewed cocoa leaves and drilled holes into the heads of patients (letting evil spirits escape), spitting into the wounds they made. The mixture of cocaine, saliva, and resin numbed the site enough to allow hours of drilling.

Did you know?

The FDA recognizes 118 routes of administration.

Did you know?

Fungal nail infections account for up to 30% of all skin infections. They affect 5% of the general population—mostly people over the age of 70.

Did you know?

ACTH levels are normally highest in the early morning (between 6 and 8 A.M.) and lowest in the evening (between 6 and 11 P.M.). Therefore, a doctor who suspects abnormal levels looks for low ACTH in the morning and high ACTH in the evening.

Alexander Fleming photographed in his lab where he observed the natural competition between a fungus Alexander Fleming photographed in his lab where he observed the natural competition between a fungus
Subtle Differences in Written Words Subtle Differences in Written Words
Natural defenses against stomach acid. Natural defenses against stomach acid.
Beer is made from the fermentation of yeast and the natural sugars from grains Beer is made from the fermentation of yeast and the natural sugars from grains
For the circuit in Figure 1, assume ideal diodes. The peak inverse voltage is approximately For the circuit in Figure 1, assume ideal diodes. The peak inverse voltage is approximately
Remote satellite monitoring of gross primary productivity across the United States. The differences Remote satellite monitoring of gross primary productivity across the United States. The differences
Video: Factors that increase metabolic rate and heat production

For a complete list of videos, visit our video library