Modern Systems Analysis And Design 8th Edition Joseph Valacich, Joey George - Solutions

List the PC-based software packages you like to use. Describe each package in terms of the following usability characteristics: time to learn, speed of performance, rate of errors by users, retention over time, and subjective satisfaction. Which of these characteristics has made you want to
Consider reports you might receive at work (e.g., budgets or inventory reports) or at a university (e.g., grade reports or transcripts). Evaluate the usability of these reports in terms of speed, accuracy, and satisfaction. What could be done to improve the usability of these outputs?
Imagine an output display form for a hotel registration system. Using a software package for drawing such as Microsoft Visio, follow the design suggestions in this chapter and design this form entirely in black and white. Save the file and then, following the color design suggestions in this
It was late. Sally Fukuyama, assistant director of marketing, knocked on the slightly open door of Jim Watanabe’s office. Jim was the project director for the “No Customer Escapes” customer loyalty system for Petrie Electronics. “Yeah, come in,” Jim called.“Hi, Jim,” Sally said,
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?
Consider a system that produces budget reports for your department at work. Alternatively, consider a registration system that produces enrollment reports for a department at a university. For whichever system you choose, answer the following design questions: Who will use the output? What is the
Provide some examples where variations in users, tasks, systems, and environmental characteristics might affect the design of system forms and reports.
List and describe common website design errors.
What measures do many development groups use to assess a system’s usability?
What is meant by usability and what characteristics of an interface are used to assess a system’s usability?
Consider Figure 9-19b. Explain a query that would likely be processed more quickly using the denormalized relations rather than the normalized relations.Figure 9-19b (b) VENDOR ITEM PRICE QUOTE Vendor_ID Item_ID Description Price Address Contact_Name
Describe how numeric, textual, and alphanumeric data should be formatted in a table or list.
Suppose you created a file for each relation in your answer to Problem and Exercise 9-45. If the following queries represented the complete set of accesses to this database, suggest and justify what primary and secondary key indexes you would build.a. For each PART in Item_Number order list in
What column, row, and text formatting issues are important when designing tables and lists?
In Problem and Exercise 9-45, you developed integrated normalized relations. Choose primary keys for the files that would hold the data for these relations. Did you use attributes from the relations for primary keys or did you design new fields? Why or why not?Problem and Exercise 9-45 VENDOR PRICE
How should textual information be formatted on a help screen?
Discuss the benefits, problems, and general design process for the use of color when designing system output.
When can highlighting be used to convey special information to users?
Describe the prototyping process of designing forms and reports. What deliverables are produced from this process? Are these deliverables the same for all types of system projects? Why or why not?
Find out what database management systems are available at your university for student use. Investigate what physical file and database design decisions need to be made. Compare this list of decisions with those discussed in this chapter. For physical database and design decisions (or options) not
Find a systems analyst or database administrator within a company that uses a database management system to orga nize the company’s corporate data. Ask this person to describe what “additional information” should be collected during requirements analysis that is needed for file and database
Locate library books or articles that discuss additional normal forms other than second and third normal forms. Describe each of these additional normal forms and give examples of each. How are these additional normal forms different from those presented in this chapter? What additional benefit
Model a set of typical family relationships—spouse, father, and mother—in a single 3NF relation. Also include nonkey attributes name and birth date. Assume that each person has only one spouse, one father, and one mother. Show foreign keys with dashed underlining.
Suppose you were designing a file of student records for your university’s placement office. One of the fields that would likely be in this file is the student’s major. Develop a coding scheme for this field that achieves the objectives outlined in this chapter for field coding.
Consider the following 3NF relations about a sorority or fraternity:MEMBER(Member_ID,Name,Address,Dues_Owed) OFFICE(Office_Name,Officer_ID,Term_Start_Date, Budget)EXPENSE(Ledger_Number,Office_Name,Expense_Date, Amt_Owed)PAYMENT(Check_Number,Expense_Ledger_Number,
Consider the following functional dependencies:Applicant_ID S Applicant_NameApplicant_ID S Applicant_AddressPosition_ID S Position_TitlePosition_ID S Date_Position_OpensPosition_ID S DepartmentApplicant_ID + Position_ID S Date_AppliedApplicant_ID + Position_ID S Date_ Intervieweda. Represent these
Assume that, at PVF, products are composed of components, products are assigned to salespersons, and components are produced by vendors. Also assume that, in the relation PRODUCT(Prodname, Salesperson, Compname, Vendor), Vendor is functionally dependent on Compname and Compname is functionally
What are the seven factors that should be considered in selecting a file organization?
What are the goals of designing physical tables?
Explain the purpose of data compression techniques.
What factors influence the decision to create an index on a field?
Jim Watanabe, assistant director of IT for Petrie Electronics, and the manager of the “No Customer Escapes” customer loyalty system project, was walking down the hall from his office to the cafeteria. It was 4 p.m., but Jim was nowhere close to going home yet. The deadlines he had imposed for
What is the purpose of denormalization? Why might you not want to create one physical table or file for each relation in a logical data model?
What is the difference between how a range control statement and a referential integrity control statement are handled by a file management system?
In what way does the choice of a data type for a field help to control the integrity of that field?
Can instances of a relation (sample data) prove the existence of a functional dependency? Why or why not?
How is a foreign key represented in relational notation?
What problems can arise when merging relations (view integration)?
List five properties of relations.
What is the purpose of normalization?
Give an example (different from any example in this chapter) of a ternary relationship.
Talk with a systems analyst who uses a CASE tool. Investigate what capabilities the CASE tool has for automatically checking for rule violations in DFDs. What reports can the CASE tool produce with error and warning messages to help analysts correct and improve DFDs?
An organization is in the process of upgrading microcomputer hardware and software for all employees. Hardware will be allocated to each employee in one of three packages. The first hardware package includes a standard microcomputer with a color monitor of moderate resolution and moderate storage
The following is an example that demonstrates the rules of the tenure process for faculty at many universities. Present the logic of this business using a decision table. Write down any assumptions you have to make.A faculty member applies for tenure in his or her sixth year by submitting a
Choose a transaction that you are likely to encounter and develop a written use case for it.
Obtain a copy of an invoice, order form, or bill used in one of your recent business transactions. Create an E-R diagram to describe your sample document.
Using Table 8.1 as a guide, develop the complete script (questions and possible answers) of an interview between analysts and users within the order entry function at PVF.Table 8.1 1. What are the subjects/objects of the business? What types of people, places, things, materials, events, etc. are
A concert ticket reservation is an association among a patron, a concert, and a seat. Select a few pertinent attributes for each of these entity types and represent a reservation in an E-R diagram.
Consider the E-R diagram in Figure 8.25. Are all three relationships—Holds, Goes_on, and Transports necessary (i.e., can one of these be deduced from the other two)? Are there reasonable assumptions that make all three relationships necessary? If so, what are these assumptions?Figure 8.25 AGENT
What is the degree of a relationship? Give an example of each of the relationship degrees illustrated in this chapter.
What are the linkages among DFDs, decision tables, and E-R diagrams?
Which of the following types of relationships—one-to-one, one-to-many, many-to-many—can have attributes associated with them?
What is the significance of triggering operations and business rules in the analysis and design of an information system?
When must a many-to-many relationship be modeled as an associative entity?
Explain why a ternary relationship is not the same as three binary relationships.
What elements of a DFD should be analyzed as part of data modeling?
Distinguish between the data modeling done during information systems planning, project initiation and planning, and the analysis phases of the SDLC.
Jim Watanabe, manager of the “No Customer Escapes” project, and assistant director of IT for Petrie Electronics, was sitting in the company cafeteria. He had just finished his house salad and was about to go back to his office when Stephanie Welch sat down at his table. Jim had met Stephanie
Discuss why some systems developers believe that a data model is one of the most important parts of the statement of information system requirements.
At an organization with which you have contact, ask one or more employees to draw a “picture” of the business process they interact with at that organization. Ask them to draw the process using whatever format suits them. Ask them to depict in their diagram each of the components of the process
Find out which, if any, drawing packages, word processors, forms design, and database management systems your university or company supports. Research these packages to determine how they might be used in the production of a project dictionary. For example, do the drawing packages include a set of
Interview several people in an organization about a particular system. What is the system like now and what would they like to see changed? Create a complete set of DFDs for the system. Show your DFDs to some of the people you interviewed and ask for their reactions. What kinds of comments do they
Talk with a systems analyst who works at an organization. Ask the analyst to show you a complete set of DFDs from a current project. Interview the analyst about his or her views concerning DFDs and their usefulness for analysis.
At a local bank, loan officers must evaluate loan applications before approving or denying them. During this evaluation process, many factors regarding the loan request and the applicant’s background are considered. If the loan is for less than $2000, the loan officer checks the applicant’s
Mary is trying to decide which graduate programs she will apply to. She wants to stay in the southeastern region of the United States, but if a program is considered one of the top 10 in the country, she is willing to move to another part of the United States. Mary is interested in both the MBA and
Read the narratives below and follow the directions for each. If you discover that the narrative is incomplete, make up reasonable explanations to complete the story. Supply these extra explanations along with your answers.a. Samantha must decide which courses to register for this semester. She has
In a relatively small company that sells thin, electronic keypads and switches, the rules for selling products specify that sales representatives are assigned to unique regions of the country. Sales come either from cold calling, referrals, or current customers with new orders. A sizable portion of
In one company, the rules for buying personal computers specify that if the purchase is over $15,000, it has to go out for bid, and the Request for Proposals (RFP) must be approved by the Purchasing department. If the purchase is under $15,000, the personal computers can simply be bought from any
What types of questions need to be asked during requirements determination in order to gather the information needed for logic modeling? Give examples.
Look at the set of DFDs created in this chapter for Hoosier Burger’s food-ordering system. Represent the decision logic of one or more of the processes as decision tables.
Develop a context diagram and as many nested DFDs as you consider necessary to represent all the details of the training logistics system described in the following narrative. If you discover that the narrative is incomplete, make up reasonable explanations to complete the story. Supply these extra
An auto rental company wants to develop an automated system that can handle car reservations, customer billing, and car auctions. Usually a customer reserves a car, picks it up, and then returns it after a certain period of time. At the time of pickup, the customer has the option to buy or waive
The diagram in Figure 7-33 includes five use cases. In this chapter, Jim Woo wrote descriptions for one of them, Browse catalog. Prepare written descriptions for the other use cases in Figure 7-33.Figure 7-33 Browse Catalog Maintain Account Place Order Shipping Clerk Customer Fill Order Check Order
Starting with a context diagram, draw as many nested DFDs as you consider necessary to represent all of the details of the system described in the following narrative. In drawing these diagrams, if you discover that the narrative is incomplete, make up reasonable explanations to make the story
Choose a transaction that you are likely to encounter, perhaps ordering a cap and gown for graduation, and develop a use case diagram for it.
Develop a written use case for using an ATM machine to withdraw cash.
Consider the three DFDs in Figure 7-25. List three errors (rule violations) on these DFDs. E1 DF1 DF9 DF8 DF1 P1.1 P1.4.1 P1 DS1 DF11 P1.3 DF7 Level 0 DF3 DF2 DF3 Level 1 DF6 P1.2 Level 2 P1.4.2 DF10 DF6 P2 P3 DS2 DF8 DF9 DF12 DS2 DF4 DF5 P1.4 P1.4.3 E2 DF2 DF2
Develop a use case diagram for using an ATM machine to withdraw cash.
Consider the DFD in Figure 7-24. List three errors (rule violations) on this DFD.Figure 7-24 1.0 DF2 E1 P2 DF5 DS1 DF1 DF6 DF3 2.0 DF4 P1 DF2 E2
Draw a use case diagram based on the level-0 diagram in Figure 7-23. How does your use case diagram for Figure 7-23 differ from the one in Figure 7-26, which is also about registering for classes? To what do you attribute the differences?Figure 7-23Figure 7-26 ---- --- Register for Classes -----
What is the relationship between DFDs and entries in the project dictionary or CASE repository?
Draw a use case diagram for the situation described in Problem and Exercise 7-43.Problem and Exercise 7-43Develop a context diagram and as many nested DFDs as you consider necessary to represent all the details of the training logistics system described in the following narrative.If you discover
Refer to Figure 7-23, which contains drafts of a context and level-0 DFD for a university class registration system. Identify and explain potential violations of rules and guidelines on these diagrams.Figure 7-23 Context Diagram Class Schedule Student Course Request Class Registration System List
Draw a use case diagram for the situation described in Problem and Exercise 7-42.Problem and Exercise 7-42Develop a context diagram and a level-0 diagram for the contracting system described in the following narrative. If you discover that the narrative is incomplete, make up reasonable
Choose an example like the one in Problem and Exercise 7-32 and draw a context diagram. Decompose this diagram until it does not make sense to continue. Be sure that your diagrams are balanced.Problem and Exercise 7-32Choose a transaction that you are likely to encounter, perhaps ordering a cap and
Draw a use case diagram for the situation described in Problem and Exercise 7-41.Problem and Exercise 7-41Develop a context diagram and level-0 diagram for the hospital pharmacy system described in the following narrative. If you discover that the narrative is incomplete, make up reasonable
Evaluate your level-0 DFD from Problem and Exercise 7-32 using the rules for drawing DFDs in this chapter. Edit your DFD so that it does not break any of these rules.Problem and Exercise 7-32Choose a transaction that you are likely to encounter, perhaps ordering a cap and gown for graduation, and
Draw a use case diagram for the situation described in Problem and Exercise 7-40.Problem and Exercise 7-40Starting with a context diagram, draw as many nested DFDs as you consider necessary to represent all of the details of the system described in the following narrative. In drawing these
Choose a transaction that you are likely to encounter, perhaps ordering a cap and gown for graduation, and develop a high-level DFD or a context diagram. Decompose this to a level-0 diagram.
Using the example of a retail clothing store in a mall, list relevant data flows, data stores, processes, and sources/ sinks. Observe several sales transactions. Draw a context diagram and a level-0 diagram that represent the selling system at the store. Explain why you chose certain elements as
Think of several business processes you take part in regularly as a customer. For example, think about withdrawing cash from an ATM. Think about ordering a movie and downloading a movie online. Consider purchasing something with a credit card from a big-box store. Use BPMN to depict each of the
Draw a use case diagram for the situation described in Problem and Exercise 7-39, page 210.Problem and Exercise 7-39Starting with a context diagram, draw as many nested DFDs as you consider necessary to represent all the details of the employee hiring system described in the following narrative.
What is the formula that is used to calculate the number of rules a decision table must cover?
Find a company in your area that uses BPMN. Interview analysts and users about this business process modeling approach. What do they think of it? How useful is it? Ask for some examples of diagrams they have created.
What are extensions?
List the deliverables from the conceptual data modeling part of the analysis phase of the systems development process.
Explain the relationship between minimum cardinality and optional and mandatory participation.
List the ideal characteristics of an entity identifier attribute.
Explain how conceptual data modeling is different when you start with a prepackaged data model rather than a clean sheet of paper.
Contrast the following terms:a. Subtype; supertypeb. Total specialization rule; partial specialization rulec. Disjoint rule; overlap ruled. Attribute; operation

Showing 700 - 800 of 1024

Modern Systems Analysis And Design 8th Edition Joseph Valacich, Joey George - Solutions

Step by Step Answers