3. Imagine the worst possible reports from a system. What is wrong with them? List as many problems as you can. What are the consequences of such reports? What could go wrong as a result? How does the prototyping process help guard against each problem?
4. Given the guidelines presented in this chapter, identify flaws in the design of the Report of Employees shown below. What assumptions about users and tasks did you make in order to assess this design? Redesign this report to correct these flaws.
3. Transform the E-R diagram of Figure 9-21 into a set of 3NF relations.
5. Consider the E-R diagram in Figure 7-20. Based on this E-R diagram, answer the following questions:
a. How many EMPLOYEES can work on a project?
b. What is the degree of the Used_on relationship?
c. Do any associative entities appear in this diagram? If so, name them.
d. How else could the attribute Skill be modeled?
e. What attributes might be attached to the Works_on relationship?
f. Could TOOL be modeled as an associative entity? Why or why not?
16. The owner of two pizza parlors located in adjacent towns wants to computerize and integrate sales transactions and inventory management within and between both stores. The point-of-sale component must be easy to use and flexible enough to accommodate a variety of pricing strategies and coupons. The inventory management, which will be linked to the point-of-sale component, must also be easy to use and fast. The systems at each store need to be linked so that sales and inventory levels can be determined instantly for each store and for both stores combined. The owner can allocate $40,000 for hardware and $20,000 for software and must have the new system operational in three months. Training must be short and easy. Briefly describe three alternative systems for this situation and explain how each would meet the requirements and constraints. Are the requirements and constraints realistic? Why or why not?
17. Compare the alternative systems from Problem and Exercise 16 using the weighted approach demonstrated in Figure 7-19. Which system would you recommend? Why? Was the approach taken in this and Problem and Exercise 16 useful even for this relatively small system? Why or why not?
1. (TCO 2) Which of the following is NOT a project management phase?
2. (TCO 2) Developing an understanding of the content and complexity of the project is the purpose of
3. (TCO 2) During which of the following project planning activities do you use the information regarding tasks and resource availability to assign time estimates to each activity in the work breakdown structure?
4. (TCO 2) The third phase of the project management process in which the plans created in the prior phases are put into action is
5. (TCO 2) The final phase of the project management process that focuses on bringing a project to an end is called
6. (TCO 2) Slack time is equal to
7. (TCO 2) A technique that uses optimistic, pessimistic, and realistic time to calculate the expected time for a particular task best defines
8. (TCO 2) Which of the following is one of the three primary activities associated with identifying and selecting IS development projects?
9. (TCO 2) The ratio of the net cash receipts of the project divided by the cash outlays of the project, enabling trade-off analysis to be made between competing projects, is often referred to as
10. (TCO 2) A benefit derived from the creation of an information system that can be measured in dollars and with certainty is a(n)
1. Why is it important to use systems analysis and design methodologies when building a system? Why not just build the system in whatever way seems to be “quick and easy?” What value is provided by using an “engineering” approach?
8. How might prototyping be used as part of the SDLC?
3. In the section on choosing off-the-shelf software, eight criteria are proposed for evaluating alternative packages. Suppose the choice is between alternative custom software developers rather than prewritten packages. What criteria would be appropriate to select and compare among competing bidders for custom development of an application? Define each of these criteria.
4. How might the project team recommending an ERP design strategy justify its recommendation as compared with other types of design strategies?
1. (TCO 5) Conceptual data modeling is typically done in parallel with other requirements analysis and structuring steps during
2. (TCO 5) On an entity-relationship diagram, a rectangle represents a(n)
3. (TCO 5) Vehicle identification number, color, weight, and horsepower best exemplify
4. (TCO 5) An attribute that can have more than one value for each entity instance is referred to as
5. (TCO 5) The number of entity types that participate in a relationship refers to
6. (TCO 5) A simultaneous relationship among instances of three entity types is a
7. (TCO 5) A relationship that the data modeler chooses to model as an entity type best defines
8. (TCO 6) During which of the following steps will you bring the current phase to a close, prepare a report and presentation to management concerning continuation of the project, and get ready to move the project into design?
9. (TCO 6) Which of the following is a true statement regarding midrange alternatives?
10. (TCO 6) A good number of alternatives to generate is
2. What are some sources of risk in a systems analysis and design project, and how does a project manager cope with risk during the stages of project management?
4. Suppose that you have been contracted by a jewelry store to manage a project to create a new inventory tracking system. Describe your initial approach to the project. What should your first activity be? What information would you need? To whom might you need to speak?
1. The economic analysis carried out during project identification and selection is rather superficial. Why is this? Consequently, what factors do you think tend to be most important for a potential project to survive this first phase of the life cycle?
6. Assuming monetary benefits of an information system at $85,000 per year, one-time costs of $75,000, recurring costs of $35,000 per year, a discount rate of 12 percent, and a five-year time horizon, calculate the net present value of these costs and benefits of an information system. Also calculate the overall return on investment of the project and then present a break-even analysis. At what point does breakeven occur?
1. (TCO 1) The information system includes all of the following EXCEPT
2. (TCO 1) The process of breaking the description of a system down into its smaller components best defines
3. (TCO 1) The extent to which a system or subsystem performs a single function defines
4. (TCO 1) A centralized database that contains all diagrams, forms and report definitions, data structure, data definitions, process flows and logic, and definitions of other organizational and system components best describes
5. (TCO 3) In which SDLC phase will the analyst study the organization’s current procedures and the information systems used to perform tasks?
6. (TCO 3) Priorities for systems and projects are deliverables for the
7. (TCO 3) A systems development methodology created to radically decrease the time needed to design and implement information systems best describes
8. (TCO 3) The practice of turning over responsibility of some or all of an organization’s information systems applications and operations to an outside firm is referred to as
9. (TCO 3) An organization should acquire software from in-house developers when
Sharing your scoops to your social media accounts is a must to distribute your curated content. Not only will it drive traffic and leads through your content, but it will help show your expertise with your followers.
How to integrate my topics' content to my website?
Integrating your curated content to your website or blog will allow you to increase your website visitors’ engagement, boost SEO and acquire new visitors. By redirecting your social media traffic to your website, Scoop.it will also help you generate more qualified traffic and leads from your curation work.
Distributing your curated content through a newsletter is a great way to nurture and engage your email subscribers will developing your traffic and visibility.
Creating engaging newsletters with your curated content is really easy.