Premium Essay

Systems Analysis and Design 9th Chapter 9

In:

Submitted By tilk999
Words 1096
Pages 5
-------------------------------------------------

1. Explain the main difference between a file-oriented system and a database system.

A file-oriented system utilizes data in a regular OS file based format where a database system uses a database engine that organizes data in a database in a table format utilizing rows for each record.

2. What is a DBMS? Briefly describe the components of a DBMS.

DBMS stands for Database Management System. A DBMS is a collection of tools, features, and interfaces that enables users to add, update, manage, access, and analyze the contents of a database.

A DBMS is made up of a DML (data manipulation language), Schema and subschemas, Physical data repository, and an Interface to allow access to the database from DBA’s, Users, and Related Information Systems.

3. Describe a primary key, candidate key, secondary key, foreign key, and common field.

Primary Key – a field or combination of fields that uniquely and minimally identifies an entity. Candidate Key – Any field or combination of fields that can act as the primary key but are not. Secondary Key – Any field of combination of fields that can be use to identify a entity. Foreign Key – A field that exists in an entity that is the PK of another entity. Common Field – An attribute (field) that appears in more than one entity (record).

4. What are entity-relationship diagrams and how are they used? What symbol is used to represent and entity in an ERD? What symbol is used for a relationship? What is cardinality, and what symbols do you use in the crow’s foot notation method?

An ERD graphically displays the relationship between two or more entities.

The symbol used to represent an entity is a rectangle and the relationship symbol is a diamond.

Cardinality describes the relationship between entities.

Crow’s foot notation is used to

Similar Documents

Premium Essay

It460 Unit 9 Assignment

...Denise Figueroa IT460 System Analysis and Design Professor Heith Hennel Unit 9 Assignment October 27, 2015 We will be creating a test plan for the SCR TIMS project that will use only the related items of the SCR TIMS network. This plan will address the testing strategies and all the quality requirements. There will be a testing plan that will exist of four different levels. These different levels will include the System, Acceptance, Unit and Integration. We will start off with the test items that will be included: • Server Machine • Network Communication • Disk Arrays • Client Machines 1. Executives 2. Administrators 3. Project Managers 4. Systems 5. Business Solutions Network • Firewalls • Printers • Faxes • Scanners Our...

Words: 626 - Pages: 3

Free Essay

Accounting

...Click here to download the solutions manual / test bank INSTANTLY!! http://testbanksolutionsmanual.blogspot.com/2011/02/accounting-information-systems-romney.html ------------------------------------------------------------------------------------------------------------------------ Accounting Information Systems Romney 11th Edition Solutions Manual Accounting Information Systems Romney 11th Edition Solutions Manual Accounting Information Systems Romney 11th Edition Solutions Manual Accounting Information Systems Romney Steinbart 11th Edition Solutions Manual Accounting Information Systems Romney Steinbart 11th Edition Solutions Manual ------------------------------------------------------------------------------------------------------------------------ ***THIS IS NOT THE ACTUAL BOOK. YOU ARE BUYING the Solution Manual in e-version of the following book*** Name: Accounting Information Systems Author: Romney Steinbart Edition: 11th ISBN-10: 0136015182 Type: Solutions Manual - The file contains solutions and questions to all chapters and all questions. All the files are carefully checked and accuracy is ensured. - The file is either in .doc, .pdf, excel, or zipped in the package and can easily be read on PCs and Macs.  - Delivery is INSTANT. You can download the files IMMEDIATELY once payment is done. If you have any questions, please feel free to contact us. Our response is the fastest. All questions will always be answered in 6...

Words: 18533 - Pages: 75

Free Essay

Dr Manger

...Organizational Theory, Design, and Change Jones 6th Edition Test Bank Click here to download the solutions manual / test bank INSTANTLY!!! http://solutionsmanualtestbanks.blogspot.com/2011/10/organizational-theory-d esign-and-change_18.html ----------------------------------------------------------------------Organizational Organizational Organizational Organizational Theory, Theory, Theory, Theory, Design, Design, Design, Design, and and and and Change Change Change Change Jones Jones Jones Jones 6th 6th 6th 6th Edition Edition Edition Edition Test Test Test Test Bank Bank Bank Bank -------------------------------------------------------------------------***THIS IS NOT THE ACTUAL BOOK. YOU ARE BUYING the Test Bank in e-version of the following book*** Name: Organizational Theory, Design, and Change Author: Jones Edition: 6th ISBN-10: 0136087310 Type: Test Bank - The test bank is what most professors use an a reference when making exams for their students, which means there’s a very high chance that you will see a very similar, if not exact the exact, question in the test! - The file is either in .doc, .pdf, excel, or zipped in the package and can easily be read on PCs and Macs. - Delivery is INSTANT. You can download the files IMMEDIATELY once payment is done. If you have any questions, please feel free to contact us. Our response is the fastest. All questions will always be answered in 6 hours. This is the quality of service we are providing and we hope to be your...

Words: 29834 - Pages: 120

Premium Essay

Www.Tempaperwarehouse.Com/Essay-on/Five-Forces-Analysis-of-the-Video/111414-Five Forces Analysis of the Video Game Industry

... | |Seminar Class Details: | |Name of Seminar Tutor: | |Day: | |Time: | |Room: | Lectures: Tuesday from 6:30 - 9:30 PM in KV Block 17, Room 009 MKT4100 Strategic Marketing Management 1. WELCOME 2 2. CONTACT DETAILS 2 3. AIMS OF THE MODULE 3 4. LEARNING OUTCOMES 3 4.1 Knowledge 3 4.2 Skills 3 5. SYLLABUS 4 6. LEARNING METHODS 4 7. LEARNING MATERIALS & SUGGESTED TEXTS 5 ESSENTIAL/CORE TEXT 5...

Words: 5537 - Pages: 23

Premium Essay

Isya

...Assignments for Information Systems II: module A - 2012 Assignments are based on the Chapter Capstone Case: Softwear, Limited case study at the end of each chapter of the prescribed textbook, (Analysis and Design for Systems 9th edition, 2012, by GN Shelly and HJ Rosenblatt.). All assignments * Are group assignments. Students choose their own groups. Groups must have between 3 and 5 members. * Be presented as a report. * Have a front page, listing all group member names in alphabetical order of the surnames. Include the student number as well. If you move to another class or group, you must inform all lecturers involved. Assignment marks will not be corrected at the end of the year. Chapter 1 1. Write an employment advertisement for a new systems analyst position at SWL. Consider the business profile choice of SWL when you write the advertisement. 2. Give at least two places where you will advertise this position. Give reason(s) for your choice. Why do you think it will attract the right person? What will be the cost of the advertisement? Provide, in an appendix, the published rates for advertisements where the advertisement will be placed. Advert: Systems Analyst Short job description/Purpose of job | (2) | | Qualifications | (2) | | Experience required | (3) | | Key performance areas / Job description | (5) | | Salary range | (1) | | Contact | (2) | | Other | (5) | | | (20) | | Advertisement details (Remember it...

Words: 1015 - Pages: 5

Premium Essay

Porters Five Forces

...Assignments for Information Systems II: module A - 2012 Assignments are based on the Chapter Capstone Case: Softwear, Limited case study at the end of each chapter of the prescribed textbook, (Analysis and Design for Systems 9th edition, 2012, by GN Shelly and HJ Rosenblatt.). All assignments * Are group assignments. Students choose their own groups. Groups must have between 3 and 5 members. * Be presented as a report. * Have a front page, listing all group member names in alphabetical order of the surnames. Include the student number as well. If you move to another class or group, you must inform all lecturers involved. Assignment marks will not be corrected at the end of the year. Chapter 1 1. Write an employment advertisement for a new systems analyst position at SWL. Consider the business profile choice of SWL when you write the advertisement. 2. Give at least two places where you will advertise this position. Give reason(s) for your choice. Why do you think it will attract the right person? What will be the cost of the advertisement? Provide, in an appendix, the published rates for advertisements where the advertisement will be placed. Advert: Systems Analyst Short job description/Purpose of job | (2) | | Qualifications | (2) | | Experience required | (3) | | Key performance areas / Job description | (5) | | Salary range | (1) | | Contact | (2) | | Other | (5) | | | (20) | | Advertisement details (Remember it...

Words: 1015 - Pages: 5

Free Essay

Mgmt E 4000 Organizational Behavior Syllabus

...Harvard University Fall 2014 MGMT E-4000: Organizational Behavior – Tuesday: 5:30 - 7:30 PM Online – Live Web conferencing/Hybrid (Weekend Required) Dr. Carmine P. Gibaldi Telephone: (718) 990-7446 Fax: (516) 944-4005 E-mail: cgibaldi@fas.harvard.edu Appointments: By appointment via the web, telephone, and in person COURSE DESCRIPTION This course deals with human behavior in organizations and with practices and systems with in organizations that facilitate or hinder effective behavior. Conceptual frameworks, case discussions, and skill-oriented activities are blended within each topic. Topics include communication, motivation, group dynamics, leadership, power, and organizational design and development. Class sessions and assignments are intended to help participants acquire the skills that managers need to improve organizational relationships and performance. COURSE OBJECTIVES This course aims to improve ones understanding of human behavior in organizations and ones ability to lead people to achieve more effectively and how to increase organizational performance. Readings are assigned to give the student a clear understanding of the specific material. Cases are assigned to afford the student the opportunity to apply the theory, and put it into practice. Students will be expected to explore and reflect on their own experiences in the work place, and discuss ways in which they might apply the material to their daily...

Words: 828 - Pages: 4

Premium Essay

Mba 501 Syllabus

...Ashland University Organization Design, Development, and Change Management MBA 501 (Hybrid/Classroom & Online) Dauch Room 243 Fall 2015 Professor: Pat Berry, (MAOL), Adjunct Professor E-mail: Office Hours: Available via email, text, or phone, (330-336-4646) Credit hours: 3 Class meeting times: Face to face meetings will be September 14, 28, October 12, 26, November 9, 23. The alternating sessions after week September 14th, will be offered online via BlackBoard. Prerequisites: MBA Foundations class or equivalent Course Materials: Organization Development & Change, Thomas G. Cummings and Christopher G. Worley, 10th edition, (note the 9th edition is not the same). Course Description: This course explores the theories and concepts managers can apply, on their own or in collaboration with an OD consultant, to drive effective change management initiatives within their departments or organizations. The course examines how to create and enact positive change in business at the systems level by understanding the elements of organizational design as well as theories and models pertinent to organizational change. The course focuses on large-scale OD interventions as well as strategies and tactics managers can employ to plan, enact and monitor change within their spheres of influence. Topics covered in the course include: understanding the fundamentals of organizational design; systems thinking and its impact on the change process; defining OD and the...

Words: 2183 - Pages: 9

Premium Essay

Capstone

...Reference Books Sr No R-1 R-2 Other Reading Sr No OR-1 OR-2 OR-3 OR-4 OR-5 OR-6 OR-7 OR-8 OR-9 OR-10 OR-11 OR-12 Journals articles as Compulsary reading (specific articles, complete reference) The four things that a service Business must get right HBR Article , Bang & Olufsen Design Driven Innovation : HBR , Smart Product Design : HBR , Mishina, Kazuhiro. Toyota Motor Manufacturing, U.S.A., Inc. HBS Case No. 9-693-019. Harvard Business School Publishing, Boston, 1995. , Hammond, Janice H. Barilla SpA (A). HBS Case No. 9-694-046. Harvard Business School Publishing, Boston, 1994. , Latour, Almar. Nokia Handles Supply Shock with Aplomb as Ericsson of Sweden Gets Burned. The Wall Street Journal. Dow Jones & Company, Inc., 2001. , National Cranberry Cooperative HBS #688122. From Case Map , John Crane UK Ltd Case : The CAD CAM Link . HBS #691021,24p , To Move or not to Move .Case of Cathay Pacific Airways . University of Hong Kong HBS #HKU003,22p , Note on Quality: The Views of Deming, Juran, and Crosby HBS .687011 , Process Control at Polaroid , HBS, #693047 , LL Bean Item Forecasting and Inventory Management HBS, #893003, 5p , Johson Control Automotive Systems , HBS,#69308623p , Title Operations Management Concepts, Techniques & Applications Operations Management Author Evans & Collier Edition 1st Year Publisher Name Cengage Learning Tata McGraw Hill Author Norman Gaither,Greg Frazier Edition 9th Year Publisher Name Cengage Learning William Stevenson Taylor 8th Relevant Websites...

Words: 3895 - Pages: 16

Premium Essay

Good

......................................................... 3 1.1 Contacting the module tutor. .................................................................... 3 1.2 Classes ………………………. .................................................................. 3 2 OVERVIEW OF THE MODULE ...................................................................... 4 3 ASSESSMENT…………................................................................................. 6 4 LEARNING MATERIALS................................................................................ 6 5 SCHEDULE OUTLINE.................................................................................... 8 6 MODULE GRADING SYSTEM...................................................................... 10 6.1 Re-assessment…………………………………………………………..…. 11 6.2 Deferral of assessment……………………………………………………. 11 7 MODULE ATTENDANCE AND REGULATIONS........................................... 12 8 ACADEMIC MISCONDUCT AND PLAGIARISM… ....................................... 13 1 MODULE SUMMARY 1.1 Contacting the module tutor You can contact the module tutor in the following ways: Contact details Email: aspasiasim@gmail.com Phone / fax: 22525354 1.2 Classes | |Room |Duration |Time...

Words: 2440 - Pages: 10

Premium Essay

Marketing

...Module Study Guide Information and Communication Technology The Claude Littner Business School The Claude Littner Business School Information and Communication Technology Module Study Guide |Module Code |BA40019E | |Level |4 | |Credits |20 | AY2014-2015 Version No 1 © UWL 2014 Location/Paragon Information and Communication Technology Module Study Guide |Contents |Page No. | |Module Leader and Teaching Team Details…………………… 4 | | | | | |Facts and figures | | | | | |Section A Overview and Content | | |1 Welcome and Introduction to the Module………6 ...

Words: 4674 - Pages: 19

Premium Essay

Obmp Case Studies

...ORGANIZATIONAL BEHAVIOR 9th edition by Stephen P. Robbins San Diego State University Prentice Hall International, Inc. "... the number-one-selling organizational behavior (OB) textbook in the United States and worldwide. More than 700.000 students around the globe have studied OB from this text" (preface, XXIII). Part One – Introduction Chapter 1 What is Organizational Behavior? Part Two – The Individual Chapter 2 Foundations of Individual Behavior Chapter 3 Values, Attitudes, and Job Satisfaction Chapter 4 Personality and Emotions Chapter 5 Perception and Individual Decision Making Chapter 6 Basic Motivation Concepts Chapter 7 Motivation: From Concept to Applications Part Three – The Group Chapter 8 Foundations of Group Behavior Chapter 9 Understanding Work Teams Chapter 10 Communication Chapter 11 Leadership and Trust Chapter 12 Power and Politics Chapter 13 Conflict and Negotiation Part Four – The Organization System Chapter 14 Foundations of Organization Structure Chapter 15 Work Design and Technology Chapter 16 Human Resource Policies and Practices Chapter 17 Organizational Culture Part Five – Organizational Dynamics Chapter 18 Organizational Change and Stress Management CHAPTER 1 WHAT IS ORGANIZATIONAL BEHAVIOR "We have come to understand that technical skills are necessary but insufficient for succeeding in management. In today's increasingly competitive and demanding workplace, managers can't succeed on their technical skills alone. They also have to have...

Words: 2066 - Pages: 9

Premium Essay

Operations Management

...CHAPTER 1: Executive Summary 4 CHAPTER 2: Company Overview 5 CHAPTER 3: Operation Management an Introduction at ETA 6 3.1 Managing the 5Ps 6 3.1.1 Concept of 5Ps In Operation Management 6 3.1.2 Managing the 5Ps of Operation Management by ETA 7 3.2 Transformation Process 8 3.2.1 Concept of Transformation Process 8 3.2.2 Practice Of Transformation Process In ETA 9 3.2.3 Implication & Analysis On Transformation Process in ETA 9 3.3 Vs Of Operations 11 3.3.1 Concept Of 4Vs in Operations 11 3.3.2 Implications of 4Vs in ETA 12 CHAPTER 4: Process Design 13 4.1 Concept of Process Design 13 4.2 Process Design In ETA 14 4.2.1 Production Process Involved 14 4.2.2 Production Strategies Involved 15 4.3 Implication and Analysis of Process Design in ETA 15 CHAPTER 5: Plant Layout 17 5.1 Concept Of Plant Layout 17 5.2 Plant Layout Used In ETA 17 5.2.1 Cellular Layout 18 5.2.2 Process or Functional Layout 18 5.3 Implications And Analysis of Plant Layout in ETA 18 CHAPTER 6: Capacity Management 19 6.1 Concept Of Capacity Management 19 5.2 Capacity Management In ETA 20 5.3 Implication And Analysis of Capacity Management In ETA 20 CHAPTER 7: Conclusion 21 Reference 22 CHAPTER 1: Executive Summary CHAPTER 2: Company Overview Operation management involves the management of the systems and process that are required to create the goods and/or services. Stevenson (2007) stated that operation management is the management...

Words: 3476 - Pages: 14

Free Essay

Swort Analysis

...Copy and Paste the link below to download IMMEDIATELY!!! http://solutionsmanualtestbanks.blogspot.com/2011/10/accounting-principles-weygandt-9th.html Accounting Principles Weygandt Kieso Kimmel 9th Edition Solutions Manual -------------------------------------------------------------------------- Name: Accounting Principles Author: Weygandt Kieso Kimmel Edition: 9th ISBN-10: 047031754X Type: Solutions Manual - The file contains solutions and questions to all chapters and all questions. All the files are carefully checked and accuracy is ensured. - The file is either in .doc, .pdf, excel, or zipped in the package and can easily be read on PCs and Macs.  - Delivery is INSTANT. You can download the files IMMEDIATELY once payment is done. If you have any questions, please feel free to contact us. Our response is the fastest. All questions will always be answered in 6 hours.  This is the quality of service we are providing and we hope to be your helper.  Delivery is in the next moment. Solution Manual is accurate. Buy now below and the DOWNLOAD LINK WILL APPEAR IMMEDIATELY once payment is done!  Prepare to receive your Accounting Principles Solution Manual in the next moment. -------------------------------------- Accounting Principles Solution Manual Here’s a sample list of all other solutions manuals we have, if you need any one of them please contact us at solutionsmanualzone@gmail.com -A Transition to Advanced Mathematics by Douglas Smith,...

Words: 9465 - Pages: 38

Premium Essay

Swatch the Birth of

...S1873083 Table of contents 1. Introduction p. 1 1.1 Abstract p. 1 1.2 Introduction to the company p. 1 2. Analysis of the company and its market p. 2 2.1 Market p. 2 2.2 Performance analysis p. 2 2.3 Product adaptation p. 4 3. Environmental analysis p. 4 3.1 External environmental analysis p. 4 3.2 PEST-analysis p. 4 3.3 Opportunities and threats p. 5 3.4 Internal environmental analysis p. 6 3.5 Strengths and weaknesses p. 6 4. Marketing analysis p. 8 4.1 Segmentation p. 8 4.2 Targeting p. 9 4.3 Positioning p. 9 4.4 Product strategy p. 9 4.5 Promotion strategy p. 10 4.6 Market entry, pricing and distribution p. 11 5. Conclusion p. 12 Bibliography p. 12 Appendix 1. Introduction 1.1. Abstract This report will be centred around the watch manufacturing branch of Swatch. Swatch has been highly successful throughout its existence and therefore it is particularly interesting to know how they achieved this considerable success. The main purpose of this report is to analyze the company of Swatch from a marketing perspective. This analysis is based on the theories from the books Essentials of Global Marketing by Svend Hollensen(2008) and Principles of Marketing written by Philip Kotler and Gerry Armstrong(2006). Additional research was conducted throughout the internet. Each chapter involves different theories and relates it to the company. Rather than focussing on a high quantity of theories the report...

Words: 6775 - Pages: 28