Suppose a music library model includes entity sets ‘album’ and ‘artist’, and rel
ID: 3694317 • Letter: S
Question
Suppose a music library model includes entity sets ‘album’ and ‘artist’, and relationship set ‘album-artist’. In this model, would you expect the participation of album in album-artist to be ‘total’? yes/no ___________ Explain your answer: ___________________________
_______________________________________________________________________
Why might it be a bad idea to model the name of an instructor’s department as an attribute of the instructor? Would it be because: a) we might in the future want to allow instructors to belong to multiple departments, b) it is important to model the smallest possible number of attributes, or c) department names can change? (select all that apply) _________
Explanation / Answer
Suppose a music library model includes entity sets ‘album’ and ‘artist’, and relationship set ‘album-artist’. In this model, would you expect the participation of album in album-artist to be ‘total’? yes/no ___________ Explain your answer: ___________________________
Answer) yes the participation of the album in album-artist relation must be total because, if there is an album there must be an artist. without artists there cannot be an album. one album may/my not have multiple artists. but if we map one-to-one relationship. every album will have atleast one artist.Therefore the album participation is full.
Why might it be a bad idea to model the name of an instructor’s department as an attribute of the instructor? Would it be because: a) we might in the future want to allow instructors to belong to multiple departments, b) it is important to model the smallest possible number of attributes, or c) department names can change? (select all that apply) _________
Answer) a) we might want to allow instructors to belong to multiple departments.
c)department names can change.
for further queries kindly get back
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.