Question 230
A data professional makes this decision: Create a foreign key from orders to the referenced customer primary key. Which outcome is the most direct expected result?
Explanation
Correct Answer
This is the expected outcome for Foreign key: The relationship can enforce referential integrity between child and parent rows.
Incorrect Answers
This result would follow the different Junction table decision (Create an enrollment junction table containing student and course foreign keys.) rather than the specified design.
This result would follow the different ORDER BY decision (Use ORDER BY created_at DESC in the SELECT query.) rather than the specified design.
This result would follow the different View abstraction decision (Create a database view for the approved SELECT projection.) rather than the specified design.