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

LEFT outer join fetches a complete set of records from R(A,B), with the matching records in S(B,C,D). The result is NULL in the right side when no matching will take place.

Output of left outer join-

Output of right outer join-Right Outer Join- fetches a complete set of records from S(B,C,D), with the matching records in R(A,B). The result is NULL in the left side when no matching will take place.

Full Outer Join-  returns all records when there is a match in either left table or right table table .

Output of full outer join-

1. number of rows in-

left outer join: 3

right outer join: 3

full outer join: 4

2. Number of nulls in-

left outer join: 2

right outer join: 1

full outer join: 3

All a,b,c,d parts are false.

A B C D 1 2 null null 3 4 5 1 5 6 7 2

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

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