Resolve the M:N relationship between the sale and available tune that is shown in Figure 6-14. What kinds of information could you capture about this relationship? What would the new ERD look like? Would the intersection entity be considered dependent or independent? Can you think of other kinds of M:N relationships that exist in the real world? How would you resolve these M:N relationships if you were to include them on anERD?

Transcribed Image Text:

makes s targeted by argets TARGETED PROMOTION s made by . PRO code SAL number SAL date CuS username cuS number TUN ID PRO price PRO temm one or more ocourrences ot TUN ID adds cre ates cuS e-mail CUS username s added by s created by CUSTOMER FAVORITE CUSTOMER INTEREST cus number TUN ID FAV_dateadded TUN ID INT datecreated AVAILABLE TUNE s indluded in indudes s lsted in promotes is promoted by ists s involved in TUN mp3short TUN mp3full Relationships for lune Source ERD