...Chapter 1: (10 points each) 1. Give an example of two related tables other than one in the textbook. Use the STUDENT and GRADE tables in Figure 1-1 of the textbook as an example pattern for your tables. Name the tables and columns using the conventions in the textbook. * I used MysqL workbench to create 2 tables 1- Customers that has customers with some of their information(primary key is “Customer ID”) * CREATE TABLE IF NOT EXISTS `mydb`.`Customer` ( * `CustomerID` INT NOT NULL, * `Name` VARCHAR(45) NULL, * `Email` VARCHAR(45) NULL, * PRIMARY KEY (`CustomerID`), * UNIQUE INDEX `Email_UNIQUE` (`Email` ASC)) * ENGINE = InnoDB 2- Purchases that has number of purchases that has been done by the customers(Pkey is PurchaseID, and foreign key is “CustomerID” from Customer table. * CREATE TABLE IF NOT EXISTS `mydb`.`Purchases` ( * `PurchasesID` INT NOT NULL, * `productID` INT NULL, * `PricePaid` INT NULL, * PRIMARY KEY (`PurchasesID`)) * ENGINE = InnoDB * * *note I made the customerID as the foreign key and the relationship is (1 to many) * * * Figure1 the Customer and Purchases tables’ relationship. * 2. For the tables you created in Question 1, what are the primary keys of each table? Do you think that any of these primary keys could be surrogate keys? * In Customer table the Primary key is CustomerID * In the Purchases table the primary key is PurchaseID ...
Words: 1949 - Pages: 8
...Management Information Systems MANAGING THE DIGITAL FIRM, 12TH EDITION GLOBAL EDITION Chapter 6 FOUNDATIONS OF BUSINESS INTELLIGENCE: DATABASES AND INFORMATION MANAGEMENT Management Information Systems CHAPTER 6: FOUNDATIONS OF BUSINESS INTELLIGENCE: DATABASES AND INFORMATION MANAGEMENT Learning Objectives • Describe how the problems of managing data resources in a traditional file environment are solved by a database management system • Describe the capabilities and value of a database management system • Apply important database design principles • Evaluate tools and technologies for accessing information from databases to improve business performance and decision making • Assess the role of information policy, data administration, and data quality assurance in the management of a firm’s data resources 2 © Pearson Education 2012 Management Information Systems CHAPTER 6: FOUNDATIONS OF BUSINESS INTELLIGENCE: DATABASES AND INFORMATION MANAGEMENT Organizing Data in a Traditional File Environment • File organization concepts – – – – Database: Group of related files File: Group of records of same type Record: Group of related fields Field: Group of characters as word(s) or number • Describes an entity (person, place, thing on which we store information) • Attribute: Each characteristic, or quality, describing entity – E.g., Attributes Date or Grade belong to entity COURSE 3 © Pearson Education 2012 Management Information Systems CHAPTER 6: FOUNDATIONS...
Words: 2709 - Pages: 11
...Fall 2010 COURSE STRUCTURE In 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...
Words: 6838 - Pages: 28
...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
...(Tribhuvan University) A STUDY IN THE ATTENDANCE MANAGEMENT SYSTEM OF HIMALAYAN WHITEHOUSE INTERNATIONAL COLLEGE Project Report on Database Management System In partial fulfillment of the requirements For the Bachelor’s Degree in Business Administration By: September 2014 Table of Contents Chapter I 1 INTRODUCTION 1 1.1 Introduction of the Organization 1 1.2 Attendance Management System 1 1.3 Overview 2 1.4 Economically Feasibility 2 1.5 Technical Feasibility 2 1.6 Behavioural Feasibility 2 Chapter II 3 LITERATURE SURVEY 3 2.1 Drawbacks Of Present System 3 2.2 Proposed System 3 2.2.1 Objectives of the Proposed System 3 2.2.2 Advantages of Proposed System 4 2.3 Scope 4 Chapter III 5 SYSTEM DESIGN 5 3.1 E-R-D Representations 5 3.2 E-R Diagram 6 3.3 Schema 7 3.4 Tabular Representation Of Schema 7 Chapter IV 10 IMPLEMENTATION 10 4.1 Syntaxes 10 4.2 Snapshots 11 Chapter V 14 CONCLUSION 14 BIBLIOGRAPHY 15 REFERENCES 16 LIST OF TABLES |Table no. |Title |Page no. | |3.4.1 |Tabular representation of Schema: Teacher |9 | |3.4.2 |Tabular representation of Schema: Teaches |9 | |3.4.3 |Tabular representation of Schema: Subject |9 ...
Words: 2569 - Pages: 11
...SRS ON ONLINE SCHOOL MANAGEMENT SYSTEM Software Project Lab-2 Title: Online School Management System Group Member: Nowrose Ashraf Supervisor: Emon Kumar Dey Lecturer Institute of Information Technology University of Dhaka Submission Date: 29th Mar, 2014 Contents Chapter 1 1 1.1 Introduction 1 1.2 Purpose 2 1.3 Goals 2 Chapter 2 3 2.1 Introduction 3 2.2 Identifying Stakeholders 3 2.3 Recognizing multiple viewpoints 5 2.4 Working towards collaboration 6 2.5 Common requirements 6 2.6 Conflicting Requirements 6 2.7 Final requirements 7 2.8 Conclusion 7 3.1 Introduction 8 3.2 Eliciting Requirements 8 3.3 Collaborative Requirements Gathering 9 3.3.1 Requirement elicitation through interview 9 3.3.2 Requirement elicitation through questioning 10 3.3.3 Record view 10 3.3.4 Observation 10 3.4 Quality Function Development 10 3.4.1 Normal Requirements 11 3.4.2 Expected Requirements 11 3.5. Case Scenario 12 3.5.1. Registering Online 12 3.5.2. Admission 12 3.5.3 Student database generation 13 3.5.4 Attendance sheet generation 13 3.5.5 Result sheet generation 13 3.5.6 Annual report generation 13 Chapter 4 14 4.1 What is usecase diagram? 14 4.2 Usecase Diagram 15 4.3 Activity Diagram and Swimlane Diagram 31 4.3.1 Activity Diagram 31 4.3.2 Swimlane Diagram 39 Chapter 5 47 5.1 Data Modeling Concept 47 ...
Words: 6864 - Pages: 28
...Study Plan for FNC1 Financial Accounting Concepts and Procedures Chapters 1-‐4 and Chapter 10 1. Understand Basic Accounting Concepts and Principles 2. Know what items are shown on a Balance Sheet, Income Statement, and Statement of Owners Equity 3. Know the Accounting equation 4. Understand debits and credits 5. Understand the timing of recording transactions 6. Understand when revenue and expenses are recoginized 7. Know how to calculate depreciation expense 8. Know how to calculate accumulated depreciation Long Term Liabilities Chapter 14 1. Starting on Page 845 make sure you know the 4 types of Bonds and their characteristics. 2. Make sure you understand Bond issue prices, Bonds issued at Par Value, at a Discount, and at a Premium. 3. Understand how to record interest expense when bonds are issued at par value, a discount, and a premium. Stocks and Dividends Chapters 13 1. Make sure you understand dividends and dividend policies Statement of Cash Flows Chapter 16 1. 2. 3. 4. Know what a Statement of Cash Flows is Understand the Direct and Indirect Method for preparing a Statement of Cash Flows Know the Catergories shown on a Statement of Cash Flows. Study the exhibit on page 940 for the indirect method. Know what gets added in and...
Words: 985 - Pages: 4
...Prepared by Paul Darbyshire Prepared by Paul Darbyshire Welcome Welcome to BCO1102 Information Systems for Business for Semester 1, 2014. For the vast majority of you it will be a compulsory unit of study as it is part of the Business Core in all undergraduate Bachelor of Business degrees. The major focus of this unit is on how computer- based information systems can support decision making in organizations and businesses. Those decisions often need to be made by professionals who come from discipline areas you are studying such as accounting, management, information systems or marketing. One of the most important elements of an information system is people, so all of us need to know what role we can play and what role information and communication technologies (ICT) can play in supporting decisions. This unit will look at the theoretical side of information systems as well as personal productivity tools such as spread sheets and databases. In addition we will look at global trends in information systems and in particular the emerging use of Cloud Computing and Social Networking, which is sometimes called Web 2.0. The unit of study requires the textbook Introduction to Information Systems by Rainer, Prince and Cegielski 5th Edition. The textbook is used for the theory and some of the practical work in tutorials. All reading for this subject during the semester is assigned from this textbook. Feedback from previous years reveals that without this textbook you will be severely disadvantaged...
Words: 3033 - Pages: 13
...INSTRUCTIONS: 1. Form a group – consist of FOUR (4) students 2. Answer all the questions below. FORMAT of YOUR REPORT: 1. Cover – consist of your name and student id 2. Content – * Separate the answer for Chapter 5 and Chapter 6 * PART A: Answer all the questions and please include all the questions as well. * PART B: Discuss the case studies and answer all the questions given. 3. References – include the link or your references Due of Submission: 10th May 2016 (Tuesday) before 12.00 noon. Submit your report at my office at 58, Level 2, Block A. Chapter 5: IT Infrastructure and Emerging Technologies PART A: 1. What is IT infrastructure and what are its components? • Define IT infrastructure from both a technology and a services perspective. • List and describe the components of IT infrastructure that firms need to manage 2. What are the stages and technology drivers of IT infrastructure evolution? • List each of the eras in IT infrastructure evolution and describe its distinguishing characteristics. • Define and describe the following: Web server, application server, multitiered client/server architecture. • Describe Moore’s Law and the Law of Mass Digital Storage. • Describe how network economics, declining communications costs, and technology standards affect IT infrastructure. 3. What are the current trends in computer hardware platforms? • Describe the evolving mobile platform, grid computing, and cloud computing. • Explain how businesses...
Words: 1030 - Pages: 5
...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
...Student Attendance System Based On Fingerprint Recognition and One-to-Many Matching A thesis submitted in partial fulfillment of the requirements for the degree of Bachelor of Technology in Computer Science and Engineering by cyril nwoba (Roll no. 54373) and Prashant Trivedi (Roll no. 107cs015) Under the guidance of : Prof. B. Majhi Department of Computer Science and Engineering National Institute of Technology Rourkela Rourkela-769 008, Orissa, India 2 . Dedicated to Our Parents and Indian Scientific Community . 3 National Institute of Technology Rourkela Certificate This is to certify that the project entitled, ‘Student Attendance System Based On Fingerprint Recognition and One-to-Many Matching’ submitted by Rishabh Mishra and Prashant Trivedi is an authentic work carried out by them under my supervision and guidance for the partial fulfillment of the requirements for the award of Bachelor of Technology Degree in Computer Science and Engineering at National Institute of Technology, Rourkela. To the best of my knowledge, the matter embodied in the project has not been submitted to any other University / Institute for the award of any Degree or Diploma. Date - 9/5/2011 Rourkela (Prof. B. Majhi) Dept. of Computer Science and Engineering 4 Abstract Our project aims at designing an student attendance system which could effectively manage attendance of students at institutes like NIT Rourkela. Attendance is marked after student identification...
Words: 14646 - Pages: 59
...Management Information Systems MANAGING THE DIGITAL FIRM Kenneth C. 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:...
Words: 3508 - Pages: 15
...Teradata Database Release Summary Release 12.0 B035-1098-067A March 2008 The product or products described in this book are licensed products of Teradata Corporation or its affiliates. Teradata, BYNET, DBC/1012, DecisionCast, DecisionFlow, DecisionPoint, Eye logo design, InfoWise, Meta Warehouse, MyCommerce, SeeChain, SeeCommerce, SeeRisk, Teradata Decision Experts, Teradata Source Experts, WebAnalyst, and You’ve Never Seen Your Business Like This Before are trademarks or registered trademarks of Teradata Corporation or its affiliates. Adaptec and SCSISelect are trademarks or registered trademarks of Adaptec, Inc. AMD Opteron and Opteron are trademarks of Advanced Micro Devices, Inc. BakBone and NetVault are trademarks or registered trademarks of BakBone Software, Inc. EMC, PowerPath, SRDF, and Symmetrix are registered trademarks of EMC Corporation. GoldenGate is a trademark of GoldenGate Software, Inc. Hewlett-Packard and HP are registered trademarks of Hewlett-Packard Company. Intel, Pentium, and XEON are registered trademarks of Intel Corporation. IBM, CICS, RACF, Tivoli, z/OS, and z/VM are registered trademarks of International Business Machines Corporation. Linux is a registered trademark of Linus Torvalds. LSI and Engenio are registered trademarks of LSI Corporation. Microsoft, Active Directory, Windows, Windows NT, and Windows Server are registered trademarks of Microsoft Corporation in the United States and other countries. Novell and SUSE are registered trademarks...
Words: 18345 - Pages: 74
...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
...Student Attendance System Based On Fingerprint Recognition and One-to-Many Matching A thesis submitted in partial fulfillment of the requirements for the degree of Bachelor of Technology in Computer Science and Engineering by Rishabh Mishra (Roll no. 107cs016) and Prashant Trivedi (Roll no. 107cs015) Under the guidance of : Prof. B. Majhi Department of Computer Science and Engineering National Institute of Technology Rourkela Rourkela-769 008, Orissa, India 2 . Dedicated to Our Parents and Indian Scientific Community . 3 National Institute of Technology Rourkela Certificate This is to certify that the project entitled, ‘Student Attendance System Based On Fingerprint Recognition and One-to-Many Matching’ submitted by Rishabh Mishra and Prashant Trivedi is an authentic work carried out by them under my supervision and guidance for the partial fulfillment of the requirements for the award of Bachelor of Technology Degree in Computer Science and Engineering at National Institute of Technology, Rourkela. To the best of my knowledge, the matter embodied in the project has not been submitted to any other University / Institute for the award of any Degree or Diploma. Date - 9/5/2011 Rourkela (Prof. B. Majhi) Dept. of Computer Science and Engineering 4 Abstract Our project aims at designing an student attendance system which could effectively manage attendance of students at institutes like NIT Rourkela. Attendance is marked after student...
Words: 14646 - Pages: 59
