Muddiest Point - 09/24-09/31

Muddiest Point - 09/24-09/31

When building and managing databases, is it possible, after joining multiple tables, for primary keys and foreign keys to switch roles, or assume new roles?