Figure 4-38(a) shows a two-entity data model for the sheet-music-tracking problem. a. Select identifiers for the Choir

Question:

Figure 4-38(a) shows a two-entity data model for the sheet-music-tracking problem.
a. Select identifiers for the Choir Member and Work entities. Justify your selection.
b. This design does not eliminate the potential for data integrity problems that occur in the spreadsheet. Explain why not.
c. Design a database for this data model. Specify key and foreign key columns.