Relational Set Operators


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.

· Analyze the analysis and data consistency advantages of using a “union” operator rather than simply merging two data sets into one result table, within the context of your business scenario.

200 words