E/R diagram for sports league database
The unique identifier for Manager would be the personnel id.  That identifier would migrate to Team as a column and thus refer back to Manager.  This will ensure each Team can be managed by one and only one Manager.  This constraint would be a Foreign Key constraint.  The constraint on Manager, which specifies the personnel id as the key, would be called a Primary Key constraint.