Premium Essay

System Design Chapter 7 Answers

In: Computers and Technology

Submitted By sundevilgary
Words 1736
Pages 7
CHAPTER 7

3. Write the query that will generate a combined list of customers (from tables CUSTOMER and CUSTOMER_2) that do not include the duplicate customer records. (Note that only the customer named Juan Ortega shows up in both customer tables.)

SELECT CUST_LNAME, CUST_FNAME FROM CUSTOMER UNION SELECT CUST_LNAME, CUST_FNAME FROM CUSTOMER_2;

4. Write the query that will generate a combined list of customers to include the duplicate customer records.

SELECT CUST_LNAME, CUST_FNAME FROM CUSTOMER UNION ALL SELECT CUST_LNAME, CUST_FNAME FROM CUSTOMER_2;

5. Write the query that will show only the duplicate customer records.

We have shown both Oracle and MS Access query formats:

Oracle

SELECT CUST_LNAME, CUST_FNAME FROM CUSTOMER INTERSECT SELECT CUST_LNAME, CUST_FNAME FROM CUSTOMER_2;

MS Access

SELECT C.CUST_LNAME, C.CUST_FNAME FROM CUSTOMER AS C, CUSTOMER_2 AS C2 WHERE C.CUST_LNAME=C2.CUST_LNAME AND C.CUST_FNAME=C2.CUST_FNAME;

Because Access doesn’t support the INTERSECT SQL operator, you need to list only the rows in which all the attributes match.

6. Write the query that will generate only the records that are unique to the CUSTOMER_2 table.

We have shown both Oracle and MS Access query formats:

Oracle

SELECT CUST_LNAME, CUST_FNAME FROM CUSTOMER_2 MINUS SELECT CUST_LNAME, CUST_FNAME FROM CUSTOMER;

MS Access

SELECT C2.CUST_LNAME, C2.CUST_FNAME FROM CUSTOMER_2 AS C2 WHERE C2.CUST_LNAME + C2.CUST_FNAME NOT IN (SELECT C1.CUST_LNAME + C1.CUST_FNAME FROM CUSTOMER C1);

Because Access doesn’t support the MINUS SQL operator, you need to list only the rows that are in CUSTOMER_2 that do not have a matching row in CUSTOMER.

7. Write the query to show the invoice number, the customer number, the

Similar Documents

Premium Essay

Example

...International American University Shaping tomorrow’s leaders today! General Course Policies supplement this syllabus and are available through IAU Online as a digital soft copy. Please make sure that you review the General Course Policies so that you can be successful in this course. 4201 Wilshire Blvd., Suite #610 ♦ Los Angeles, CA 90010, CA, U.S.A. ♦ T: (323) 938-4428 ♦ F: (323) 938-4-4429 ♦ E: www.iau.la MGT 620a Operations Management & Supply Chain Syllabus Class Details Name: Email: Phone: Room: Method: Steve B. Young, Ph.D. (A.B.D.) syoung18@verizon.net (818) 360-6115 LA-Classroom C Hybrid Term/Year: Days: Time: Start Date: End Date: Spring Session 1 / 2015 Wednesdays 6:00pm-10:00pm January 05, 2015 February 27, 2015 Instructor’s Biography Steve Young graduated from Western Michigan University with a Bachelor of Science in Engineering and Business. He spent time as an HR director and consultant with many Aerospace firms. Steve has worked in numerous management positions for Boeing, Lockheed Martin, Eco Polymers, Hughes, and PM-10 Consultants specializing in the area of Human resource, business management, and business operations. Steve received his MBA from West Coast University with an emphasis in management and is looking to receive his PhD from Walden University in Applied Management and Decision Making with specializations in Organizational Change and Leadership in 2008. Steve is a senior faculty member and has been teaching for the University of Phoenix...

Words: 4036 - Pages: 17

Free Essay

2013 Aff 2851

...Department of Accounting and Finance EXAM CODES: AFF2851 TITLE OF PAPER: ACCOUNTING INFORMATION SYSTEMS & FINANCIAL MODELLING EXAM DURATION: 3 hours READING TIME: 10 minutes THIS PAPER IS FOR STUDENTS STUDYING AT: (office use only - tick where applicable)  Berwick  Clayton  Peninsula  Distance Education  Other (specify)  Caulfield Gippsland  Sunway  Open Learning During an exam, you must not have in your possession a book, notes, paper, calculator, pencil case, mobile phone or other material/item which has not been authorised for the exam or specifically permitted as noted below. Any material or item on your desk, chair or person will be deemed to be in your possession. You are reminded that possession of unauthorised materials in an exam is a disciplinable offence under Monash Statute 4.1. AUTHORISED MATERIALS CALCULATORS  YES  NO (If YES, only calculators with an 'approved for use' Faculty label are permitted) OPEN BOOK  YES  NO SPECIFICALLY PERMITTED ITEMS  YES  NO if yes, items permitted are: This paper consists of two (2) parts printed on a total offourteen (14) pages, plus a multiple choice answer sheet. Part A has twenty (20) multiple choice questions. The answers to Part A should be entered on the multiple choice answer sheet provided. Part B has four (4)sets of written answer questions. Students must attempt to answer ALL questions. STUDENT ID: …………………………... DESK NUMBER: ……………………. PLEASE CHECK THE...

Words: 1037 - Pages: 5

Premium Essay

Drew

...Syllabus NT2799 Network Systems Administration Capstone Project SYLLABUS Credit hours: 4.5 Contact hours: 56 (34 Theory, 22 Lab) Prerequisite(s): Completion of a minimum of 72 credits earned in the program of study including NT2640 IP Networking or equivalent. © ITT Educational Services, Inc. All Rights Reserved. -1- 13/01/2013 Network Systems Administration Capstone Project SYLLABUS COURSE SUMMARY COURSE DESCRIPTION This course provides an opportunity for students to work on a comprehensive project that includes the design, planning and implementation of a network solution for solving specific business problems. Common project management processes are applied to identify deliverables and outcomes of the project. MAJOR INSTRUCTIONAL AREAS 1. Project Management Techniques 2. A Fundamental Review of the Basics of Electronics in the AASNSA Program 3. Capstone Project 4. Research of Current and Emerging Technology COURSE OBJECTIVES 1. Apply important concepts of project management to the actual capstone project proposed for this course. 2. Use Microsoft Office Project to help plan and manage the actual capstone project. 3. Analyze the requirements for the capstone project. 4. Integrate and apply the knowledge acquired in the program to provide effective technological solutions for given problems. 5. Work in teams on a large-scope project. 6. Document solutions to a problem in detail...

Words: 7871 - Pages: 32

Free Essay

Bank Robbery Usa

...____________________________________________________________ ______________________ Copyright © 2007 by Pearson Education, Inc., Upper Saddle River, New Jersey 07458. Pearson Prentice Hall. All rights reserved. Printed in the United States of America. This publication is protected by Copyright and permission should be obtained from the publisher prior to any prohibited reproduction, storage in a retrieval system, or transmission in any form or by any means, electronic, mechanical, photocopying, recording, or likewise. For information regarding permission(s), write to: Rights and Permissions Department. Pearson Prentice Hall™ is a trademark of Pearson Education, Inc. Pearson® is a registered trademark of Pearson plc Prentice Hall® is a registered trademark of Pearson Education, Inc. Merrill® is a registered trademark of Pearson Education, Inc. Instructors of classes using Cooper, Heron, and Heward, Applied Behavior Analysis, Second Edition, may reproduce material from the instructor’s manual with test items for classroom use. 10. 9 8 7 6 5 4 3 2 1 [pic] ISBN-13:...

Words: 75129 - Pages: 301

Free Essay

Dbms Class

...Preface 1 Chapter 1 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...

Words: 41091 - Pages: 165

Premium Essay

Essay

...Homework Chapter 1 The Revolution Is Just Beginning 1) The term e-business refers to the digital enabling of transactions and processes involving an exchange of value across organizational boundaries. Answer: FALSE 2) Price discovery refers to the ability of merchants to segment the market into groups willing to pay different prices. Answer: FALSE 3) Personalization involves targeting marketing messages to specific individuals by adjusting the message based upon a consumer's preferences or past purchasing behavior. Answer: TRUE 4) The online marketplace is characterized by persistent price dispersion. Answer: TRUE 5) The future of e-commerce is likely to include a decrease in government regulation both in the United States and worldwide. Answer: FALSE 6) Which of the following statements about e-commerce in the United States in 2014 is not true? D) Growth rates for retail e-commerce are higher in the United States than in China. 7) In 2014, roughly ________ million people in the United States accessed the Internet via tablets. C) 147 8) Which of the following is not a major business trend in e-commerce in 2014-2015? B) Small businesses and entrepreneurs are hampered by the rising cost of market entry caused by increased presence of industry giants. 9) All of the following are major social trends in e-commerce in 2014-2015 except for: C) the refusal of online retailers to accept taxation of Internet sales. 10) Which of the following...

Words: 3335 - Pages: 14

Free Essay

Ops Quiz

...CHAPTER 6 | 1 CORRECT | | A process is said to be in control when all the variation that is noticed can be assigned to specific causes. | | | A) | True | | | B) | False | | | | | | | | 2 CORRECT | | 'GAPS' refer to differences in perceptions, expectations, goals and understanding among management, employees and customers. | | | A) | True | | | B) | False | | | | | | | | 3 INCORRECT | | A walk-through audit is a service delivery process-oriented survey given to customers and mangers to evaluate the perception of the customer experience. | | | A) | True | | | B) | False | | | | | | | | 4 INCORRECT | | Quality function deployment is a service design tool to translate customer expectations into measurable conformance specifications. | | | A) | True | | | B) | False | | | | | | | | 5 CORRECT | | According to customers, __________ is the most important dimension of service quality? | | | A) | prompt service | | | B) | courtesy of employees | | | C) | the attractiveness of the service facility | | | D) | the dependability and accuracy of the service | | | | | | | | 6 INCORRECT | | Companies often "manage the evidence". For example, a motel will place a plastic liner on the toilet seat to show that it has been cleaned. Which 'GAP' is this activity attempting to close? | | | A) | GAP 5: difference between what customers expect and what they...

Words: 1785 - Pages: 8

Premium Essay

Operation Management

...because every service and product that you use – the cereal you eat at breakfast, the chair you sit on, and the radio station you listen to while you eat – is the result of an operation or process. Our aim in writing Operations Management is to give you a comprehensive understanding of the issues and techniques of operations management, and to help you get a great final result in your course. Here’s how you might make the most of the text: ● Get ahead with the latest developments – from the up-to-the-minute Operations in practice features in every chapter to the focus on corporate social responsibility in the final chapter – these put you at the cutting edge. ● Use the Worked examples and Problems and applications to improve your use of key quantitative and qualitative techniques, and work your way to better grades in your assignments and exams. ● Follow up on the recommended readings at the end of each chapter. They’re specially selected to enhance your learning and give you an edge in your course work. And in particular, look out for the references to MyOMLab in the text, and log on to www.myomlab.com* where you can ● check and reinforce your understanding of key concepts using self-assessment questions, audio summaries, animations video clips and more; ● practice your problem-solving with feedback, guided solutions and a limitless supply of questions! We want...

Words: 12297 - Pages: 50

Premium Essay

Operation Management

...Chapter Solutions Operations Management.pdf DOWNLOAD HERE CHAPTER 12: INVENTORY MANAGEMENT – Suggested Solutions to ... http://users.ipfw.edu/khamaljn/P301/Class_Notes/Solutions-Chapter12.pdf 1 BUS P301:01 CHAPTER 12: INVENTORY MANAGEMENT – Suggested Solutions to Selected Questions Summer II, 2009 Question 12.5 This is EOQ with D = 19,500 units/yr; H = $ ... CHAPTER 11 Operations Management http://www.eng.uwi.tt/depts/mech/ugrad/courses/meng3006/Week09b.pdf Operations Management, ... • To decouple operations ... CHAPTER 11 11-39 Inventory Management Economic Production Quantity I n v en t o r y L ev el CHAPTER 10 Operations Management - Academic Resources at ... http://academic.missouriwestern.edu/mlewis14/MGT%20416/Lectures/My%20Chap010.pdf Operations Management 8th edition 10-2 Quality Control CHAPTER 10 Quality Control McGraw-Hill/Irwin Operations Management, Eighth Edition, by William J. Stevenson PRODUCTION/OPERATIONS MANAGEMENT - … http://faculty-staff.ou.edu/B/Samir.Barman-1/POMsp02.doc PRODUCTION/OPERATIONS MANAGEMENT. BAD 5262 . SPRING 2002. Course Instructor: Samir Barman, Ph.D. ... Apr 02 Chapter 3 All Example Problems. Operations in a PR: 3.1-3.6 Chapter 7 Accounting for Financial Management http://harbert.auburn.edu/~yostkev/teaching/finc3630/notes/Chapter7solutions.pdf Chapter 7 Accounting for Financial Management ANSWERS TO END-OF-CHAPTER QUESTIONS 7-3 No, because the $20 million of retained earnings would probably not be held as cash...

Words: 852 - Pages: 4

Free Essay

Accounting Information System

...scenarios. Let’s briefly discuss each element, with special emphasis on how the accountant is affected. Later in the chapter, we provide a roadmap showing you where each component is covered in this textbook. Before beginning, let us tell you two things. First, the study of AIS, is our broad view, while the accounting information system itself, is our narrow view of an AIS. Second, you shouldn’t assign any meaning to the placements of the elements in figure 1.1. The figure just tells you that there are ten elements. 1. Business Operations: An AIS operates in concert with business operations. Many AIS inputs are prepared by operating departments, the action or work centers of the organization; and many AIS outputs are used to manage these operations. Therefore, we must analyze and manage an AIS in light of the work being performed by the organization. For example, to advise his management and to prepare reports for management decision making, a management accountant must understand his organization’s business. In our scenarios, Jill had to understand corporate takeovers to prepare the relevant analysis. 2. Transaction Processing: An organization Processes Transactions, such as sales and purchase; these Transactions mirror and monitor and business operations. these Transactions have operational, management information system(MIS), and AIS aspects. To design and use the MIS and the AIS, an accountant must know what the Transactions are how they are processed, and how each...

Words: 1475 - Pages: 6

Premium Essay

Fdgfdg

...Systems Analysis and Design Seventh Edition End of Chapter Solutions Chapter NINE System Architecture ANSWERS TO CASE-SIM: SCR ASSOCIATES CASE-SIM: SCR ASSOCIATES Assignments 1. Jesse wants me to recommend a vendor who offers an ERP strategy. I need to review SAP and Oracle Web sites, and at least two others that offer ERP solutions, and reply to her with the results and the reasons for my recommendations. Answers will vary. Students should realize that SCR foresees a dynamic future. With this in mind, an ERP strategy would be highly desirable. Students should have a basic understanding of ERP. When they research on the Internet, students should be able to find more material they can use in their recommendations. For reference purposes, the following screens are provided: [pic] [pic] 2. Visit SCR’s data library to review SCR’s network configuration and then send Jesse a recommendation for the TIMS system architecture. She wants me to suggest an overall client/server design, number of tiers, and network topology. She also asked me to comment on these issues: legacy data, Web-centricity, scalability, security, and batch processing that might be needed. Jesse said it was OK to make reasonable assumptions in my proposal to her. Student answers will vary. Students should start by viewing the SCR network shown in the Data Library. Based on information in this chapter and previous SCR assignments, students should be able to form an opinion...

Words: 8699 - Pages: 35

Premium Essay

Doc, Pdf

...[pic] |Kazakhstan Institute of Management, Economics and Strategic Research (KIMEP) International Summer School, 2011 OPM 5202 OPERATIONS MANAGEMENT | | [pic] OPM 5202 OPERATIONS MANAGEMENT Instructor: Dr. Ardeshir Lohrasbi Office: Telephone: FAX: Email:zlohrasbi@gmail.com Instructor: Dr. Ardeshir Lohrasbi Office: Office Hours: Tel: Fax: E-mail: zlohrasbi@gmail.com Website: https://edocs.uis.edu/alohr1/www Introduction: Welcome to OPM 5202 Operations Management .It is a great pleasure to have all of you in my class. I have been at University of Illinois Springfield in USA for 31 years and served as a Chair of Department of Business Administration , MBA director and Chair of Management Department for several times and my work was recognized last May at the University of Illinois Springfield Faculty Recognition.I taught in graduate and undergraduate online and on ground many different courses such as Production and Operations management, Project Management, Computer Software Application in Business, Service Management, Inventory Management…etc. and I have done a number of consulting for private and public services and presented many research papers at a local and national level. In this class I will share my life time experiences and teachings with all of you. My goal is you learn the course materials and be able to apply the topics, computer applications and techniques in the real world. For more information please...

Words: 2707 - Pages: 11

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

Free Essay

Process Management

...activities: insuring that a product or service is of high quality, choosing the appropriate design and technology for producing a good or service, planning and controlling the flow of materials or customers so that lead times are minimized, and distributing finished goods or services. Relevant decisions range from how much material to order for making a product, to determining how much capacity is needed to provide a good level of service, to evaluating which technology will best meet a company's needs. In short, this course focuses primarily on developing and applying tools and techniques to ensure that the right products and resources are at the right place at the right time so as to maximize profit within a business process or supply chain. The “products” could be either goods, services, or both; and the “resources” could be either material, people, money, information, or any combination of the four. In the first part of this course, we will focus on process design and improvement issues by studying the relationships between key process parameters such as capacity and throughput, and by analyzing processes in order to identify and eliminate bottlenecks. And, in the second part of the course, we will focus on process coordination issues by studying methods for the efficient planning and controlling of critical resources. Specific objectives are: To describe an operating system or a business process and how it can be used as a competitive weapon in a variety of manufacturing...

Words: 2041 - Pages: 9

Premium Essay

Xbrl: M the New Reporting

...Strayer University Chapter One Introduction This chapter consists of research ideas relating to eXtensible Business Reporting Language or XBRL, also how the American Institute of Certified Public Accountants (AICPA) and the Securities and Exchange Commission (SEC) are moving towards this type of reporting. The chapter consists of context of the problem, statement of the problem, research question and sub-questions, significance of the problem, research design and methodology, and organization of study. The chapter will also include a tentative reference list. Context of the Problem There is a time limit as to when an organization has to report financials to the SEC. There are several forms that are required to be filed to the SEC by public organization, for the purpose of this research paper we will focus on quarterly statements (10-Q) and yearly statements (10-K). For the 10-Q the organization has forty-five days, after each of the first three quarter ends to file the report with the SEC and ninety days, after the fiscal year end. (Yuille, n.d.) Given the time-frame organizations have to report the quarterly earnings, it would seem to be enough, but let us look at an organization that has an enterprise resource planning (ERP) system, along with Hyperion Financial Manager (HFM). The ERP system captures data from all the locations, if the organization has more than one, this information is then fed into the HFM system, at this point the information...

Words: 2115 - Pages: 9