Draw an ERD for the following business. Identify Primary Keys and Cardinalities. Assign additional attributes for entities
Question:
Draw an ERD for the following business. Identify Primary Keys and Cardinalities. Assign additional attributes for entities as may be necessary. Demonstrate an IS-A relationship.
Although you always wanted to be a musician, good sense prevailed and you ended up being an expert on databases instead. Your old love is still there however, so you set up a management company, TalentBase, that tracks artists and their creations.
The company will gather information about artists, their names, unique number, birthplaces, age, and genre of music. For each Song that is done: the artist, producer, the year it was made, its title, its genre and its sales volume is recorded. A song may also be a cover version in which case the original artist and record label are also stored, additionally a song can be a collaboration where collaborating artist and country are stored. Producer name, producer ID, age and alias are also recorded.
One artists can voice many songs and a song can be voiced by multiple artists. A song can only have one producer but one producer can have many songs.
A. Draw an ER diagram to represent the information brought out in the above scenario.
B. Translate the ER model diagram created in part A to the relational model (Tables).
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi