Shows a spreadsheet that is used to track the assignment of sheet music to a cho

Question

Shows a spreadsheet that is used to track the assignment of sheet music to a choir-it could be a church choir or school or community choir. The type of choir does not matter because the problem is universal. Sheet music is expensive. Choir members need to be able to take sheet music away for practice at home, and not all of the music gets back to the inventory. (Sheet music can be purchased or rented, but either way lost music is an expense. Look closely at this data and you will see some data integrity problems-or at least some possible data integrity

Explanation / Answer

After observing the sheet music, you have several integrity issues:

a) States that the primary key of a table must have a unique value for each row in the table

b) The rows 7, 8, 9, 12, 14 and 15 have incorrect values.

c) Expanding but the tables because they can have multiple phone numbers and emails.

It is recommended to modify the tables.

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.