Information Systems

Only available on StudyMode
  • Download(s) : 370
  • Published : April 17, 2013
Open Document
Text Preview
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. •The first 6 entries to the spreadsheet seem easy to track however they do not show which member is using which sheet of music •After the first 6 rows all the musical works are just listed and you cannot tell who is responsible for each sheet •One of the sheet music is duplicated

There are no keys to relate the members and the music
Information is listed in the wrong columns

2.The following two tables could be used to store the data in Figure 5-15 in a database: •Redraw the data in Figure 5-15 into this two-table format. Choir Member Table
Member IDLast NameFirst NameEmailPhonePart
1AshleyJaneJA@somewhere.com
703.555.1234Soprano
2DavidsonKayeKD@somewhere.com
703.555.2236Soprano
3ChingKam HoongKHC@overhere.com
703.555.2236Soprano
4MenstellLori LeeLLM@somewhere.com
703.555.1237Soprano
5CorningSandraSC2@overhere.com
703.555.1234Soprano
6WeiGuangGW1@somewhere.com
703.555.9936Soprano
7DixonEleanorED@thisplace.com
703.555.12379Soprano
8DuongLindaLD2@overhere.com
703.555.8736Soprano
9LundenHaleyHL@somewhere.com
703.555.0836Soprano
10UtranDiem ThiDTU@somewhere.com
703.555.1089Soprano

Musical Work Table
Musical IDNameOfWorkComposerPartCopyNumberMember ID
1B-Minor MassJ.S BachSopranoCopy 71
2RequiemMozartSoprano Copy 172
39th Symphony ChorusBeethovenSopranoCopy 93
4B-Minor MassJ.S BachSopranoCopy 114
5RequiemJ.S BachSopranoCopy 195

Select primary keys for the ChiorMember and MusicalWork tables. i.The primary keys for the ChiorMember table should be Member ID and theprimary key for the MusicalWork should be Musical ID

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. i.The...
tracking img