Name: QUIZ 6 - ICS 321 Fall 2018 Chapter 4 covers Codd\'s original operators. Th

Question

Name: QUIZ 6 - ICS 321 Fall 2018 Chapter 4 covers Codd's original operators. The second part discussed Union, Intersection and Difference. Imagine relation E: and Z: ADDRESS P O Box 12022Honolulu 96828 ZIP ENO NAME H26 Scott Saiki H32Linda lchiyama PO Box 1707Aiea H28 John Mizuno PO Box 215 Honolulu 96810 CC1 |Kymberly Pine PO Box 2908Ewa Beach 96706 E01 David Ige S20Mike GabbardPO Box 75457Kapolei CITY BRANCH CITY ZIP Honolulu 96828 Honolulu 96810 96701 96701 96707 PO Box 2999Aiea What is the result of the following Tutorial D expression (E WHERE BRANCH-'H'CITYMINUS (E WHERE BRANCH E') 1. CITY ) 2. What is the result of the following Tutorial D expressiorn ( E WHERE BRANCH='H' ) { CITY } UNION ( E WHERE BRANCH = 'E' ) { CITY } What is the result of the following Tutorial D expression ( E WHERE BRANCH='E') { CITY } INTERSECT ( E WHERE BRANCH = 'H') { CITY } 3. 4. What is the result of the following Tutorial D expression (E WHERE BRANCH-'E')CITY MINUS (E WHERE BRANCH -'H')CITY ) 5. What is the result of the following Tutorial D expression E CITY, ZIP) MINUS Z 6. What is the result of the following Tutorial D expression Z INTERSECT ECITY, ZIP )

Explanation / Answer

1.

{Honululu,Aiea} - { Aiea}

{Honolulu}

2.

{Honululu,Aiea} -Union { Aiea}

{Honululu,Aiea}

3.

{Aiea} INTERSECT {Honululu,Aiea}

{Aiea}

4.

{Aiea} - {Honululu,Aiea}

{} - empty set

5.

{{Aiea,96701}, {Eiva Beach , 96706}, {Kapolei,76707}}

6.

{{Honolulu,96828}, {Honolulu,96810}}

Do ask if any doubt. Please upvote.

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

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