Premium Essay

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

In:

Submitted By ronn
Words 947
Pages 4
Chapter 5 Review Questions

1. Describe systems analysis and the major activities that occur during this phase of the systems development life cycle.
During systems analysis, you determine how the current information system functions and assess what users would like to see in a new system. Requirements determination, requirements structuring, and alternative generation and selection are the three primary systems analysis activities.

2. What are some useful character traits for an analyst involved in requirements determination?
Requirements determination is a crucial part of the systems development life cycle; therefore impertinence, impartiality, relaxing constraints, attention to details, and reframing are important characteristics.

3. Describe three traditional techniques for collecting information during analysis. When might one be better than another?
Traditional techniques for collecting requirements include interviewing and listening, observing users, and analyzing procedures and other documents. Interviewing and listening involve talking with users individually or as a group to discover their views about the current and target systems; it also involves carefully preparing an interview outline and guide before conducting the interview. Interviews are best done when only a few people are involved, when you need open-ended questions or the questions vary from individual to individual, or when a more personal method is needed.

4. What are the general guidelines for conducting interviews?
The general guidelines for conducting interviews are summarized in Table 5-3. These guidelines include planning the interview, being neutral, listening and taking notes, reviewing these notes within 48 hours, and seeking diverse views. 5. What are the general guidelines for collecting data through observing workers?
When observing workers, it is

Similar Documents

Premium Essay

Management 340

... 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? One-to-many employees b. What is the degree of the Used_on relationship? 2, since there are two entity types participate in this relationship c. Do any associative entities appear in this diagram? If so, name them. No d. How else could the attribute Skill be modeled? The attribute Skill is a multivalued one. e. What attributes might be attached to the Works_on relationship? We could attach the following attributes: 1. FROM: From which date employee works on the project 2. PCT: How much of his time does he use in working on this project f. Could TOOL be modeled as an associative entity? Why or why not? No, because Used_on relationship shows that each task has one and only one tool. No additional data is required. 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...

Words: 688 - Pages: 3

Premium Essay

Database

...purpose of this chapter is to present a detailed description of the entity-relationship model and the use of this tool within the context of conceptual data modeling. This chapter presents the basic entity-relationship (or E-R) model, while advanced features are presented in Chapter 3. Chapter Objectives Specific student learning objectives are included in the beginning of the chapter. From an instructor’s point of view, the objectives of this chapter are to: 1. Emphasize the importance of understanding organizational data, and convince your students that unless they can represent data unambiguously in logical terms, they cannot implement a database that will effectively serve the needs of management. 2. Present the E-R model as a logical data model that can be used to capture the structure and much, although not all, of the semantics (or meaning) of data. 3. Apply E-R modeling concepts to several practical examples including the Pine Valley Furniture Company case. Key Terms |Associative entity |Entity-relationship diagram |Relationship instance | | |(E-R diagram) | | |Attribute | |Relationship type | |Binary relationship |Entity-relationship model...

Words: 12988 - Pages: 52

Premium Essay

Busn 286

...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? Any amount. * b. What is the degree of the Used_on relationship? Binary, two degrees for the relationship. * c. Do any associative entities appear in this diagram? If so, name them. Yes Task is an associative entity. * d. How else could the attribute Skill be modeled? It could be shown coming off of Task as another blue square attached back to Task * e. What attributes might be attached to the Works_on relationship? The different positions on the project. It could include the jobs and requirements as well. * f. Could TOOL be modeled as an associative entity? Why or why not? No because different tool can be used on different tasks. Sometimes you would need more or less tools depending on what you are trying to do. 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...

Words: 784 - Pages: 4

Free Essay

Dbms Class

...Introduction Exercises 4 Chapter 2 Entity Relationship Model Exercises 9 Chapter 3 Relational Model Exercises 30 Chapter 4 SQL Exercises 42 Chapter 5 Other Relational Languages Exercises 58 Chapter 6 Integrity and Security Exercises 74 iii iv Contents Chapter 7 Relational-Database Design Exercises 84 Chapter 8 Object-Oriented Databases Exercises 98 Chapter 9 Object-Relational Databases Exercises 109 Chapter 10 XML Exercises 119 Chapter 11 Storage and File Structure Exercises 129 Chapter 12 Indexing and Hashing Exercises 141 Chapter 13 Query Processing Exercises 155 Chapter 14 Query Optimization Exercises 166 Chapter 15 Transactions Exercises 175 Chapter 16 Concurrency Control Exercises 182 Chapter 17 Recovery System Exercises 194 Contents v Chapter 18 Database System Architectures Exercises 201 Chapter 19 Distributed Databases Exercises 208 Chapter 20 Parallel Databases Exercises 217 Chapter 21 Application Development and Administration Exercises 225 Chapter 22 Advanced Querying and Information Retrieval Exercises 232 Chapter 23 Advanced Data Types and New Applications Exercises 241 Chapter 24 Advanced Transaction Processing Exercises 249 C H A P T E R 1 Introduction Chapter 1 provides a general overview of the nature and purpose of database systems. The most important concept in this chapter is that database systems allow...

Words: 41091 - Pages: 165

Premium Essay

B2B Advantages and Disadvantages

...This page intentionally left blank Te n t h E d i t i o n MODERN DATABASE MANAGEMENT Editorial Director: Sally Yagan Editor in Chief: Eric Svendsen Executive Editor: Bob Horan Editorial Project Manager: Kelly Loftus Editorial Assistant: Jason Calcano Director of Marketing: Patrice Lumumba Jones Marketing Manager: Anne Fahlgren Marketing Assistant: Melinda Jensen Senior Managing Editor: Judy Leale Project Manager: Becca Richter Senior Operations Supervisor: Arnold Vila Operations Specialist: Ilene Kahn Senior Art Director: Jayne Conte Cover Designer: Suzanne Behnke Cover Art: Fotolia © vuifah Manager, Visual Research: Karen Sanatar Permissions Project Manager: Shannon Barbe Media Project Manager, Editorial: Denise Vaughn Media Project Manager, Production: Lisa Rinaldi Supplements Editor: Kelly Loftus Full-Service Project Management: PreMediaGlobal Composition: PreMediaGlobal Printer/Binder: Edwards Brothers Cover Printer: Lehigh-Phoenix Color/Hagerstown Text Font: Palatino Credits and acknowledgments borrowed from other sources and reproduced, with permission, in this textbook appear on appropriate page within text. Microsoft® and Windows® are registered trademarks of the Microsoft Corporation in the U.S.A. and other countries. Screen shots and icons reprinted with permission from the Microsoft Corporation. This book is not sponsored or endorsed by or affiliated with the Microsoft Corporation. Copyright © 2011, 2009, 2007, 2005, 2002...

Words: 193467 - Pages: 774

Premium Essay

Essentials of Systems Analysis and Design

...This page intentionally left blank Download at www.Pin5i.Com Essentials of Systems Analysis and Design Download at www.Pin5i.Com Editorial Director: Sally Yagan Editor in Chief: Eric Svendsen Executive Editor: Bob Horan Editorial Assistant: Ashlee Bradbury Director of Marketing: Patrice Lumumba Jones Executive Marketing Manager: Anne Fahlgren Senior Managing Editor: Judy Leale Production Project Manager: Kelly Warsak Senior Operations Supervisor: Arnold Vila Operations Specialist: Cathleen Petersen Creative Director: Blair Brown Senior Art Director/Design Supervisor: Janet Slowik Text Designer: Michael Fruhbeis Creative Director/Cover: Jayne Conte Cover Designer: Suzanne Duda Cover Art: Fotolia/3d mosaic/©Redshinestudio Manager, Rights and Permissions: Hessa Albader Media Project Manager: Lisa Rinaldi Media Editor: Denise Vaughn Full-Service Project Management: Tiffany Timmerman/S4Carlisle Publishing Services Composition: S4Carlisle Publishing Services Printer/Binder: Courier/Kendallville Cover Printer: Lehigh-Phoenix Color/Hagerstown Text Font: ITCCentury Book Credits and acknowledgments borrowed from other sources and reproduced, with permission, in this textbook appear on appropriate page within text. Microsoft® and Windows® are registered trademarks of the Microsoft Corporation in the U.S.A. and other countries. Screen shots and icons reprinted with permission from the Microsoft Corporation. This book is not sponsored or endorsed by or affiliated with the Microsoft...

Words: 179288 - Pages: 718

Premium Essay

Good

...AC14/AT11 Database Management Systems TYPICAL QUESTIONS & ANSWERS PART -I OBJECTIVE TYPE QUESTIONS Each Question carries 2 marks. Choosethe correct or the best alternative in the following: Q.1 Which of the following relational algebra operations do not require the participating tables to be union-compatible? (A) Union (B) Intersection (C) Difference (D) Join Ans: (D) Q.2 Which of the following is not a property of transactions? (A) Atomicity (B) Concurrency (C) Isolation (D) Durability Ans: (B) Q.3 Relational Algebra does not have (A) Selection operator. (C) Aggregation operators. (B) Projection operator. (D) Division operator. Ans: (C ) Q.4 Checkpoints are a part of (A) Recovery measures. (C ) Concurrency measures. (B) Security measures. (D) Authorization measures. Ans: (A) Q.5 Tree structures are used to store data in (A) Network model. (B) Relational model. (C) Hierarchical model. (D) File based system. Ans: (C ) Q.6 The language that requires a user to specify the data to be retrieved without specifying exactly how to get it is (A) Procedural DML. (B) Non-Procedural DML. (C) Procedural DDL. (D) Non-Procedural DDL. Ans: (B) Q.7 Precedence graphs help to find a 1 AC14/AT11 Database Management Systems (A) Serializable schedule. (C) Deadlock free schedule. (B) Recoverable schedule. (D) Cascadeless schedule. Ans: (A) Q.8 The rule that a value of a foreign key must appear...

Words: 20217 - Pages: 81

Premium Essay

Kkswmddkmdkemwekdemkedmkdemkmdkmdkew

...MODERN DATABASE MANAGEMENT / JfFFREY A. HOFFER . Warehousing Success 426 Data Warehouse Architectures 428 Generic Two-Level Architecture 428 Independent Data Mart Data Warehousing Environment 426 429 C O NTENTS Dependent Data Mart and Operational Data Store Architecture: A Three-Level Approach Logical Data Mart and Real-Time Data Warehouse Architecture 432 Three-Layer Data Architecture 435 Role of the Enterprise Data Model 435 Role of Metadata 436 Some Characteristics of Data Warehouse Data Status Versus Event Data 437 Transient Versus Periodic Data 438 An Example of Transient and Periodic Data 438 Transient Data 438 Periodic Data 439 Other Data VVarehouse Changes 440 The Reconciled Data Layer 441 Characteristics of Data after ETL 441 The ETL Process 442 Extract 442 Cleanse 444 Load and Index 446 Data Transformation 447 Data Transformation Functions 448 Record-Level Functions 448 Field-Level Functions 449 More Complex Transformations 451 Tools to Support Data Reconciliation 451 Data Quality Tools 451 Data Conversion Tools 452 Data Cleansing Tools 452 Selecting Tools 452 The Derived Data Layer 452 Characteristics of Derived Data 452 The Star Schema 453 Fact Tables and Dimension Tables 453 Example Star Schema 454 Surrogate Key 455 Grain of Fact Table 456 Duration of the Database 456 Size of the Fact Table 457 Modeling Date and Time 458 Variations of the Star Schema 458 Multiple Fact Tables 458 Factless Fact Tables...

Words: 80097 - Pages: 321

Premium Essay

Business

...Theory of Belief Functions Lili Sun Rutgers, The State University of New Jersey Rajendra P. Srivastava The University of Kansas and Theodore J. Mock University of Southern California and University of Maastricht Acknowledgements: We would like to thank the audit firm for making their audit work papers available for the study. We sincerely appreciate the help provided by the audit manager and for suggestions provided by Mike Ettredge, Greg Freix, Prakash Shenoy, and participants in AIS workshops at the University of Kansas and the 6th Annual INFORMS Conference on Information Systems and Technology. In addition, the authors would like to thank Drs. Jay F. Nunamaker, Jr., and Robert Briggs, Editor, Special Issue of JMIS, and the three anonymous reviewers for their constructive comments and valuable suggestions for revising the paper. 1 An Information Systems Security Risk Assessment Model under Dempster-Shafer Theory of Belief Functions ABSTRACT: This study develops an alternative methodology for the risk analysis of information systems security (ISS), an evidential reasoning approach under the Dempster-Shafer theory of belief functions. The approach has the following important dimensions. First, the evidential reasoning approach provides a rigorous, structured manner to incorporate relevant ISS risk factors, related counter measures and their interrelationships when estimating ISS risk. Secondly, the methodology employs the belief function definition of risk, that...

Words: 15140 - Pages: 61

Free Essay

Maglev

... Instructions : 1) Question Nos. 1 and 5 are compulsory. Out of the remaining attempt 2 questions from Section I and 2 questions from Section II. 2) Answers to the two Sections should be written in separate books. 3) Neat diagrams must be drawn wherever necessary. 4) Black figures to the right indicate full marks. 5) Use of Logarithmic Tables, Slide Rule, Mollier Charts, Electronic Pocket Calculator and Steam Tables is allowed. 6) Assume suitable data, if necessary. SECTION – I 1. What are different systems on a drilling rig ? Explain any one in detail with suitable diagramme. 18 2. a) Calculate Bottom hole pressure if well depth is 2500 m and mud weight is 1.2 gm/cc. b) Calculate mud weight if mud gradient is 0.87 psi/ft. ′ c) Calculate volume bbl/meter for drill pipe O.D. = 5′ inch and I.D. = 4.276 inch. 2 2 2 10 8 8 16 d) Draw circulation system on a drilling rig. 3. a) Discuss IADC classification of a bit in details. b) Discuss different factors affecting rate of penetration in details. 4. Write short note on : i) Coring ii) Fishing tools iii) BOP iv) Directional well P.T.O. [3963] – 103 -2- *3963103* SECTION – II 5. a) Discuss different types of casings and function of the casings in brief. b) Discuss different types of well completion techniques. 6. a) Discuss primary cementation process with suitable sketch. b) Discuss different perforation methods in brief. 7. a) What are different types of packer ? Discuss any one in brief. b) Draw well head assembly...

Words: 172166 - Pages: 689

Premium Essay

Positioning

...Rafiq Khan Long Zhang School of Engineering Blekinge Institute of Technology Box 520 SE – 372 25 Ronneby Sweden This thesis is submitted to the School of Engineering at Blekinge Institute of Technology in partial fulfillment of the requirements for the degree of Master of Science in Software Engineering. The thesis is equivalent to 2*20 weeks of full time studies. Contact Information: Author(s): Adnan Rafiq Khan Address: Folkparksvagen 1905, 37240 Ronneby, Sweden. E-mail: adnanrafiqkhan@gmail.com Long Zhang Address: Villa Flora 951, 37236 Ronneby, Sweden. E-mail: zhl10154@gmail.com University advisor(s): Conny Johansson (Head of Department, Department of Systems and Software Engineering) School of Engineering Blekinge Institute of Technology Box 520 SE – 372 25 Ronneby Sweden Internet Phone Fax : www.bth.se/tek : +46 457 38 50 00 : + 46 457 271 25 ii ACKNOWLEDGEMENT First of all we thank our supervisor, Conny Johansson, for continuously providing the support, encouragement and motivation during the thesis. His advices, suggestions and feedbacks were really helpful and made this effort an enjoyable one. We are thankful to our faculty reviewer Dr. Robert Feldt. His feedbacks and comments were very useful to design this thesis. We would like to thanks Mr. Kai Xiao, a student at BTH, for introducing us to Miss. Cong Lou for help in this thesis. We are very much thankful to Miss. Cong Lou, a Green Belt in Six Sigma and working in China. She was very...

Words: 32055 - Pages: 129

Premium Essay

Managing Change

...Iles and Kim Sutherland Contents Purpose and Acknowledgements Foreword 5 7 8 Introduction Part 1 The literature on change management Part 2 Tools, models and approaches: a selective review 1.1 1.2 1.3 1.4 Where does the literature come from? What kind of evidence does it provide? What is meant by ‘change’? Organisational change in the NHS 12 13 14 18 2.1 How to access the models 2.2 How can we understand complexity, interdependence and fragmentation? Weisbord’s Six-Box Organisational Model 7S Model PESTELI Five Whys Content, Context and Process Model Soft Systems Methodology Process modelling Process flow Influence diagram Theory of Constraints (TOC) 22 25 25 27 29 30 32 34 36 37 38 39 40 40 42 43 45 46 47 48 48 50 54 54 55 56 56 58 2.3 Why do we need to change? SWOT analysis 2.4 Who and what can change? Force field analysis ‘Sources and potency of forces’ ‘Readiness and capability’ Commitment, enrolment and compliance Organisation-level change interventions Total Quality Management (TQM) Business Process Reengineering (BPR) Group-level change interventions Parallel learning structures Self-managed teams Individual-level change interventions Innovation research Securing individual behaviour change Managing Change in the NHS 2.5 How can we make change happen? Organisational development (OD) Organisational learning and the Learning Organisation Action research Project management 60 60 63 66 68 Part 3 Reflections on evidence 3.1 3.2...

Words: 33529 - Pages: 135

Premium Essay

Accounting Information Systems: Course Objectives, Description, Topics, and Assignments

...record keeping happen as expected. E-business Web sites handle transactions automatically, with the accounting data going directly into the necessary databases. The concept of a paper trail has become a bit of a misnomer; today, because of accounting information systems, there is often no paper involved at all; however, it is important to establish the flow the data in different areas of the organization, or audit trail, so as to properly exercise internal controls. AISs help in this purpose. At the outset of this course, you will learn the basics of accounting information systems and business processes. Next, you will learn about database management systems, and the design of various database models. Finally, you will learn about how to use internal controls effectively for risk management, as well as the requirements for business reporting. After completing this course, you should not only have a clear idea of how accounting information systems work, but you should also be prepared to design and configure them to meet the record-keeping and risk management requirements of the organization. In addition, you will be prepared to design them to meet legal obligations—such as those defined in the United States’ Sarbanes-Oxley Act of 2002—as well as ethical obligations. LEARNING OUTCOMES: A. Develop a conceptual knowledge of the nature and functionality of an accounting information system and systems in general (Module 1). B. Explain how an accounting system captures business...

Words: 6838 - Pages: 28

Premium Essay

The Six Sigma Handbook

...United States Copyright Act of 1976, no part of this publication may be reproduced or distributed in any form or by any means, or stored in a database or retrieval system, without the prior written permission of the publisher. 0-07-141596-3 The material in this eBook also appears in the print version of this title: 0-07-141015-5. All trademarks are trademarks of their respective owners. Rather than put a trademark symbol after every occurrence of a trademarked name, we use names in an editorial fashion only, and to the benefit of the trademark owner, with no intention of infringement of the trademark. Where such designations appear in this book, they have been printed with initial caps. McGraw-Hill eBooks are available at special quantity discounts to use as premiums and sales promotions, or for use in corporate training programs. For more information, please contact George Hoare, Special Sales, at george_hoare@mcgraw-hill.com or (212) 904-4069. TERMS OF USE This is a copyrighted work and The McGraw-Hill Companies, Inc. (“McGraw-Hill”) and its licensors reserve all rights in and to the work. Use of this work is subject to these terms. Except as permitted under the Copyright Act of 1976 and the right to store and retrieve one copy of the work, you may not decompile, disassemble, reverse engineer, reproduce, modify, create derivative works based upon, transmit, distribute, disseminate, sell, publish or sublicense the work or any part of it without...

Words: 236475 - Pages: 946

Premium Essay

Database Management System

...Marketing Coordinator: Suellen Ruttkay Content Product Manager: Matthew Hutchinson Senior Art Director: Stacy Jenkins Shirley Cover Designer: Itzhack Shelomi Cover Image: iStock Images Media Editor: Chris Valentine Manufacturing Coordinator: Julio Esperas Copyeditor: Andrea Schein Proofreader: Foxxe Editorial Indexer: Elizabeth Cunningham Composition: GEX Publishing Services © 2011 Cengage Learning ALL RIGHTS RESERVED. No part of this work covered by the copyright herein may be reproduced, transmitted, stored or used in any form or by any means graphic, electronic, or mechanical, including but not limited to photocopying, recording, scanning, digitizing, taping, Web distribution, information networks, or information storage and retrieval systems, except as permitted under Section 107 or 108 of the 1976 United States Copyright Act, without the prior written permission of the publisher. For product information and technology assistance, contact us at Cengage Learning Customer & Sales Support, 1-800-354-9706 For permission to use material from this text or product, submit all requests online at www.cengage.com/permissions Further permissions...

Words: 189848 - Pages: 760