Organizations make business deals with other organizations. When negotiating a specific deal, each organization is represented by one lawyer. The same organization can have deals with many other organizations and it might use different lawyers in each case.
Each lawyer has a first and last name, address (Street, City, State, Zip), specialization and fee.
Each organization has a name, address (Street, City, State, Zip) and budget.
Each deal has a name, description, begin date and end date and might involve numerous organizations.
So where I'm so far is,
Ok, now I am not sure where to go from here... Obviously there has to be a relationships the Lawyers, the Organizations and the Deals, but I don't know how to make those relationships given that there are multiple organizations and multiple lawyers involved, yet only one table ID for each.... I'm confused.. Please help.