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
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.