Describe a business scenario where a ‘union’ relational set o

Jeffrey Rapadas Alejandro

RE: Week 9 Discussion

Top of Form

Hello Everyone,

                Let's say your objective is to identify similar data items in different data sets. Indicate how using an INTERSECT operator can help you complete this assignment. Create a query that can do the same task as the INTERSECT operator without referencing the "INTERSECT" syntax. A business acquiring another business is a perfect illustration of when to utilize the UNION relational set operator. They employ the UNION operator to combine their customer lists. When two divisions inside a corporation need to be united for whatever reason, I believe this would be an excellent application for it as well. The option to merge data if necessary, would be a good argument for the UNION operator because the majority of department managers prefer to keep their data separate. When two customer list tables are combined, we already know that a UNION operator will combine the data and eliminate any duplicate records. Since it is a SQL query, the UNION operator can also fail if the data types do not match. You could have proprietary data types or specific data formats that need to be retained inside each database if you just try to merge the data from two tables into one. The database management system (DBMS) may be configured differently for each table, thus keeping the tables separate may be the best course of action until the DBMS can be corrected.

                Let's say your objective is to identify similar data items in different data sets. Indicate how using an INTERSECT operator can help you complete this assignment. Create a query that can do the same task as the INTERSECT operator without referencing the "INTERSECT" syntax. Note: The created SQL Queries may be tested and assembled using the Strayer Oracle Server. By identifying similar items in both questions, the INTERSECT query may be used to locate duplication between two queries. Only the entries that overlap in both searches will be returned when using the INTERSECT query, which may be compared to a Venn Diagram. You can use a INTERSECT syntax to construct an INTERSECT query without utilizing the INTERSECT operator. Here is INTERSECT inquiry.

SELECT CUS_LNAME, CUS_FNAME, CUS_INITIAL, CUS_AREACODE, CUS_PHONE

FROM CUSTOMER

INTERSECT

SELECT CUS_LNAME, CUS_FNAME, CUS_INITIAL, CUS_AREACODE, CUS_PHONE

FROM CUSTOMER_2;

Using the INTERSECT operator, this will return all of the data from both CUSTOMER and CUSTOMER 2. I'm going to keep it easy and only search for Last Name to do the same task with the join.

SELECT CUSTOMER.CUS_LNAME

FROM CUSTOMER

JOIN CUSTOMER_2 ON CUSTOMER.CUS_LNAME = CUSTOMER_2.CUS_LNAME;

Undoubtedly, you would want to examine each field that your SQL query required, and you might if necessary, use a WHERE clause.

Student,

Jeffrey Rapadas

Bottom of Form

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.