Lesson 7

Question 1

Table Relationships

Answer 1

Linked or related through the FK and the PK.

Question 2

Join

Answer 2

Clause used to combine rows from two or more tables, based on a related column between the tables.

Question 3

Inner Join

Answer 3

Keyword that selects rows that have matching values in both tables.

Question 4

One-to-one Relationship

Answer 4

Row and table 1 can relate to one row in table 2.

Question 5

One-to-many Relationship

Answer 5

Row in table 1 can relate to many rows and table 2.