Premium Essay

Cis 336 Week 5 Group Project Task 3

In: Other Topics

Submitted By uoptutors3
Words 365
Pages 2
CIS 336 Week 5 Group Project Task 3

To Buy This material Click below link

http://www.uoptutors.com/cis-336-devry/cis-336-week-5-group-project-task-3

Develop the SQL statements to insert records into the database. You should ensure that the data in the database is sufficient to allow for each of the reports requested by Ms. Smith to be tested. You need to show a minimum of three insert queries for each database table that you have created. Some tables will obviously require more to ensure that all of the required data is in the database (i.e., the packages table, program table, etc). To submit this task, add a comment heading called INSERT STATEMENTS to your corrected SQL script from Task 2. Add your INSERT statements for each table after this heading. Keep in mind that you will need to insert data into the tables in the same order that the tables were created. This will minimize any integrity constraint errors you might encounter. Keep in mind also that any values being inserted into a field defined as a foreign key field must first exist in a previous table’s primary key field. Save the file as TEAM_X_TASK3.TXT, where X is your team identifier. After testing your statements to verify that your data will insert into your tables, create a spooled output file with the SET ECHO ON session command set for submitting.
Note – Although you are only required to have three records per table in most of your tables for this deliverable, you will need a considerable amount of data in your tables for the final project.
After testing and verifying that all of your create statements work, create a spooled output file with the SET ECHO ON session command set so that your code and the results will show.
Deliverables for this task:
Any revisions of task 2 based on feedback from your instructor. Task 3 comprised of the script file containing DROP TABLE, CREATE TABLE, and...

Similar Documents

Free Essay

Cis 336 Group Project

...CIS 336 GROUP PROJECT To purchase this visit following link: http://www.activitymode.com/product/cis-336-group-project/ Contact us at: SUPPORT@ACTIVITYMODE.COM CIS 336 GROUP PROJECT CIS336 Week 3 Group Project Task 1 Data Model CIS336 Week 4 Group Project Task 2 CIS336 Week 5 Group Project Task 3 CIS336 Week 6 Group Project Task 4 CIS336 Week 7 Group Project Task 5 CIS 336 GROUP PROJECT To purchase this visit following link: http://www.activitymode.com/product/cis-336-group-project/ Contact us at: SUPPORT@ACTIVITYMODE.COM CIS 336 GROUP PROJECT CIS336 Week 3 Group Project Task 1 Data Model CIS336 Week 4 Group Project Task 2 CIS336 Week 5 Group Project Task 3 CIS336 Week 6 Group Project Task 4 CIS336 Week 7 Group Project Task 5 CIS 336 GROUP PROJECT To purchase this visit following link: http://www.activitymode.com/product/cis-336-group-project/ Contact us at: SUPPORT@ACTIVITYMODE.COM CIS 336 GROUP PROJECT CIS336 Week 3 Group Project Task 1 Data Model CIS336 Week 4 Group Project Task 2 CIS336 Week 5 Group Project Task 3 CIS336 Week 6 Group Project Task 4 CIS336 Week 7 Group Project Task 5 CIS 336 GROUP PROJECT To purchase this visit following link: http://www.activitymode.com/product/cis-336-group-project/ Contact us at: SUPPORT@ACTIVITYMODE.COM CIS 336 GROUP PROJECT CIS336 Week 3 Group Project Task 1 Data Model CIS336 Week 4 Group Project Task 2 CIS336 Week 5 Group Project Task 3 CIS336 Week 6 Group Project Task......

Words: 594 - Pages: 3

Premium Essay

Cis 336 Academic Professor - Tutorialrank

...CIS 336 Entire Course: Devry University For more course tutorials visit www.tutorialrank.com CIS 336 Entire Course: Devry University _________________________________________ CIS 336 Final Exam 1 For more course tutorials visit www.tutorialrank.com 1. (TCO 1) Most DBMS are referred to as _____________database management systems. (Points : 4) elemental linked hierarchical relational 2. (TCO 1) Data constitutes the building blocks of _____________. (Points : 4) information processing applications programming 3. (TCO 2) If a foreign key contains either matching values or nulls, the table(s) that make use of such a foreign key is/are said to exhibit __________ integrity. (Points : 4) referential restrictive secondary redundant 4. (TCO 2) In a "one-to-many" relationship, which constraint is usually added to the "many" table? (Points : 4) UNIQUE PRIMARY KEY FOREIGN KEY NOT NULL __________________________________________________ CIS 336 Week 1 iLab 1 Devry University For more course tutorials visit www.tutorialrank.com L A B O V E R V I E W Scenario/Summary This lab will introduce you to the processes involved in defining one of the key components of a data model; the relationship diagram (RD). In this lab, you will draw a relationship diagram for two of the steps shown. Keep in mind when you are trying to decide which side of the relationship should be the "one" side and which...

Words: 689 - Pages: 3

Free Essay

Cis 336 Week 7 Group Project Task 5

...CIS 336 Week 7 Group Project Task 5 To Buy This material Click below link http://www.uoptutors.com/cis-336-devry/cis-336-week-7-group-project-task-5 Develop the queries to support each of the reports that are required by Ms. Smith. It is expected that the information returned by the queries is adequate to be used in the reporting process. Make sure your output contains enough information! The following is a recommendation and the MINIMUM amount of data you should have access to: Customer Table: A minimum of 12 customers (this will allow several channels to have more than one customer selecting it as a favorite channel) Billing Table: Records to support the above customers Program Table: A minimum of 25 programs (your program guide should have enough programs for various channels to support the program guide report) Other tables: A sufficient amount of data to support the above when reports are run. Create a heading of REPORTING STATEMENTS as a comment at the bottom of your group project database script file. Add the six report queries to this area. In instances where you are asked to allow for user input, please specify an appropriate value based upon the data in your script. For example, Report 1 is a DATE driven report; therefore, you should use a single date in your WHERE clause to display the information. Task 5 is the final task for the project and is designed to demonstrate that you have adequately satisfied the requirements of the project. The following is......

Words: 591 - Pages: 3

Premium Essay

Cis 336 Slingshot Academy /Snaptutorial.Com

...CIS 336 Entire Course For more classes visit www.snaptutorial.com CIS 336 Entire Course: Devry University --------------------------------------------------------------------- CIS 336 Week 1 iLab 1 Devry University For more classes visit www.snaptutorial.com L A B O V E R V I E W Scenario/Summary This lab will introduce you to the processes involved in defining one of the key components of a data model; the relationship diagram (RD). In this lab, you will draw a relationship diagram for two of the steps shown. Keep in mind when you are trying to decide which side of the relationship should be the "one" side and which should be the "many" that you must first decide which side has the primary key, or unique identifier. Once you have decided the primary key of the relationship, you have identified the "one" side of the relationship. Note that for an RD, the foreign key "many" side of the relationship points to the primary key "one" side. The "one" side should have the arrowhead point of the connecting line. This is different than an entity/relationship diagram (ERD) that we will draw next week, where the "many" side has crow's feet. This will familiarize you with how to set up MS Visio to draw database diagrams. Steps 1 - 3 below use the Customer, Order, and Employee tables of a simplified Order Entry database. The Customer table records clients who have placed orders. The Order table contains the basic facts about customer orders. The Employee table contains......

Words: 3439 - Pages: 14

Premium Essay

Form

...OFFICIAL CATALOG This Catalog contains information, policies, procedures, regulations and requirements that were correct at the time of publication and are subject to the terms and conditions of the Enrollment Agreement entered into between the Student and ECPI University. In keeping with the educational mission of the University, the information, policies, procedures, regulations and requirements contained herein are continually being reviewed, changed and updated. Consequently, this document cannot be considered binding. Students are responsible for keeping informed of official policies and meeting all relevant requirements. When required changes to the Catalog occur, they will be communicated through catalog inserts and other means until a revised edition of the Catalog is published. The policies in this Catalog have been approved under the authority of the ECPI University Board of Trustees and, therefore, constitute official University policy. Students should become familiar with the policies in this Catalog. These policies outline both student rights and student responsibilities. The University reserves the right and authority at any time to alter any or all of the statements contained herein, to modify the requirements for admission and graduation, to change or discontinue programs of study, to amend any regulation or policy affecting the student body, to increase tuition and fees, to deny admission, to revoke an offer of admission and to dismiss from......

Words: 149595 - Pages: 599

Premium Essay

Aau Catalog

...ALLIED AMERICAN UNIVERSITY Personalized. Flexible. Dedicated. Online Programs – Individual Support – Open Enrollment – Ease of Transfer Credits UNIVERSITY CATALOG 2013 Seventh Edition 22952 Alcalde Drive, Laguna Hills, CA 92653 Phone: (888) 384-0849 ∼ Fax: (949) 707-2978 7:00 A.M. – 5:00 P.M. (Monday – Friday) Email: info@allied.edu Website: www.allied.edu KEY STAFF AND FACULTY Charlotte Hislop, Ph.D. Candidate, President/CEO Bonny Nickle, Ed.D., Provost Eric Sharkey, M.Ed., Director of Education Bill Luton, Ph.D., Director of Assessment and Dean of Business Carlo Tannoury, Ph.D. Candidate, Dean of Computer Information Systems Patricia Drown, Ph.D., Dean of Criminal Justice and General Studies C.J. Bishop, M.B.A., Institutional Research Frank Vazquez, Operations Director Parrish Nicholls, J.D., Director of Compliance Lindsay Oglesby, Admissions Director Abby Dolan, B.A., Registrar Sasha Heard, M.B.A., Student Services Manager Barbara Jobin, B.S.B.A., Career Center Manager Hugo Aguilar, B.A., Chief Financial Officer Richard Madrigal, B.A., Financial Aid Officer As a prospective student at Allied American University, you are encouraged to review this catalog prior to signing an enrollment agreement. You are also encouraged to review the student performance fact sheet which must be provided to you prior to signing an enrollment agreement. This catalog is not a contract between the student, AAU, or any party or parties. Reasonable effort was made at the time this......

Words: 52297 - Pages: 210

Premium Essay

Fraternity

...Public Health Advisory Committee: Jan Fordham, Manager, Planning & Policy – Family Health Juanita Hogg-Devine, Family Health Manager Tobie Mathew, Health Promotion Consultant – Early Child Development Project Karen Wade, Clinical Nurse Specialist, Planning & Policy – Family Health Mary Lou Walker, Family Health Manager Karen Whitworth, Mental Health Manager Copyright: Copyright of this document is owned by University Health Network Women’s Health Program. The document has been reproduced for purposes of disseminating information to health and social service providers, as well as for teaching purposes. Citation: The following citation should be used when referring to the entire document. Specific chapter citations are noted at the beginning of each chapter. Stewart, D.E., Robertson, E., Dennis, C-L., Grace, S.L., & Wallington, T. (2003). Postpartum depression: Literature review of risk factors and interventions. POSTPARTUM DEPRESSION: LITERATURE REVIEW OF RISK FACTORS AND INTERVENTIONS Table of Contents EXECUTIVE SUMMARY 2 OVERALL METHODOLOGICAL FRAMEWORK 5 CHAPTER 1: RISK FACTORS FOR POSTPARTUM DEPRESSION 9 Emma Robertson PhD, Nalan Celasun PhD, Donna E. Stewart MD FRCPC CHAPTER 2: DETECTION, PREVENTION AND TREATMENT OF POSTPARTUM DEPRESSION 71 Cindy-Lee Dennis RN PhD CHAPTER 3: THE EFFECT OF POSTPARTUM DEPRESSION ON THE MOTHER-INFANT RELATIONSHIP AND CHILD GROWTH AND DEVELOPMENT 197 Sherry L. Grace PhD, Stephanie Sansom MA CHAPTER 4: PUBLIC HEALTH INTERVENTIONS......

Words: 108533 - Pages: 435

Premium Essay

Mgmt490

...Annals of Internal Medicine Clinical Guidelines Screening Mammography in Women 40 to 49 Years of Age: A Systematic Review for the American College of Physicians Katrina Armstrong, MD, MSCE; Elizabeth Moye, BA; Sankey Williams, MD; Jesse A. Berlin, ScD; and Eileen E. Reynolds, MD Background: The risks and benefits of mammography screening among women 40 to 49 years of age remain an important issue for clinical practice. Purpose: To evaluate the evidence about the risks and benefits of mammography screening for women 40 to 49 years of age. Data Sources: English-language publications in MEDLINE (1966 – 2005), Pre-MEDLINE, and the Cochrane Central Register of Controlled Trials and references of selected studies through May 2005. Study Selection: Previous systematic reviews; randomized, controlled trials; and observational studies. Data Extraction: Two independent reviewers. Data Synthesis: In addition to publications from the original mammography trials, 117 studies were included in the review. Metaanalyses of randomized, controlled trials demonstrate a 7% to 23% reduction in breast cancer mortality rates with screening mammography in women 40 to 49 years of age. Screening mammography is associated with an increased risk for mastectomy but a decreased risk for adjuvant chemotherapy and hormone therapy. The risk for death due to breast cancer from the radiation exposure involved in mammography screening is small and is outweighed by a reduction in breast cancer......

Words: 14840 - Pages: 60

Free Essay

Business Process Management

...Mendling Stefan Tai (Eds.) Business Process Management 8th International Conference, BPM 2010 Hoboken, NJ, USA, September 13-16, 2010 Proceedings 13 Volume Editors Richard Hull IBM Research, Thomas J. Watson Research Center 19 Skyline Drive, Hawthorne, NY 10532, USA E-mail: hull@us.ibm.com Jan Mendling Humboldt-Universität zu Berlin, Institut für Wirtschaftsinformatik Unter den Linden 6, 10099 Berlin, Germany E-mail: contact@mendling.com Stefan Tai Karlsruhe Institute of Technology (KIT) Englerstraße 11, Gebäude 11.40, 76131 Karlsruhe, Germany E-mail: stefan.tai@kit.edu Library of Congress Control Number: 2010933361 CR Subject Classification (1998): D.2, F.3, D.3, D.1, D.2.4, F.2 LNCS Sublibrary: SL 3 – Information Systems and Application, incl. Internet/Web and HCI ISSN ISBN-10 ISBN-13 0302-9743 3-642-15617-7 Springer Berlin Heidelberg New York...

Words: 147474 - Pages: 590

Premium Essay

Daimler-Chrysler Merger Portrayal

...Technology Rights Department in Oxford, UK: phone: (+44) 1865 843830, fax: (+44) 1865 853333, e-mail: permissions@elsevier.com.uk. You may also complete your request on-line via the Elsevier homepage (http://elsevier.com), by selecting “Customer Support” and then “Obtaining Permissions.” Recognizing the importance of preserving what has been written, Elsevier prints its books on acid-free paper whenever possible. Library of Congress Cataloging-in-Publication Data Rao, Madanmohan. KM tools and techniques : practitioners and experts evaluate KM solutions / Madanmohan Rao. p. cm. Includes bibliographical references and index. ISBN 0-7506-7818-6 (alk. paper) 1. Knowledge management. 2. Organizational learning. 3. Knowledge management—Data processing. 4. Management information systems. 5. Information resources management. 6. Database management. I. Title Knowledge management tools and techniques. II. Title. HD30.2.R356 2004 658.4¢038—dc22 2004050698 British Library...

Words: 182966 - Pages: 732

Free Essay

Tic Tac Toe

...EBizPort: Collecting and Analyzing Business Intelligence Information Byron Marshall, Daniel McDonald, Hsinchun Chen, and Wingyan Chung Artificial Intelligence Lab, Management Information Systems Department, University of Arizona, Tucson, AZ 85721. E-mail: {byronm, dmm, hchen, wchung}@eller.arizona.edu To make good decisions, businesses try to gather good intelligence information. Yet managing and processing a large amount of unstructured information and data stand in the way of greater business knowledge. An effective business intelligence tool must be able to access quality information from a variety of sources in a variety of forms, and it must support people as they search for and analyze that information. The EBizPort system was designed to address information needs for the business/IT community. EBizPort’s collection-building process is designed to acquire credible, timely, and relevant information. The user interface provides access to collected and metasearched resources using innovative tools for summarization, categorization, and visualization. The effectiveness, efficiency, usability, and information quality of the EBizPort system were measured. EBizPort significantly outperformed Brint, a business search portal, in search effectiveness, information quality, user satisfaction, and usability. Users particularly liked EBizPort’s clean and user-friendly interface. Results from our evaluation study suggest that the visualization function added value to the search and...

Words: 14368 - Pages: 58

Premium Essay

Project Management

...au or marked for the attention of the permissions editor at the address below. National Library of Australia Cataloguing-in-Publication Data Author: Title: Published in Australia by McGraw-Hill Education (Australia) Pty Ltd Level 2, 82 Waterloo Road, North Ryde, NSW 2113 Publisher: Norma Angeloni-Tomaras Development editor: Alex Payne Senior production editor: Claire Linsdell Permissions editor: Haidi Bernhardt Copy editor: Julie Wicks Proofreader: Angela Damis Indexer: Mary Coe Design coordinator: Dominic Giustarini Cover design: Christa Mo tt Internal design: Georgette Hall Typeset in Minion Pro Regular 9.5/12 pt by SR Nova Printed in China on 70 gsm matt art by CTPS Sa m Pearson, Neil. roject Project management in practice: for the certi cate IV and Diploma of Project Management in the BSB07 training package / Neil Pearson, Erik W. Larson, Cli ord F. Gray. ISBN: 9781743077238 (pbk.) Notes: Includes...

Words: 33240 - Pages: 133

Premium Essay

Kelly & Nokes

...Now the perfect companion for anyone sitting the PMI’s PMBOK exams THE DEFINITIVE 2ND EDITION PROJECT MANAGEMENT THE FAST TRACK TO GETTING THE SEBASTIAN NOKES AND SEAN KELLY GUIDE TO JOB DONE ON TIME AND ON BUDGET the definitive guide to project management In an increasingly competitive world, we believe it’s quality of thinking that gives you the edge – an idea that opens new doors, a technique that solves a problem, or an insight that simply makes sense of it all. The more you know, the smarter and faster you can go. That’s why we work with the best minds in business and finance to bring cutting-edge thinking and best learning practice to a global market. Under a range of leading imprints, including Financial Times Prentice Hall, we create world-class print publications and electronic products bringing our readers knowledge, skills and understanding, which can be applied whether studying or at work. To find out more about Pearson Education publications, or tell us about the books you’d like to find, you can visit us at www.pearsoned.co.uk the definitive guide to project management the fast track to getting the job done on time and on budget Second Edition SEBASTIAN NOKES AND SEAN KELLY PEARSON EDUCATION LIMITED Edinburgh Gate Harlow CM20 2JE United Kingdom Tel: +44(0)1279 623623 Fax: +44(0)1279 431059 Website: www.pearsoned.co.uk First published 2003 Second edition published in Great Britain 2007 © Aldersgate Partners LLP 2003 © Casnus......

Words: 144594 - Pages: 579

Premium Essay

Holly Farm

...Robert Johnston Stuart Chambers Christine Harland Alan Harrison Nigel Slack Cases in Operations Management third edition Cases in Operations Management We work with leading authors to develop the strongest educational materials in operations management, bringing cutting-edge thinking and best learning practice to a global market. Under a range of well-known imprints, including Financial Times Prentice Hall, we craft high quality print and electronic publications which help readers to understand and apply their content, whether studying or at work. To find out more about the complete range of our publishing, please visit us on the World Wide Web at: www.pearsoneduc.com THIRD EDITION Cases in Operations Management Robert Johnston Warwick Business School, University of Warwick Stuart Chambers Warwick Business School, University of Warwick Christine Harland School of Management, University of Bath Alan Harrison Cranfield School of Management, Cranfield University Nigel Slack Warwick Business School, University of Warwick Pearson Education Limited Edinburgh Gate Harlow Essex CM20 2JE United Kingdom and Associated Companies throughout the world Visit us on the World Wide Web at: www.pearsoned.co.uk First published 1993 Second published 1997 Third Edition 2003 © Robert Johnston, Stuart Chambers, Christine Harland, Alan Harrison and Nigel Slack 1993, 2003 The rights of Robert Johnston, Stuart Chambers, Christine Harland, Alan Harrison...

Words: 207956 - Pages: 832

Premium Essay

World Report

...to investment and enterprise development in the United Nations System. It builds on three and a half decades of experience and international expertise in research and policy analysis, intergovernmental consensus-building, and provides technical assistance to developing countries. The terms country/economy as used in this Report also refer, as appropriate, to territories or areas; the designations employed and the presentation of the material do not imply the expression of any opinion whatsoever on the part of the Secretariat of the United Nations concerning the legal status of any country, territory, city or area or of its authorities, or concerning the delimitation of its frontiers or boundaries. In addition, the designations of country groups are intended solely for statistical or analytical convenience and do not necessarily express a judgment about the stage of development reached by a particular country or area in the development process. The major country groupings used in this Report follow the classification of the United Nations Statistical Office. These are: Developed countries: the member countries of the OECD (other than Chile, Mexico, the Republic of Korea and Turkey), plus the new European Union member countries which are not OECD...

Words: 156270 - Pages: 626