Primary and foreign keys relate information between tables making it possible to look up information about all orders made by a specific customer for a specific product.

Question

Quizplus · Accepted Answer

Primary and foreign keys are used in relational databases to establish a connection between tables, allowing for the retrieval of related information across them, such as finding all orders made by a specific customer for a specific product.

Primary and Foreign Keys Relate Information Between Tables Making It