Database Assignment: E-R (IE) Diagram
For the above diagram
1. What are the entities?
2. What are the identifiers?
3. What are the non-identifying attributes?
4. What is the maximum cardinality of the relationship?
5. What is the minimum cardinality of the relationship?
6. Which entity is strong and which entity is weak?
For the above diagram
7. What are the supertype and subtype entities?
8. What is the maximum cardinality of the relationship between EMAIL_MESSAGE and SENDER?
9. What is the minimum cardinality of the relationship between EMAIL_MESSAGE and SENDER?
10. Is SUBJECT a weak or strong entity?
For the above diagram:
11. Give an example of a strong entity.
12. Give an example of a weak entity.
13. Give an example of an ID dependent entity.
14. What is the maximum cardinality of the relationship between COMPANY and STOCK QUOTE?
15. What is the minimum cardinality of the relationship between COMPANY and STOCK QUOTE?
16. What is the identifier for the STOCK QUOTE entity?
17. Create an E-R diagram for a scenario where we need to store the attributes listed below, give the entity a name, include the identifier and attributes, and use crow's foot notation to show minimum and maximum cardinality. (hints: use only these attributes-don't make up new attributes for this assignment;this will require two entity classes, i.e. two entity rectangles in your diagram; each PlaylistNamemust map to at least one song, but songs do not have to be a part of a playlist; a single song can be on multiple playlists and a single playlist can map to multiple songs)
PlaylistName
NumberOfSongs
PlaylistLength
SongTitle
SongArtist
SongPlayLength