《Database System Concepts Course Introduction》ch06.pptVIP

Design Issues Use of entity sets vs. relationship setsPossible guideline is to designate指明 a relationship set to describe an action that occurs between entities May cause replication Binary versus n-ary relationship setsAlthough it is possible to replace any nonbinary (n-ary, for n 2) relationship set by a number of distinct binary relationship sets, a n-ary relationship set shows more clearly that several entities participate in a single relationship. Placement of relationship attributes For 1-1, reposition to either For 1-m,or m-1, reposition to m side Binary Vs. Non-Binary Relationships