Design an E-R model for the following enterprise. Various organizations make business deals with various other organizations. (For simplicity, let us assume that there are only two parties to each deal.) When negotiating (and signing) a deal, each organization is represented by a lawyer. The same organization can have deals with many other organizations, and it might use di?erent lawyers in each case. Lawyers and organizations have various attributes, like address and name. They also have their own unique attributes, such as specialization and fee, in the case of a lawyer, and budget, in the case of an organization. Show how information loss can occur if a relationship of degree higher than two is split into a binary relationship. Discuss the assumption under which such a split does not le

Question

What will be an ideal response?

Answer 1

Two types of entities: Organization and Lawyer. Deal is a quadruple relationship with roles Party1, Party2, Lawyer1 and Lawyer2.
We can split this into three binary relationships: Two representing a contract between an Organization entity and a Lawyer entity (one for each party in the deal) and one that represents negotiations between the two lawyers. The information loss here is obvious, nothing connects the three binary relationships to indicate that they are part of the same deal.
One assumption that ensures that information loss will not occur is that no organization uses the same lawyer twice.