. Consider the following two views below. One database view contains records of

Question

. Consider the following two views below. One database view contains records of Non Playable Characters in a role playing game. The second view contains records for playable characters for the same game. Remember views are like tables and you can treat them like tables when reading from them. If we wanted to list all characters from both views into one new view which you will find an example in the All Characters view below, what SET operation could we perform to achieve the desired result?

Explanation / Answer

We define union as follows: if we have two sets A,B AUB ={x | x belongs to A or x belongs to B}.

So, you will need to perform the set operation called UNION.So,

SetOfAllCharacters=(SetOfRolePlayCharacters) U(SetOfPlayableCharacters).

Hope that helps :).

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

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