Premium Essay

Cis 499 Project Deliverable 3

In:

Submitted By activitymode
Words 2167
Pages 9
CIS 499 PROJECT DELIVERABLE 3
To purchase this visit here: http://www.activitymode.com/product/cis-499-project-deliverable-3/ Contact us at:
SUPPORT@ACTIVITYMODE.COM
PROJECT DELIVERABLE 3: DATABASE AND DATA WAREHOUSING DESIGN
This assignment consists of two (2) sections: a design document and a revised project plan. You must submit both sections as separate files for the completion of this assignment. Label each file name according to the section of the assignment it is written for. Additionally, you may create and / or assume all necessary assumptions needed for the completion of this assignment.
One of the main functions of any business is to be able to use data to leverage a strategic competitive advantage. This feat hinges upon a company’s ability to transform data into quality information. The use of relational databases is a necessity for contemporary organizations; however, data warehousing has become a strategic priority due to the enormous amounts of data that must be analyzed along with the varying sources from which data comes. Since you are now the CIO of a data-collection company which gathers data by using Web analytics and operational systems, you must design a solution overview that incorporates data warehousing. The executive team needs to be clear about what data warehousing can provide the company.
Section 1: Design Document 1.Write a four to six (4-6) page design document in which you: ◦Support the need for data warehousing within your company and elaborate on the best practices that the company will adhere to.
◦Create a schema that supports the company’s business and processes. Explain and support the database schema with relevant arguments that support the rationale for the structure. Note: The minimum requirement for the schema should entail the tables, fields, relationships, views, and indexes.
◦Create an Entity-Relationship

Similar Documents

Premium Essay

The Six Sigma Handbook

...The Six Sigma Handbook Revised and Expanded A Complete Guide for Green Belts, Black Belts, and Managers at All Levels THOMAS PYZDEK McGraw-Hill New York Chicago San Francisco Lisbon London Madrid Mexico City Milan New Delhi San Juan Seoul Singapore Sydney Toronto Copyright © 2003 by The McGraw-HIll Companies, Inc. All rights reserved. Manufactured in the United States of America. Except as permitted under the 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...

Words: 236475 - Pages: 946

Premium Essay

Infosys Ar

...Annual Report 2014-15 Infosys Annual Report 2014-15 Narayana Murthy A tribute to our founders Nandan M. Nilekani S. Gopalakrishnan K. Dinesh The year 2014 was a milestone in our Company's history, when we bid farewell to three of our founders who held executive positions in the Company during the year – Narayana Murthy, S. Gopalakrishnan and S. D. Shibulal. Narayana Murthy stepped down as the Chairman of the Board on October 10, 2014. His vision, leadership and guidance have been an inspiration to Infosys, the Indian IT industry and an entire generation of technology entrepreneurs. He propelled the Company into accomplishing many firsts and in setting industry benchmarks on several fronts. He espoused the highest level of corporate governance standards that have defined Infosys over the years and made us a globally respected corporation. Between June 2013 and October 2014, he guided the Company through a period of stabilization and leadership transition. S. Gopalakrishnan stepped down as Vice Chairman of the Board on October 10, 2014. Kris, as he is popularly known, served the Company in several capacities over the last 33 years. As the Chief Executive Officer between 2007 and 2011, he steered the Company at a time when the world was faced with economic crises. Ranked as a global thought leader, Kris has led the technological evolution of the Company. S. D. Shibulal stepped down as the Company's Chief Executive Officer on July...

Words: 136409 - Pages: 546

Premium Essay

Information and Survey Analysis

...indicate that there are adequate internal controls, then substantive tests can be minimized. Stop-or-go sampling allows a test to be stopped as early as possible and is not appropriate for checking whether procedures have been followed. 2. The decisions and actions of an IS auditor are MOST likely to affect which of the following risks? A. Inherent B. Detection C. Control D. Business The correct answer is: B. Detection Explanation: Detection risks are directly affected by the auditor's selection of audit procedures and techniques. Inherent risks usually are not affected by the IS auditor. Control risks are controlled by the actions of the company's management. Business risks are not affected by the IS auditor. 3. Senior management has requested that an IS auditor assist the departmental management in the implementation of necessary controls. The IS auditor should: A. refuse the assignment since it is not the role of the IS auditor. B. inform management of his/her inability to conduct future audits. C. perform the assignment and future audits...

Words: 97238 - Pages: 389

Premium Essay

Sanitation in Ghana

...“Transformational Agenda: Securing the Bright Medium Term Prospects of the Economy ’’ For copies of the Statement, please contact the Public Relations Office of the Ministry: Ministry of Finance Public Relations Office New Building, Ground Floor, Room 001/003 P. O. Box MB 40 Accra – Ghana The 2015 Budget Statement and Economic Policy of the Government of Ghana is also available on the internet at: www.mofep.gov.gh ~ iii ~ Theme: “Transformational Agenda: Securing the Bright Medium Term Prospects of the Economy ’’ ACRONYMS AND ABBREVIATIONS ABFA ACLP ADR AFCON AfDB AIDS AML AMSECs APR ATMA AVIC BACs BDS BIEPC BoG BOP bopd bps BR BRICS BSPs BVDs Annual Budget Funding Amount Ascertainment and Codification of Customary Law Project Alternative Dispute Resolution African Cup of Nations African Development Bank Acquired Immune Deficiency Syndrome Anti-Money laundering Agricultural Mechanization Services Enterprise Centres Annual Progress Report Accra-Tema Metropolitan Area Accra Visitor Information Centre Business Advisory Centres Business Development Services Bawku Inter Ethnic Peace Committee Bank of Ghana Balance of Payments barrels of oil per day basis points Benchmark Revenue Brazil, Russia, India, China, and South Africa Bulk Supply Points Biometric Verification Devices ~ iv ~ Theme: “Transformational Agenda: Securing the Bright Medium Term Prospects of the Economy ’’ BVR CAGD CBE CDB CEDECOM CENDLOS...

Words: 63016 - Pages: 253

Premium Essay

Scp and Sap Apo

...Willy-Brandt-Platz 5 68161 Mannheim Germany christoph.kilger@jnm.de Cataloging-in-Publication Data Library of Congress Control Number: 2004110194 ISBN 3-540-22065-8 Springer Berlin Heidelberg New York ISBN 3-540-43450-X 2nd edition Springer Berlin Heidelberg New York This work is subject to copyright. All rights are reserved, whether the whole or part of the material is concerned, specifically the rights of translation, reprinting, reuse of illustrations, recitation, broadcasting, reproduction on microfilm or in any other way, and storage in data banks. Duplication of this publication or parts thereof is permitted only under the provisions of the German Copyright Law of September 9, 1965, in its current version, and permission for use must always be obtained from Springer-Verlag. Violations are liable for prosecution under the German Copyright Law. Springer is a part of Springer Science+Business Media springeronline.com ° Springer Berlin ´ Heidelberg 2000, 2002, 2005 Printed in Germany The use of general descriptive names, registered names, trademarks, etc. in this publication does not imply, even in the absence of a specific statement, that such names are exempt from the relevant protective laws and regulations and therefore free for general use. Hardcover-Design: Erich Kirchner, Heidelberg SPIN 11010463 42/3130-5 4 3 2 1 0 ± Printed on acid-free paper...

Words: 180845 - Pages: 724

Premium Essay

Health Information System

...Slovensky 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 [First Page] [-1], (1) Lines: 0 to 27 * 516.0pt PgVar ——— ——— Normal Page * PgEnds: PageBreak [-1], (1) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 AUPHA/HAP Editorial Board Sandra Potthoff, Ph.D., Chair University of Minnesota Simone Cummings, Ph.D. Washington University Sherril B. Gelmon, Dr.P.H., FACHE Portland State University Thomas E. Getzen, Ph.D. Temple University Barry Greene, Ph.D. University of Iowa Richard S. Kurz, Ph.D. Saint Louis University Sarah B. Laditka, Ph.D. University of South Carolina Tim McBride, Ph.D. St. Louis University Stephen S. Mick, Ph.D. Virginia Commonwealth University Michael A. Morrisey, Ph.D. University of Alabama—Birmingham Dawn Oetjen, Ph.D. University of Central Florida Peter C. Olden, Ph.D. University of Scranton Lydia M. Reed AUPHA Sharon B. Schweikhart, Ph.D. The Ohio State University Nancy H. Shanks, Ph.D. Metropolitan State College of Denver * [-2], (2 Lines: 2 59.41 ——— ——— Normal * PgEnds [-2], (2 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 [-3], (3) Lines: 115 to 168 * 487.0pt PgVar ——— ——— Normal Page * PgEnds: Eject [-3], (3) AUPHA Health Administration Press 1 2 3 4 5 6 7 8 9 10...

Words: 123678 - Pages: 495

Premium Essay

Customer Relationship Management

...Customer Relationship Management VSF This book is dedicated to my children Emma and Lewis of whom I am enormously proud. Customer Relationship Management Concepts and Technologies Second edition Francis Buttle AMSTERDAM • BOSTON • HEIDELBERG • LONDON • NEW YORK • OXFORD PARIS • SAN DIEGO • SAN FRANCISCO • SINGAPORE • SYDNEY • TOKYO Butterworth-Heinemann is an imprint of Elsevier Butterworth-Heinemann is an imprint of Elsevier Linacre House, Jordan Hill, Oxford OX2 8DP 30 Corporate Drive, Suite 400, Burlington, MA 01803, USA First edition 2009 Copyright © 2009, Francis Buttle Published by Elsevier Ltd. All rights reserved. The right of Francis Buttle to be identified as the author of this work has been asserted in accordance with the Copyright, Designs and Patents Act 1988 No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any means electronic, mechanical, photocopying, recording or otherwise without the prior written permission of the publisher. Permissions may be sought directly from Elsevier’s Science & Technology Rights Department in Oxford, UK: phone ( 44) (0) 1865 843830; fax: ( 44) (0) 1865 853333; email: permissions@elsevier.com. Alternatively you can submit your request online by visiting the Elsevier web site at http://elsevier.com/locate/ permissions, and selecting Obtaining permission to use Elsevier material. Notice No responsibility is assumed by the publisher for any injury and/or damage...

Words: 171161 - Pages: 685

Free Essay

Core Concepts of Ais

...CORE CONCEPTS OF Accounting Information Systems Twelfth Edition Mark G. Simkin, Ph.D. Professor Department of Accounting and Information Systems University of Nevada Jacob M. Rose, Ph.D. Professor Department of Accounting and Finance University of New Hampshire Carolyn Strand Norman, Ph.D., CPA Professor Department of Accounting Virginia Commonwealth University JOHN WILEY & SONS, INC. VICE PRESIDENT & PUBLISHER SENIOR ACQUISITIONS EDITOR PROJECT EDITOR ASSOCIATE EDITOR SENIOR EDITORIAL ASSISTANT PRODUCTION MANAGER PRODUCTION EDITOR MARKETING MANAGER CREATIVE DIRECTOR SENIOR DESIGNER PRODUCTION MANAGEMENT SERVICES SENIOR ILLUSTRATION EDITOR PHOTO EDITOR MEDIA EDITOR COVER PHOTO George Hoffman Michael McDonald Brian Kamins Sarah Vernon Jacqueline Kepping Dorothy Sinclair Erin Bascom Karolina Zarychta Harry Nolan Wendy Lai Laserwords Maine Anna Melhorn Elle Wagner Greg Chaput Maciej Frolow/Brand X/Getty Images, Inc. This book was set in 10/12pt Garamond by Laserwords Private Limited, and printed and bound by RR Donnelley/Jefferson City. The cover was printed by RR Donnelley/Jefferson City. This book is printed on acid free paper. Founded in 1807, John Wiley & Sons, Inc. has been a valued source of knowledge and understanding for more than 200 years, helping people around the world meet their needs and fulfill their aspirations. Our company is built on a foundation of principles that include responsibility to the...

Words: 241803 - Pages: 968

Premium Essay

California an Interpretive History - Rawls, James

...distance learning. Some ancillaries, including electronic and print components, may not be available to customers outside the United States. This book is printed on acid-free paper. 1234567890 QFR/QFR 10987654321 ISBN: 978-0-07-340696-1 MHID: 0-07-340696-1 Vice President & Editor-in-Chief: Michael Ryan Vice President EDP/Central Publishing Services: Kimberly Meriwether David Publisher: Christopher Freitag Sponsoring Editor: Matthew Busbridge Executive Marketing Manager: Pamela S. Cooper Editorial Coordinator: Nikki Weissman Project Manager: Erin Melloy Design Coordinator: Margarite Reynolds Cover Designer: Carole Lawson Cover Image: Albert Bierstadt, American (born in Germany), 1830–1902 Valley of the Yosemite, 1864 (detail) Oil on paperboard 30.16 × 48.89 cm (11 7/8 × 19 1/4 in.) Museum of Fine Arts, BostonGift of Martha C. Karolik for the M. and M. Karolik Collection of American Paintings, 1815–1865 47.1236 Buyer: Susan K. Culbertson Media Project Manager: Sridevi Palani Compositor: MPS Limited, a Macmillan Company Typeface: 10.5/12 Times Roman...

Words: 248535 - Pages: 995

Premium Essay

Marketing Real People, Real Choices

... MARSHALL R C STUART OLLEGE Elnora W. THE UNIVERSITY OF SOUTH CAROLINA UPSTATE 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 Acquisitions Editor: Melissa Sabella Director of Editorial Services: Ashley Santora Editorial Project Manager: Kierra Bloom Editorial Assistant: Elisabeth Scarpa Director of Marketing: Patrice Lumumba Jones Senior Marketing Manager: Anne Fahlgren Marketing Assistant: Melinda Jensen Senior Managing Editor: Judy Leale Project Manager: Becca Richter Senior Operations Supervisor: Arnold Vila Creative Director: Jon Christiana Senior Art Director: Blair Brown Text and Cover Designer: Blair Brown Media Project Manager, Production: Lisa Rinaldi Media Project Manager, Editorial: Denise Vaughn Full-Service Project Management: S4Carlisle Publishing Services Composition: S4Carlisle Publishing Services Printer/Bindery: Courier/Kendalville Cover Printer: Courier/Kendalville 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...

Words: 227255 - Pages: 910