Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create an EER diagram modelling the playlist at a radio station.Be sure to mark cardinality and participation constraints for all relations on the diagram, andwrite
Create an EER diagram modelling the playlist at a radio station.Be sure to mark cardinality and participation constraints for all relations on the diagram, andwrite justifications for each.eg The Teaches relationship is onetomany because each Instructor teaches many Coursesand each Course is taught by one Instructor. Courses have partial participation in thisrelationship because they could exist in the database without an assigned instructor. Instructorshave total participation in this relationship because they must teach at least one course. The radio station stores information on all artists and tracks they play All artists have a unique ID Artists can be bands or solo musicians Information available on bands includes a name, founding date, breakup date whichmay be null and number of members Information available on musicians includes first and last names, and a list ofinstruments played. Musicians can be members of a band Artists record albums, which contain tracks. Well assume that all albums are productsof a single artist no albums by various artists Information available on albums includes title, year of release, and number of tracks.Information available on tracks includes title, length, tempo, and genre Tracks can be songs or instrumental. Songs have an age rating, according to thecontents of their lyrics.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started