Page 228 - Using MIS

196 Chapter 5 Database Processing

Figure 5-28
Sample Data Entry Form

Collabora tion exerCiSe 5

Using the collaboration IS you built in Chapter 2 (page 74), problems. For one, do Sandra Corning and Linda Duong really
collaborate with a group of students to answer the following have the same copy of music checked out? Second, did Mozart
questions. and J. S. Bach both write a Requiem, or in row 15 should J. S.
Figure 5-29 shows a spreadsheet that is used to track the Bach actually be Mozart? Also, there is a problem with Eleanor
assignment of sheet music to a choir—it could be a church Dixon’s phone number; several phone numbers are the same
choir or school or community choir. The type of choir does not as well, which seems suspicious.
matter because the problem is universal. Sheet music is expen- Additionally, this spreadsheet is confusing and hard to
sive, choir members need to be able to take sheet music away use. The column labeled First Name includes both people
for practice at home, and not all of the music gets back to the names and the names of choruses. Email has both email ad-
inventory. (Sheet music can be purchased or rented, but either dresses and composer names, and Phone has both phone
way, lost music is an expense.) numbers and copy identifiers. Furthermore, to record a
Look closely at this data and you will see some data checkout of music, the user must first add a new row and
integrity problems—or at least some possible data integrity then reenter the name of the work, the composer’s name,

Figure 5-29
Spreadsheet Used for
Assignment of Sheet Music