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

6ana001

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

« previous next »
 

Did you know?

Fatal fungal infections may be able to resist newer antifungal drugs. Globally, fungal infections are often fatal due to the lack of access to multiple antifungals, which may be required to be utilized in combination. Single antifungals may not be enough to stop a fungal infection from causing the death of a patient.

Did you know?

Asthma cases in Americans are about 75% higher today than they were in 1980.

Did you know?

Before a vaccine is licensed in the USA, the Food and Drug Administration (FDA) reviews it for safety and effectiveness. The CDC then reviews all studies again, as well as the American Academy of Pediatrics and the American Academy of Family Physicians. Every lot of vaccine is tested before administration to the public, and the FDA regularly inspects vaccine manufacturers' facilities.

Did you know?

Today, nearly 8 out of 10 pregnant women living with HIV (about 1.1 million), receive antiretrovirals.

Did you know?

In 2012, nearly 24 milliion Americans, aged 12 and older, had abused an illicit drug, according to the National Institute on Drug Abuse (NIDA).

How Oil and Natural Gas Form How Oil and Natural Gas Form
Activated Natural Killer Cell (NK Cell) Activated Natural Killer Cell (NK Cell)
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.
Natural Resources and Industry Natural Resources and Industry
Regional differences affect soil fertility Regional differences affect soil fertility
Third Differences Third Differences
Video: HIV replication/ Replication cycle of HIV

For a complete list of videos, visit our video library