Suppose that a model of a music library does not model ‘artist’ as an entity set

Question

Suppose that a model of a music library does not model ‘artist’ as an entity set, but instead models it as an attribute of a track. This could lead to what the authors of our text call ‘incompleteness’. Why would the authors call this model incomplete? Is it: a) not all artist information could be contained as an attribute of a track, b) it would not be possible to model an artist before that artist released any tracks, or c) the artist could not have a key. (give the single letter you think is best) _________ Can one entity belong to two entity sets? (yes/no) ________ Is a table in a database more like a) an ER relationship or b) an ER relationship set? _______ When would it be wise to specify the role played by an entity in a relationship? a) when the same entity set participates more than once in the relationship set, b) when the relationship is ternary, or c) when the entity represents an abstract rather than physical thing ______ In an ER model, would it be possible for the same two entity sets to participate in two different relationship sets? (yes/no) _________

Explanation / Answer

Answer :-

Suppose that a model of a music library does not model ‘artist’ as an entity set, but instead models it as an attribute of a track. This could lead to what the authors of our text call ‘incompleteness’. Why would the authors call this model incomplete? Is it: a) not all artist information could be contained as an attribute of a track, b) it would not be possible to model an artist before that artist released any tracks, or c) the artist could not have a key. (give the single letter you think is best) ___a______ Can one entity belong to two entity sets? (yes/no) __yes______ Is a table in a database more like a) an ER relationship or b) an ER relationship set? __b_____ When would it be wise to specify the role played by an entity in a relationship? a) when the same entity set participates more than once in the relationship set, b) when the relationship is ternary, or c) when the entity represents an abstract rather than physical thing __a____ In an ER model, would it be possible for the same two entity sets to participate in two different relationship sets? (yes/no) ____yes_____

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.