Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: THEend8_
Assignment 2 – Project: Distributed System and Application
REQ_01 – Musicians Registration
Rationale: A MUSICIAN is identified by an SSN and has the attribute Name.
REQ_02 – Musicians Addresses Registration
Rationale: An ADDRESS is identified by an AddressID, and has the attributes Number, Street1, Street2,
City, State, Zip Code and Telephone;
REQ_03 – Relationship between Addresses and Musicians
Rationale: Each MUSICIAN must live in a unique ADDRESS, but more than one MUSICIAN can live in
the same ADDRESS.
REQ_04 – Instruments Registration
Rationale: An INSTRUMENT is identified by a Name, and has the attribute Pitch;
REQ_05 – Relationship between Instrument and Musician
Rationale: Each MUSICIAN can play several INSTRUMENTS, and an INSTRUMENT can be played by
several MUSICIANS.
REQ_06 – Song Registration
Rationale: A SONG is identified by a Title, and has the attribute Length;
REQ_07 – Relationship between Instrument and Song
Rationale: Each INSTRUMENT can be used in several SONGS, and a SONG can use several
INSTRUMENTS;
REQ_08 – Relationship between Song and Musician – Authorship
Rationale: Each SONG must have a single author (MUSICIAN), and an author can author several SONGS;
REQ_09 – Relationship between Song and Musician – Performer
Rationale: Each SONG can have several performers (MUSICIAN), and a performer can perform several
SONGS;
REQ_10 – Album Registration
Rationale: An ALBUM is identified by an AlbumID, and has attributes Title, Release_Date, Format, and
the calculated attribute Age.
REQ_11 – Relationship between Musician and Album – Producer
Rationale: Each MUSICIAN can produce several ALBUMS, and an ALBUM must be produced by only
one MUSICIAN;