本次美国代写是一个软件工程代写的限时测试
1. [15 points] The software analyst of company X elicited and documented the functional requirements
below for the Notown Records project. Build the corresponding conceptual model by designing an ERD
using the Peter Chen’s notation.
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;
REQ_12 – Relationship between Song and Album
Rationale: Each SONG must belong to only one ALBUM, and an ALBUM can have several SONGS.
2. [15 points] Imagine the software development company Y has just hired you as a software analysist. Your
first job is to analyze the ERD below and write down all corresponding functional requirements (let’s
assume this document is missing). Use the template shown in question 1.
