Relationship Keys Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Transform and Load the Data

What you'll be asked

  1. What is the primary purpose of a primary key in a database table?
  2. When creating a relationship between two tables, what is the role of a foreign key?
  3. Which of the following describes a 'one-to-many' relationship?
  4. Why would you use a junction table in a database schema?
  5. During data transformation, you notice a foreign key in the 'Orders' table that refers to a non-existent 'Customer_ID' in the 'Customers' table. What does this indicate?

Answers and explanations come after you submit.