Reference no: EM132716589

Music school is about to launch a music company, which needs a new database to be developed to store all the necessary information about musicians, albums, songs, and live performances. Following is further detail.

1. Each musician in the company has a unique SSN, first name, last name, an address, and a phone number.
2. Each album recorded has an album ID, title and an author (musician). 
3. Each album has multiple songs on it. Each song has a unique Song ID, name, length, and a track number.
4. Each song is performed by one or more musicians, and a musician may perform multiple songs. 
5. Musicians also perform in live performances. The company wants to keep track of the location and time of each performance that a given musician took part in.

Tasks:

Problem 1. Using the 9-step process, draw an entity relationship diagram (ERD) for the above specification. Document assumptions you make when drawing the ER diagram.

Problem 2. Convert or map the ER diagram into relational schema. Normalise all data.