FROMR GROUP BYb QUESTION 13 Suppose relations R(A.B) and S(B,C.D) are as follows

Question

FROMR GROUP BYb QUESTION 13 Suppose relations R(A.B) and S(B,C.D) are as follows: Compute the full outer join on B, the left outer join on B, and the right outer join on B. In each case, R is the left operand and S is the right operand. Then answer the following questions for each 1. How are there in the result? 2. How manyNULL's appear in the result? many rows Finally, find the correct statement in the list below. a. The full outer join has 4 NULLS Ob. The right outer join has 2 row OCThe right outerjoin has no NULLs. O d. The left outer join has 4NULL's. QUESTION 14 Map the following ER diagram to relations by writing SQL statements to capture as many of the constraints as possible. If you cannot capture some constraints, explain why itle description

Explanation / Answer

Question 13:

Full outer join

Left Outer join

Right Outer join

1. ROWS

Full outer join - 4

Left outer join - 3

Right outer join - 3

2. NULLS

Full outer join - 5

Left outer join - 3

Right outer join - 2

Correct Statement:

There is no correct statement. All the statements are false.

Do ask if any doubt. Please upvote.

A R.B S.B C D 1 2 NULL NULL NULL 3 4 4 5 1 5 6 6 7 2 NULL NULL 8 9 3

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.