What is a Relationship?

A connection, association, or rule among entities:

"Customer places Sales Order"
"Item occurs on Sales Order"

In a conceptual model, it is sufficient to state or draw the relationship.

A logical model defines specific means of joining two entities via implied or expressed foreign keys.

Relationships can be classified into a few relationship types.