Answer Happy

Seniwara Sdn. Bhd. is a music organization that plan to build a music database management system. This organization has more than hundreds active members and actively participate in many competitions. As a database designer. you are required to design a database for Seniwara Sdn. Bhd. which consists of the following requirements: • Each member will have their ID, first name, last name and register date. • Each member can participates in more than one competition, but he/she is only allowed to participate in one competition at one time. The result of the competition is recorded • Each member is also can be categorized as a singer, dancer or musician. • Each member may be given an opportunity to produce their own mini album(s). Each mini album has a unique identification number, a title and a copyright date. • Each mini album has a number of songs on it, but no song may appear on more than one mini album • Each song is composed by a professional composer, and each composer may compose a number of songs. Based on the given information, identify Entities, their attributes, and relationships among the entities.