Now suppose n2 that is r is a binary relationship also for


1. Exercise 4.3.2 We may think of relationships in the E/R model as having keys, just as entity sets do. Let R be a relationship among the entity sets E1, E2, ...,En. Then a key for R is a set K of attributes chosen from the attributes of E1, E2,..., En such that if (e1,e2,...,en) and (f1,f2,...,fn) are two different tuples in the relationship set for R, then it is not possible that these tuples agree in all the attributes of K. Now, suppose n=2; that is, R is a binary relationship. Also, for each I, let Ki be a set of attributes that is a key for entity set Ei. In terms of E1 and E2, give a smallest possible key for R under the assumption that:

a) R is many-many

b) R is many-one from E1 to E2.

c) R is many-one from E2 to E1.

d) R is one-one.

Solution Preview :

Prepared by a verified Expert
Basic Computer Science: Now suppose n2 that is r is a binary relationship also for
Reference No:- TGS01591278

Now Priced at $10 (50% Discount)

Recommended (96%)

Rated (4.8/5)