Questions and Answers of Modern Systems Analysis And Design

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
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,
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
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
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
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
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
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
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
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
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
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
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,
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
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,
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
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,
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
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
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
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
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
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
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
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
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
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
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
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
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,
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
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
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
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
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
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
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
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
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 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
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
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
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
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
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
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
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
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.
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
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
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