Database Systems Final - Joins, Subqueries, SQL Logic

0.0(0)
studied byStudied by 0 people
0.0(0)
full-widthCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/7

encourage image

There's no tags or description

Looks like no tags are added yet.

Study Analytics
Name
Mastery
Learn
Test
Matching
Spaced

No study sessions yet.

8 Terms

1
New cards

How do tables connect in joins

Using primary key - foreign key relationships

2
New cards

What is a Cartesian prduct

Joining table without a condition, producing every possible row combination

3
New cards

If table A has 10 rows and table B has 5 rows, how many in AxB

50

4
New cards

What does an INNER JOIN return

Only rows with matching values in both tables

5
New cards

What is a subquery

A query inside another query

6
New cards

When is a subquery executed

Before the outer query (for non-correlated)

7
New cards

What is a correlated subquery

A subquery that references the outer query and executes once per row

8
New cards

What is query analysis

Understanding what a SQL query will output and execute once per row