04 Dec Describe a business scenario where a ‘union’ relational set o
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.
- Be sure to respond to at least one of your classmates' posts.
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
