Question : 1.Analyze the spreadsheet shown in Figure 5-15 and list all : 1585158
1.Analyze the spreadsheet shown in Figure 5-15 and list all of the problems that occur when trying to track the assignment of sheet music using this spreadsheet.
2.The following two tables could be used to store the data in Figure 5-15 in a database.
a.Redraw the data in Figure 5-15 into this two-table format.
b.Select primary keys for the ChoirMember and MusicalWork tables.
c.The two tables are not integrated; they do not show who has checked out which music. Add foreign key columns to one of the tables to integrate the data.
d.This two-table design does not eliminate the potential for data integrity problems that occur in the spreadsheet. Explain why not.