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 160 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
Thanks for the timely response, appreciate it

scikid

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

« previous next »
 

Did you know?

It is widely believed that giving a daily oral dose of aspirin to heart attack patients improves their chances of survival because the aspirin blocks the formation of new blood clots.

Did you know?

If you use artificial sweeteners, such as cyclamates, your eyes may be more sensitive to light. Other factors that will make your eyes more sensitive to light include use of antibiotics, oral contraceptives, hypertension medications, diuretics, and antidiabetic medications.

Did you know?

Although not all of the following muscle groups are commonly used, intramuscular injections may be given into the abdominals, biceps, calves, deltoids, gluteals, laterals, pectorals, quadriceps, trapezoids, and triceps.

Did you know?

On average, the stomach produces 2 L of hydrochloric acid per day.

Did you know?

The shortest mature adult human of whom there is independent evidence was Gul Mohammed in India. In 1990, he was measured in New Delhi and stood 22.5 inches tall.

A medical assistant listening to the patient and physician discuss the patient's care. A medical assistant listening to the patient and physician discuss the patient's care.
Low (or No) Natural Growth Low (or No) Natural Growth
Differences in the mitochondrial code and coding for the “21st and 22nd” amino acids Differences in the mitochondrial code and coding for the “21st and 22nd” amino acids
La Niña: The impact of natural cycles La Niña: The impact of natural cycles
Natural gas is a cleaner fuel than coal Natural gas is a cleaner fuel than coal
What is the differences between RNA seq and RAD seq? What is the differences between RNA seq and RAD seq?
Video: Muscular System Animation

For a complete list of videos, visit our video library