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.