1.

Prepare a database specification (either a RAL or an ESG showing database-related details only) for the database. This database

specification may be refined by introducing a sixth relational table, and adjusting three other tables to each have a foreign key that

references this additional table.

1a. Identify the additional table that is required, and clearly describe the adjustments that need to be made to three tables in order to had a

normalized database. [08]

1b. Propose an ESG or RAL that provides specifications for the six relational tables of the music database. [36]

Music Database Relations Musicians (Mog. MName, MDOB MCountry} PK (Mnol Compositions (Co. CTitle CMno. CDate} PK [Cng]: FK [CMng references Musicians) Ensembles {Eno, EName ECountry, EMnoMor} PK [Eno]; FK [EMnoMar references Musicians) Performances (Png. PDate. Pone PCity. PCountry Peno_CKs (PDate. Penol. Prel; FK [PCno references Compositions); FK [PEno references Ensembles] Ensemble Members (EmEng. EmMno, Emlostrument) PK [EmEng. Emunol: FK [EmEng references Ensembles); FK EmMno references Musicians)