Home Forums SQL Server 2005 SQL Server Newbies How to design 1:n relationships in Sql Server Management Studio? RE: How to design 1:n relationships in Sql Server Management Studio?

  • I found an article which said the following:

    Manager ---> Player

    You will link the manager table to the player table because the player table will only need 1 manager for each player row. Whereas the manager table would need 11 players per manager row. It kind of ties in with what you say about only being able to have 1 manager associated to 1 player.

    This will create an FK in the Player table.

    Is this the right way of thinking about this? I will post the link for reference.