Assignment: Information Systems Analysis, Modeling, and Design
Problem I
Al Falfa is meet¬ing with his large team of systems analysts to decide on the qualifica-tions that their prospective new team member should possess. Al says, "In fact, they were so excited by the possibility of our team helping to move our company, Marathon, into an ecommerce strategy that they've said we should start our search now and not wait until the fall."
Ginger Rute, another analyst, agrees, saying, "As long as the economy is healthy, the demand for Web site developers is far out¬stripping the supply. We should move quickly. I think our new person should be knowledgeable in CASE tools, Visual Basic, and JavaScript, just to name a few."
Al looks surprised at Ginger's long list of languages, but then replies, "Well, that's certainly one way we could go. But I would also like to see a person with some business savvy. Most of the people coming out of school will have solid programming skills, but they should know about accounting, inventory, and distribution of goods and services, too."
The newest member of the systems analysis group, Vita Minn, finally breaks into the discussion. She says, "One of the reasons I chose to come to work with all of you was that I thought we all got along quite well together. Because I had some other opportunities, I looked very carefully at what the atmosphere was here. From what I've seen, we're a friendly group. Let's be sure to hire someone who has a good personality and who fits in well with us."
Al concurs, continuing, "Vita's right. The new person should be able to communicate well with us, and with business clients, too. We are always communicating in some way, through formal presenta¬tions, drawing diagrams, or interviewing users. If they understand decision making, it will make their job easier, too. Also, Marathon is interested in integrating ecommerce into the entire business. We need someone who at least grasps the strategic importance of the Web. Page design is such a small part of it."
Ginger interjects again with a healthy dose of practicality; saying, "Leave that to management. I still say the new person should be a good programmer." Then she ponders aloud, "I wonder how important UML will be?"
After listening patiently to everyone's wish list, one of the senior analysts, Cal Siem, speaks up, joking, "We'd better see if Superman is available!"
As the group shares a laugh, Al sees an opportunity to try for some consensus, saying, "We've had a chance to hear a number of differ¬ent qualifications. Let's each take a moment and make a list of the qualifications we personally think are essential for the new ecom¬merce development person to possess. We'll share them and continue discussing until we can describe the person in enough detail to turn a description over to the human resources group for processing." Be specific and explain your reasoning in answering the following questions:
a) What qualifications should the systems analysis team be looking for when hiring their new ecommerce development team member?
b) Is it more important to know specific languages or to have an aptitude for picking up languages and software packages quickly?
c) What basic business skills should the new team member have?
d) How should the new team member be different from the existing team members in terms of competencies and skills?
e) What personality or character traits are desirable in a systems analyst who will be working in ecommerce development?
Problem II
Use the process of normalization to transform the table below into 3NF. Show the tables in 1NF and 2NF that are created in the process.
|
Business ID
|
Business Name
|
Business City
|
Car Model(s)
|
|
A100
|
Weird Autos
|
Galveston
|
F15, F35
|
|
B100
|
Giant Trucks
|
San Antonio
|
F15
|
|
C100
|
Heavy Wheelers
|
Dallas
|
W100
|
|
A101
|
Weird Autos
|
Galveston
|
F25
|
Problem III
Draw an entity-relationship diagram for the following situation: A commercial bakery makes many different products. These products include breads, desserts, specialty cakes, and many other baked goods. Ingredients such as flour, spices, and milk are purchased from vendors. Sometimes an ingredient is purchased from a single vendor, and other times an ingredient is purchased from many vendors. The bakery has commercial customers, such as schools and restaurants, and private customers that regularly place orders for baked goods. Each baked good has a baker assistant that oversees the setup of the bakery operation and inspects the finished product that they are responsible for.
Problem IV
White-N-Wheat Bread Company has asked for your help in comparing its present computer system with a new one its board of directors would like to see implemented. Proposed system and present system costs are as follows:
Year Proposed System Costs Present System Costs
Year 1
Equipment Lease $20,000 $21,500
Salaries 40,000 50,000
Overhead 4,000 13,000
Development 21,000 -
Year 2
Equipment Lease $20,000 $10,500
Salaries 40,000 60,000
Overhead 1,000 3,300
Development 12,000 -
Year 3
Equipment Lease $20,000 $10,500
Salaries 36,000 60,000
Overhead 4,900 3,600
Development - -
Year 4
Equipment Lease $20,000 $10,500
Salaries 39,000 66,000
Overhead 5,500 4,000
Development - -
a. Using break-even analysis, determine the year in which White-N-Wheat Bread will break even with these two strategies.
b. Graph the costs and show the break-even point.
Problem V
Eat-Ur-Potatoes is a fast-food restaurant offering all kinds of potatoes. The manager has a 30-second time limit for serving customers. Servers at the counter say they could achieve that limit if the form they must fill out and give to the kitchen were simplified. The information from the completed form is entered into the computer system at the end of the day, when the data entry person enters the kind of potato purchased, additional toppings purchased with their quantities, and the price charged. The current form is difficult for servers to visually scan and fill out quickly.
a. Design and draw a form that lists possible potatoes and toppings in a manner that is easy for counter servers and kitchen crew to visually scan, and can also be used as input to the inventory system that is on the extranet connecting Eat-Ur-Potatoes and Idaho potato growers. Choose a size that is sensible and be sure to indicate the size of the form if it is not drawn at full-scale. You may use MS Word to produce this form if you don't have any other drawing software available. You won't be judged on the aesthetics of the form, just the content and layout. Be sure to observe the guidelines for good form design.
b. Design and draw a representation of a display screen that can be used by the servers and clerks to fill in the information captured on the form. Again, you may use MS Word for this purpose.
c. Design and draw a display screen based on your screen in part b. This time it should function as a display that shows a kitchen crew member what to prepare for each order. List three changes to the screen in part b that you made to adapt it to function as an output display. You may use MS Word to show the layout of the screen.
Problem VI
As part of a larger systems project, Capital Bank of Nowhere, Colorado, wants your help in setting up a new monthly reporting form for its checking and savings account customers. The president and vice presidents are very attuned to what customers in the community are saying. They think that their customers want a checking account summary that looks like the one offered by the other three banks in town. They are unwilling, however, to commit to that form without a formal summary of customer feedback that supports their decision. Feedback will not be used to change the prototype form in any way. They want you to send a prototype of one form to one group and to send the old form to another group.
a. In a paragraph discuss why it probably is not worthwhile to prototype the new form under these circumstances.
b. In a second paragraph discuss a situation under which it would be advisable to prototype a new form.
Questions
1) Describe programmed, interrupt driven, and direct memory access. Provide an example of an I/O device foreach access method..
2) List, describe, and analyze the most common data storage systems in terms of size, speed, error handling, and cost.
3) Describe the functional components of an operating system, including kernels, modules, application program interfaces, and other services.
4) Compare and contrast a desktop operating system with a mobile operating system.
5) Differentiate between the logical and the physical views of file systems.
6) Describe the functions and purposes of the file directory.
7) Categorize various file protection systems, and provide a few examples from current operating systems.
8) Describe CPU scheduling; how it works and why we need it.
9) Compare an embedded operating system with desktop operating system.
10) If you were going to architect a computer system for a financial analysts, what computer components would you use and why?
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.