In fact, a spreadsheet is ill-suited for this application. A database would be a far better tool, and situations like this are obvious candidates for innovation. 1. Analyze the spreadsheet shown in Figure 4-32 and list all of the problems that occur when trying to track the assignment of sheet music using this spreadsheet. 2. Figure 4-32(a) shows a two-table data model for the sheet- music-tracking problem. a. Select primary keys for the ChoirMember and Work tables. 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 primary key and foreign key columns. Figure 4-32 Three Data Model Alternatives Choir Member LastName First Name Email Phone Part Work NameOfWork Composer Part CopyNumber (a) Data Model Alternative 1 Choir Member LastName First Name Email Phone Part Work_Version2 NameOfWork Composer Work_Version 3 WorkID NameOfWork Composer or Copy Assignment Part CopyNumber In fact, a spreadsheet is ill-suited for this application. A database would be a far better tool, and situations like this are obvious candidates for innovation. 1. Analyze the spreadsheet shown in Figure 4-32 and list all of the problems that occur when trying to track the assignment of sheet music using this spreadsheet. 2. Figure 4-32(a) shows a two-table data model for the sheet- music-tracking problem. a. Select primary keys for the ChoirMember and Work tables. 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 primary key and foreign key columns. Figure 4-32 Three Data Model Alternatives Choir Member LastName First Name Email Phone Part Work NameOfWork Composer Part CopyNumber (a) Data Model Alternative 1 Choir Member LastName First Name Email Phone Part Work_Version2 NameOfWork Composer Work_Version 3 WorkID NameOfWork Composer or Copy Assignment Part CopyNumber