DQ 150 words

PLAGIARISM SCAN REPORT

Words 188 Date December 17, 2021

Characters 1284 Excluded URL

20% Plagiarism

80% Unique

2 Plagiarized Sentences

8 Unique Sentences

Content Checked For Plagiarism

3 SQL uses joins to combine and compare the contents of different tables. The join allows a user to connect related information in various ways. There are two types of joins; inner and outer joins. The inner join matches related data from tables, whereas the outer join matches both related and unrelated data from tables (Chamberlin, 2009). This means the inner join keeps only information that relates to each other from both tables. In contrast, the outer join keeps information unrelated to the other table in the resulting table. The main difference is that inner joins lead to the intersection of two tables, while outer joins lead to the union of two tables (Chamberlin, 2009). For example, suppose there are two tables one contains employee salary while the other contains employee details. Also, there is a standard column with employee ID to join the two tables. The inner join combines records from the two tables with matching keys, while the outer join combines related data from both tables and the remaining rows from one table. Refere GeeksforgGeeks. (2020). Difference Between Two-Tier and Three-Tier database architecture. Retrieved from: https://www.geeksforgeeks.org/difference-between-two-tier-and-three-tier-database-architecture/

Sources Similarity

Edit SQL statements to sharpen query results - Microsoft Support

Behind the scenes, Access queries use Standard Query Language (SQL) and in some cases, you can edit the SQL to sharpen the query results.

https://support.microsoft.com/en-us/office/edit-sql-statements-to-sharpen-query-results-5e10932d-20fc-4a66- bf40-b3f8b207e4a8

25%

SQL Join Types – Inner Join VS Outer Join Example

Aug 23, 2021 — An Outer Join, on the other hand, will also keep information that is not related to the other table in the resulting table.

https://www.freecodecamp.org/news/sql-join-types-inner-join-vs-outer-join-example/

17%