Week 5 Discussion 1

 “Relational Set Operators” Please respond to the following:

• A  relational Database Model allows database users to analyze data  thoroughly. To accomplish this, advanced commands such as UNION and  INTERSECT may be used.  Describe a business scenario where a UNION  relational set operator may be used to merge two similar data sets.  Within the context of your business scenario, analyze the analysis and  data consistency advantages of using a UNION operator rather than simply  merging two data sets into one result table.
• Suppose you are  tasked with finding common data elements amongst various data sets.  Specify how an INTERSECT operator may assist you in accomplishing this  task. Construct a query that can perform the same function as the  INTERSECT operator without using the “INTERSECT” syntax within the  query. Note: The Strayer Oracle Server may be used to test and compile  the SQL Queries developed.