top-rated free essay

Information Systems

By Jamielynnroyle1 Apr 17, 2013 1041 Words
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 foreign key to integrate the two tables is the Member ID column in the MusicalWorkTable. This way when someone checks out or borrows a sheet music they can link it to who the student is. This connects the two tables and integrates the data. •This two-table design does not eliminate the potential for data integrity problems that occur in the spreadsheet. Explain why not. i.This design does not eliminate the potential for data integrity problems because who ever enters the information has to make sure it is all entered correctly. There is always error potential therefore whoever uses the table must be careful. ii.Also, there must be a separate table that has all of the information linked together. 3.A three table database design for the data in the spreadsheet in Figure 5-15 is as follows: •Redraw the data in Figure 5-15 into this three-table format. 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 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

Member IDFirst NameLast NameName of WorkMusical ID
1JaneAshleyB-Minor Mass1
2 KayeDavidsonRequiem2
3Kam HoongChing9th Symphony Chorus3
4Lori LeeMenstellB-Minor Mass4
5 SandraCorningRequiem5

Identify which columns are primary keys for each of these tables. i.The primary keys are the Member ID and the Musical ID
The foreign keys are already in place; identify which columns are foreign keys and which relationships they represent. i.The Musical ID in the third table is the foreign ID.
Does this design eliminate the potential for data integrity problems that occur in the spreadsheet? Why or why not? i.Yes, because it links the members with the music sheets. If their name is linked the exactly which sheet of music they have out then there is no way for data integrity problems. 4.Assume you manage the choir and you foresee two possibilities: •Keep the spreadsheet, but create procedures to reduce the likelihood of data integrity problems. •Create an Access database and database application for the three-table design. Describe the advantages and disadvantages of each of these possibilities. Recommend one of these two possibilities and justify your recommendation. For the spreadsheet option, some of the advantages would be that it would be easier for most people to use. The user would be able to see clearly which student has which music. The disadvantages of using a spreadsheet is that whoever enters the information must be extremely careful when entering the information because it is very easy to mess up. Also, since there are so many tables and you have to look back at the previous ones to see who has what it can get a little confusing.

If we decided on the database application the advantages would be that it is very easy to enter information and you can look up one individual at a time or all at once. It lays out the information very clearly. However the disadvantages would be that Access is very confusing and not many people know how to use it correctly

Cite This Document

Related Documents

  • Information System Technology at Walmart

    ...Ackowledgement This research was done in the course BMIS 300 (Management Information System) under the supervision of Mr.Hussein RAMMAL. In the first place, we convey special acknowledgement to Mr.Hussein RAMMAL for giving us the opportunity to work on this research and for his kind aid and support. We are extraordinarily fortunate in having hi...

    Read More
  • background Management information system

    ...BACKGROUND OF MIS (Management information system) Before the concept of management information systems was created, computer scientists were just programmers creating applications for science and math calculations. As computer usage evolved in fields of business and data management, software applications were needed to process nonscientific dat...

    Read More
  • Information System Proposal

    ...Information System Proposal Table of Contents Title Page 1 Table of Contents 2 Introduction 3 Table of Information Systems 3 Types of Systems 4 * Functional Area * Transaction Processing System * Office Automation Systems * Executive Dashboard When it comes to starting a business using the right information...

    Read More
  • Information System Proposal

    ...Information Systems Proposal BIS220 August 19, 2013 Information Systems Proposal Prepared for The Brick and Mortar Record Store...

    Read More
  • Computer Information System Brief

    ...Abstract In this paper I explain what opportunities Kudler Fine Foods has in terms of information technology, and describe how the company might benefit from implementing enterprise-wide computer information system. Computer information system brief Kudler Fine Foods (KFF) is a local chain of gourmet food stores with annual sales of more ...

    Read More
  • Different Types of Information Systems

    ...different types of information systems at Western Chemical are: a. Operations support systems These include: i. Transaction processing systems Transaction processing systems are used to process business transactions. Western Chemical uses the internet and an electronic commerce website to capture data and pro...

    Read More
  • Information Systems Proposal

    ... Proposal for Old School Records Business 220 July 18, 2013 Table of Content Information Systems……………………………………………………………………………....3 Office Automation System………………………….…………………………………………….3 Management Information Systems...

    Read More
  • Computerized Information System

    ...Information Systems for Learning and Instruction[edit] In Discovering Computers 2007 a Gateway to Information, a computer based information system is described as the "collection of hardware, software, data, people, and procedures that work together to produce quality information". These information systems provide opportunities to improve st...

    Read More

Discover the Best Free Essays on StudyMode

Conquer writer's block once and for all.

High Quality Essays

Our library contains thousands of carefully selected free research papers and essays.

Popular Topics

No matter the topic you're researching, chances are we have it covered.