title: One table with two one to one relations SQL
body: <p>In my database, I have tables for accounts,managers and customers. Both customers and managers has accounts. Two one to one relationships exist here between Customer-Account and Manager-Account. I have the AccountID as a FK in both customer and manager tables. Problem is that now nothing is preventing an account from being tied to a manager and a customer at the same time. How should i design such relation or how am i supposed to implement this thing.</p>