Figure 4-38(b) shows a second alternative data model for the sheet-music-tracking problem. This alternative shows two variations on the Work entity. In the second variation, an attribute named Work ID has been added to Work_Version3. This attribute is a unique identifier for the work; the DBMS will assign a unique value to Work ID when a new row is added to the Work table.
a. Select identifiers for Choir Member, Work_Version2, Work_Version3, and Copy Assignment. Justify your selection.
b. Does this design eliminate the potential for data integrity problems that occur in the spreadsheet? Why or why not?
c. Design a database for the data model that uses Work_Version2. Specify key and foreign key columns.
d. Design a database for the data models that uses Work_Version3. Specify key and foreign key columns.
e. Is the design with Work_Version2 better than the design for Work_Version3? Why or why not?