...CECS 6605 Advanced Database Systems Assignment 1 Deadline: September 8, 2013 Part I. Entity Relationship Diagrams (ERD) Database Design Using Entity-Relationship Diagrams (2003) by Sikha Bagui and Richard Earp Auerbach Publications ISBN:0849315484 Chapter 1 (Database Design Using Entity-Relationship Diagrams) * Checkpoint 1.1, Problem 1; pp. 13-14 * Checkpoint 1.3, Problem 1, 3; pp. 25 Chapter 2 (Database Design Using Entity-Relationship Diagrams) * Checkpoint 2.1, Problems 1, 3, 5, 7; pp. 39 * Checkpoint 2.3, Problems 1, 3; pp. 61 Chapter 3 (Database Design Using Entity-Relationship Diagrams) * Checkpoint 3.1, Problems 1, 3, 5; pp. 78 Chapter 4 (Database Design Using Entity-Relationship Diagrams) * Checkpoint 4.1, Problems 1, 3, 5; pp. 99 * Checkpoint 4.3, Problems 1, 3; pp. 117 Part II. SQL A Guide to SQL (2008) by Philip J. Pratt and Mary Z. Last Use only Oracle for this part. Please show the complete question, query used, and print the query results. Do the exercises from the Henry Books Database. Chapter 1 (A Guide to SQL, Henry Books) * Exercises - odd numbers Chapter 2 (A Guide to SQL, Henry Books) * Exercises - odd numbers Chapter 3 (A Guide to SQL, Henry Books) * Exercises - odd numbers Chapter 4 (A Guide to SQL, Henry Books) * Exercises - odd numbers Part III. Database System Fundamentals Fundamentals of Database Systems (2011) by Ramez Elmasri; Shamkant B. Navathe ...
Words: 352 - Pages: 2
...CISN 351: Review Questions Chapter 2 2.1 What is a business intelligence (BI) system? 2.2 What is an ad-hoc query? 2.3 What does SQL stand for, and what is SQL? 2.4 What does SKU stand for? What is an SKU? 2.5 Summarize how data were altered and filtered in creating the Cape Codd data extraction. 2.6 Explain, in general terms, the relationships among the RETAIL_ORDER, ORDER_ITEM, and SKU_DATA tables. 2.7 Summarize the background of SQL. 2.8 What is SQL-92? How does it relate to SQL statements in this chapter? 2.9 What features have been added to SQL in versions subsequent to the SQL-92? 2.10 Why is SQL described as a data sublanguage? 2.11 What does DML stand for? What are DML statements? 2.12 What does DDL stand for? What are DDL statements? 2.13 What is the SQL SELECT /FROM/WHERE framework? 2.14 Explain how Access uses SQL. 2.15 Explain how enterprise-class DBMS products use SQL. 2.16 There is an intentional flaw in the design of the INVENTORY table used in these exercises. This flaw was purposely included in the INVENTORY tables so that you can answer some of the following questions using only that table. Compare the SKU and INVENTORY tables, and determine what design flaw is included in INVENTORY. Specifically, why did we include it? 2.17 Write an SQL statement to display SKU and SKU_Description. 2.18 Write an SQL statement to display SKU_Description...
Words: 7421 - Pages: 30
...CCIS2701 – Database Design and SQL Chapter 1 Review Questions Page 1 of 3 1. Discuss each of the following terms: a. data - Data are raw, unprocessed facts about a thing. They have little meaning unless organized. b. field – A field is a group of characters with a specific meaning, used to store data c. record – A connected set of fields. A record containes fields used to describe a specific person, place, thing or event. d. File – A collection of related records. A file may contain records for all students enrolled at a university, for example. 2. What is data redundancy and which characteristics of the file system can lead to it? Data redundancy occurs when the same data are store in multiple locations. It can lead to data inconsistency, where different and conflicting versions of the data appear in different places. It can also cause data anomalies, as a change event may require more than one change to the data. 3. It is said that some file systems lack data independence. Discuss. All programs that access a file system will need to be changed if any characteristics of the file system’s data changes. This is referred to as data dependence. 4. What is a DBMS, and what are its functions? A database management system is a collection of programs that manages the database structure and controls access to the information stored in a database. Consistent organization and controlled access allows the information in a database to be shared...
Words: 966 - Pages: 4
...HANDS-ON DATABASE AN INTRODUCTION TO DATABASE DESIGN AND DEVELOPMENT Steve Conger Seattle Central Community College Prentice Hall Boston Columbus Indianapolis New York San Francisco Upper Saddle River Amsterdam Cape Town Dubai London Madrid Milan Munich Paris Montreal Toronto Delhi Mexico City Sao Paulo Sydney Hong Kong Seoul Singapore Taipei Tokyo Editorial Director: Sally Yagan Editor in Chief: Eric Svendsen Executive Editor: Bob Horan Product Development Manager: Ashley Santora Editorial Project Manager: Kelly Loftus Editorial Assistant: Jason Calcaño Director of Marketing: Patrice Lumumba Jones Senior Marketing Manager: Anne Fahlgren Marketing Assistant: Melinda Jensen Production Project Manager: Renata Butera Creative Art Director: Jayne Conte Cover Designer: Suzanne Behnke Cover Art: Kheng Guan Toh/Fotolia, Inc Media Editor: Denise Vaughn Media Project Manager: Lisa Rinaldi Full-Service Project Management: Chitra Sundarajan/Integra Software Services Pvt. Ltd. Printer/Binder: Edwards Brothers Cover Printer: Lehigh-Phoenix Color/Hagerstown Text Font: Palatino 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 © 2012 Pearson Education, Inc., publishing as Prentice Hall, One Lake Street, Upper Saddle...
Words: 70521 - Pages: 283
...the modern world, the majority of accounting entries occur electronically. Accountants and auditors store information in databases, managed by enterprise systems that have a set of controls to ensure that transactions and 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...
Words: 6838 - Pages: 28
...Laudon New York University f Jane P. Laudon Azimuth Information Systems PEARSON feerttifie tall Pearson Education International Brief Contents Part One Chapter 1 Chapter 2 Chapter 3 Chapter 4 Part One Project Organizations, Management, and the Networked Enterprise 1 Information Systems in Global Business Today 2 Global E-Business: How Businesses Use Information Systems 38 Information Systems, Organizations, and Strategy 80 Ethical and Social Issues in Information Systems 124 Analyzing Business Processes for an Enterprise System 165 Part Two Chapter 5 Chapter 6 Chapter 7 Chapter 8 Part Two Project Information Technology Infrastructure 167 IT Infrastructure and Emerging Technologies 168 Foundations of Business Intelligence: Databases and Information Management 222 Telecommunications, the Internet, and Wireless Technology 260 Securing Information Systems 312 Creating a New Internet Business 351 Part Three Chapter 9 Chapter 10 Chapter 11 Chapter 12 Part Three Project Key System Applications for the Digital Age 353 Achieving Operational Excellence and Customer Intimacy: Enterprise Applications 354 E-Commerce: Digital Markets, Digital Goods 388 Managing Knowledge 428 Enhancing Decision Making 470 Designing an Enterprise Information Portal 508 Part Four Chapter 13 Chapter 14 Chapter 15 Part Four Project Building and Managing Systems 509 Building Systems 510 Project Management: Establishing the Business Value of Systems and Managing Change 552...
Words: 3508 - Pages: 15
...CIS 260 Home Work # 1 Due to: 21/3/2013 Chapter 1: Review Questions 1.1. Define the following terms: data, database, DBMS, database system, database catalog, program-data independence, user view, DBA, end user, canned transaction, meta-data, and transaction-processing application. 1.2. What four main types of actions involve databases? Briefly discuss each. 1.3. Discuss the main characteristics of the database approach and how it differs from traditional file systems. 1.4. What are the responsibilities of the DBA and the database designers? 1.5. What are the different types of database end users? Discuss the main activities of each. 1.6. Discuss the capabilities that should be provided by a DBMS. 1.7. Discuss the differences between database systems and information retrieval systems. Chapter 2: Review Questions 2.1. Define the following terms: data model, database schema, database state, internal schema, conceptual schema, external schema, data independence, DDL, DML, SDL, VDL, query language, host language, data sublanguage, database utility, catalog, client/server architecture, three-tier architecture, and n-tier architecture. 2.2. Discuss the main categories of data models. What are the basic differences between the relational model, the object model, and the XML model? 2.3. What is the difference between a database schema and a database state? 2.4. Describe the three-schema architecture. Why do we need mappings between schema levels? How do different schema definition...
Words: 1108 - Pages: 5
...Review Questions 24 I Chapter 1 Databases and Database Users 1.1. Define the following terms: data, database, DBMS, database system, database catalog, Program-data independence, user view, DBA, end user, canned transaction, deductive Database system, persistent object, meta-data, transaction-processing application. 1.2. What three main types of actions involve databases! Briefly discuss each. 1.3. Discuss the main characteristics of the database approach and how it differs from traditional file systems. 1.4. What are the responsibilities of the DBA and the database designers? 1.5. What are the different types of database end users? Discuss the main activities of each. 1.6. Discuss the capabilities that should be provided by a DBMS. Exercises 1.7. Identify some informal queries and update operations that you would expect to apply to the database shown in Figure 1.2. 1.8. What is the difference between controlled and uncontrolled redundancy? Illustrate with examples. 1.9. Name all the relationships among the records of the database shown in Figure 1.2. 1.10. Give some additional views that may be needed by other user groups for the database Shown in Figure 1.2. 1.11. Cite some examples of integrity constraints that you think should hold on the Database shown in Figure 1.2. Chapter 2 Database System Concepts and Architecture Review Questions 2.1. Define the following terms: data model, database schema, database state, internal Schema, conceptual schema, external schema, data independence...
Words: 803 - Pages: 4
...Cengage Learning ALL RIGHTS RESERVED. No part of this work covered by the copyright hereon 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 permission questions can be emailed to permissionrequest@cengage.com ISBN-13: 978-0-324-59768-4 ISBN-10: 0-324-59768-1 Course Technology 25 Thomson...
Words: 48772 - Pages: 196
...your assignments for this week. Save this worksheet as lastname_Lesson3.docx and submit. You are required to complete all sections indicated by red brackets. You will replace the red brackets and text with the indicated material. For example, for the “Student Name” section above, a completed response would look like this: Student Name: When responding with text, please leave the text red so that your instructor will be able to find your responses easily. When pasting an image, please replace the red text with the image. Total Points: 37 Assignments: Review Questions - Short Answer Short Answer - Review Questions, Chapter 6: Questions 1, 5, 7, and 15. Student is to complete in Short Answer format: a) Define the term user view as it applies to database design. Saved queries created with SQL. User views specify which users are permitted access to what data in a database. 5. Describe the function of each of the following types of keys: primary, alternate, secondary, and foreign. Primary Key: The primary key is a attribute or a set of attributes that uniquely identify specific instance of an entity. Every entity in the data model must have a primary key whose values uniquely identify instance of the entity. Sometimes a record may contain more than one key field. Primary key is selected from one of the candidate key and the remaining keys are called alternate keys. Alternate Key: The alternate keys of any table are simply those candidate...
Words: 1035 - Pages: 5
...HANDS ON DATABASE by Steve Conger © 2010 Hands ON Database Introduction Many students taking an introductory database course need hands-on experience. Typically they are under pressure to finish quickly with a certificate or degree and get to work. They need to get actual practice in the process of designing and developing databases that they can apply in their future employment. They need to create tables, enter data, and run SQL queries. This book is designed for them. Hands on Database: an Introduction to Database Design and Development focuses on the process of creating a database. It guides the student through the initial conception of the database. It covers gathering of requirements and business rules, the logical and physical design and the testing of the database. It does this through a continuous narrative that follows a student, Sharon, as she designs and constructs a database to track the tutoring program at her school. It shows some of her missteps as well as her successes. Students get hands-on experience by doing practices and developing scenarios that parallel the narrative. After completing this book students will have a good sense of what is involved in developing and creating a database. Below is a list of the book outcomes. A student who has completed this book will be able to give a general definition of a relational database to identify a variety of ways to gather database requirements to define business rules for a database to create an...
Words: 66591 - Pages: 267
...Instructor’s Manual Enterprise Resource Planning, 1/E CHAPTER 1: A FOUNDATION FOR UNDERSTANDING ENTERPRISE RESOURCE PLANNING SYSTEMS CHAPTER OBJECTIVES 1. Develop an understanding of how ERP systems can improve the effectiveness of information systems in organizations. 2. Understand the business benefits of enterprise resource planning (ERP) systems. 3. Understand the history and evolution of ERP. CHAPTER OUTLINE 1. A Foundation for Understanding Enterprise Resource Planning Systems a. The Emergence of Enterprise Resource Planning Systems 1. What is ERP? 2. The Evolution of ERP 3. The Integrated Systems Approach b. Business Benefits of ERP c. ERP Modules d. ERP Design Alternatives e. The Business Case for ERP 1. Cost-Benefit Analysis for ERP 2. Can ERP Provide a Competitive Advantage? f. The Challenge of Implementing an ERP System g. Summary ANSWERS TO END-OF-CHAPTER QUESTIONS Questions for Discussion: 1. Use on-line library databases to identify articles in trade publications which provide case studies of ERP implementations. These articles may provide some insight into each of these questions. a. How widespread is the use of ERP across certain industries? b. What are the benefits reported from implementing ERP? c. What are its limitations? 2. Research and learn about the implementation of ERP. Use trade publications and on-line library databases (e.g. ABI Inform, ProQuest, First Search, Wilson Select Plus, available through...
Words: 8305 - Pages: 34
...Chapter 2 Data Models Chapter 2Data Models Answers to Review Questions 1. Discuss the importance of data modelling. A data model is a relatively simple representation, usually graphical, of a more complex real world object event. The data model’s main function is to help us understand the complexities of the real-world environment. The database designer uses data models to facilitate the interaction amongdesigners, application programmers, and end users. In short, a good data model is a communicationsdevice that helps eliminate (or at least substantially reduce) discrepancies between the databasedesign’s components and the real world data environment. The development of data models, bolstered by powerful database design tools, has made it possible to substantially diminish thedatabase design error potential. (Review Section 2.1 in detail.) 2. What is a business rule, and what is its purpose in data modelling? A business rule is a brief, precise, and unambiguous description of a policy, procedure, or principle within a specific organization’s environment. In a sense, business rules are misnamed: they apply to any organization -- a business, a government unit, a religious group, or a research laboratory; large or small -- that stores and uses data to generate information. Business rules are derived from a description of operations. As its name implies, a description of operations is a detailed narrative that describes the operational environment of an organization. Such a...
Words: 648 - Pages: 3
...Portada Management information systems managing the digital firm Part One. Organizations, Management, and the Networked Enterprise ....1 Chapter 1. Managing the Digital Firm ....2 Opening Case: DaimlerChrysler's Agile Supply Chain ....3 1.1 Why Information Systems? ....4 Why Information Systems Matter 4 • How Much Does IT Matter? 6 • Why IT Now? Digital Convergence and the Changing Business Environment ....7 1.2 Perspectives on Information Systems ....13 What Is an Information System? ....13 Windows on Organizations: Cemex: A Digital Firm in the Making ....14 Window on Technology: UPS Competes Globally with Information Technology ....17 It Isn't Just Technology: A Business Perspective on Information Systems 18 • Dimensions of Information Systems ....20 1.3 Contemporary Approaches to Information Systems ....25 Technical Approach 26 • Behavioral Approach 26 • Approach of This Text: Sociotechnical Systems ....27 1.4 Learning to Use Information Systems: New Opportunities with Technology ....27 The Challenge of Information Systems: Key Management Issues 28 • Integrating Text with Technology: New Opportunities for Learning ....30 Make IT Your Business ....31 Summary, 31 • Key Terms, 32 • Review Questions, 32 • Discussion Questions, 33 • Application Software Exercise: Database Exercise: Adding Value to Information for Management Decision Making, 33 • Dirt Bikes USA: Preparing a Management Overview of the Company, 33 • Electronic Commerce Project: Analyzing...
Words: 3823 - Pages: 16
...Virginia September 2010 Certification and Approval A Directed Research Project on Information System Strategic Planning the Cost of Efficiency: Is there a preferred approach to information systems planning, submitted to the Graduate Faculty of Strayer University in candidacy for the degree of Master’s of Science in Information Systems. Submitted by: _________________________Date: _______________ Approved by: ___________________________ Date: _______________ ABSTRACT Information systems’ planning is often costly to implement and maintain; however, sound planning practices may reduce expenses associated with the development processes. A Formal methodical approach to systems analysis, requirements engineering, systems design, development, and construction may offer a reduction in development and certain aspects of life cycle support expenses. Corporate expenses may reach approximately 5% of their gross income on information systems development and support. This equates to approximately $15,000,000 to $35,000,000 annually (Whitemarsh Information Systems Corp. 2008, p.). Information systems may cost significantly less. In comparison, information systems, contingent upon other factors such as size of the company, and complexity of the information system cost may range anywhere from $2,000,000 to $10,000,000 per system. Corporate leadership clearly has a strong influence upon information system expenditures and may have unrealistic expectations associated with...
Words: 6140 - Pages: 25
