Relationship Sets (Cont.) An attribute can also be associated with a relationship set. ■ For instance,the advisorrelationship set between entity sets instructor and student may have the attribute date which tracks when the student started being associated with the advisor 76766 Crick 98988 Tanaka 45565 Katz 3May2008 12345 Shankar 10June2007 10101 Srinivasan 00128 12June2006 Zhang 98345 Kim 6 June 2009 76543 Brown 76543 Singh 30June2007 76653Aoi 31May2007 22222 Einstein 23121 Chavez 4May2006 instructor 44553 Peltier student Database System Concepts-7th Edition 6.16 @Silberschatz,Korth and SudarshanDatabase System Concepts - 7 6.16 ©Silberschatz, Korth and Sudarshan th Edition Relationship Sets (Cont.) ▪ An attribute can also be associated with a relationship set. ▪ For instance, the advisor relationship set between entity sets instructor and student may have the attribute date which tracks when the student started being associated with the advisor instructor student 76766 Crick Katz Srinivasan Kim Singh Einstein 45565 10101 98345 76543 22222 98988 12345 00128 76543 44553 Tanaka Shankar Zhang Brown Aoi Chavez Peltier 3 May 2008 10 June 2007 12 June 2006 6 June 2009 30 June 2007 31 May 2007 4 May 2006 76653 23121