Premium Essay

Cis 515 Assignment 2

In: Business and Management

Submitted By coursehomework
Words 494
Pages 2
CIS 515 ASSIGNMENT 2
To purchase this visit following link: https://coursehomework.com/product/cis-515-assignment-2/ Contact us at:
HELP@COURSEHOMEWORK.COM
CIS 515 ASSIGNMENT 2
CIS515 Assignment 2: Database Systems and Database Models
Instant Download
Due Week 2 and worth 90 points
The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maintained Oracle server.
Imagine that you have been hired as a consultant to assist in streamlining the data processing of an international based organization that sells high-end electronics. The organization has various departments such as payroll, human resources, finance, marketing, sales, and operations. The sales department is the only department where employees are paid a commission in addition to their yearly salary and benefits. All other departments compensate their employees with a yearly salary and benefits only. Commission is paid by multiplying the employee’s commission rate by the total amount of product units sold. You have access to the following data sets:
• Employee (EmpNumber, EmpFirstName, EmpLastName, CommissionRate, YrlySalary, DepartmentID, JobID)
• Invoice (InvNumber, InvDate, EmpNumber, InvAmount)
• InvoiceLine (InvLineNumber, InvNumber, ProductNumber, Quantity)
• Product (ProductNumber, ProductDescription, ProductCost)
• Department (DepartmentID, DepartmentDescription)
• Job (JobID, JobDescription)Write a two to three (2-3) page paper in which you:
1. Design a query that will allow the finance department to determine the commissions paid to specific employees of the sales department for the month of December. Note: You will need to generate the tables described above (Employee, Invoice, InvoiceLine, Product, Department, and Job) in order to compare and validate

Similar Documents

Free Essay

Cis 515 Assignment 3

...CIS 515 ASSIGNMENT 3 To purchase this visit following link: https://coursehomework.com/product/cis-515-assignment-3/ Contact us at: HELP@COURSEHOMEWORK.COM CIS 515 ASSIGNMENT 3 CIS515 Assignment 3: University Database – A Grade paper Instant Download Due Week 3 and worth 90 points A prestigious university has recently implemented a consolidation strategy that will require it to centralize their student records. In order to move forward, the local university will need to develop a data model that will retain student records and perform various data extract transform and load (ETL) processes. Imagine that you have been hired as a database consultant to assist in the development of a data design strategy for the student records. You met with various university subject matter experts and have determined the following after performing various business analysis processes: • Faculty groups are divided by core competencies that the university offers. For example, there are groups such as the Art Faculty, Computer Technology Faculty, Language Faculty, and Science Faculty. Each faculty member has an assigned Dean and is designated to teach at one particular campus and school. They are able to teach as many courses as required. • Courses are categorized by course code and title. Certain courses have prerequisites and the university has asked for this to be cataloged as well. • There are various schools within each campus. For example, the Los Angeles campus holds the following...

Words: 621 - Pages: 3

Premium Essay

Advanced Statistics Assignment

...MGSC 372 Fall 2014 Assignment 1 Prof. B. Smith Due Oct 4, QUESTION 1 The Pareto distribution, named after the Italian economist Vilfredo Pareto, is a probability distribution that may be used to describe social, scientific, geophysical, actuarial, and many other types of observable phenomena. Pareto originally used this distribution to describe the allocation of wealth among individuals since it seemed to show rather well the way that a larger portion of the wealth of any society is owned by a smaller percentage of the people in that society. He also used it to describe distribution of income.[8] This idea is sometimes expressed more simply as the Pareto principle or the "80-20 rule" which says that 20% of the population controls 80% of the wealth. This distribution is not limited to describing wealth or income, but to many situations in which an equilibrium is found in the distribution of the "small" to the "large". The following examples, among others, are sometimes seen as approximately Pareto-distributed: * The sizes of human settlements (few cities, many hamlets/villages. * File size distribution of Internet traffic which uses the TCP protocol (many smaller files, few larger ones) * Hard disk drive error rates The Pareto distribution function may be given as follows: fxx0,θ= θx0θx-θ-1 , ...

Words: 3761 - Pages: 16

Premium Essay

Abcd

...UNIVERSITY of PENNSYLVANIA MEAM Master of Science in Engineering Program GUIDELINES FOR GRADUATE STUDY September 2014 Mechanical Engineering and Applied Mechanics School of Engineering and Applied Science University of Pennsylvania 229 Towne Bldg., 220 S. 33rd Street Philadelphia, PA 19104-6315 meam@seas.upenn.edu www.me.upenn.edu Tel. 215-898-2826 Fax 215-573-6334 TABLE OF CONTENTS 1. Introduction .........................................................................................................................3 2. Administrative Structure .....................................................................................................3 3. Advisor(s) ............................................................................................................................3 4. Degree Requirements ..........................................................................................................4 5. General Information ............................................................................................................4 Registration ..................................................................................................................4 Leaves of Absence .......................................................................................................5 Obsoleteness ................................................................................................................5 Changes in Course...

Words: 7454 - Pages: 30

Free Essay

Mol Evolution

...The Nonsynonymous/Synonymous Substitution Rate Ratio versus the Radical/ Conservative Replacement Rate Ratio in the Evolution of Mammalian Genes Kousuke Hanada,*  Shin-Han Shiu,  and Wen-Hsiung Li* *Department of Ecology and Evolution, University of Chicago; and  Department of Plant Biology, Michigan State University There are 2 ways to infer selection pressures in the evolution of protein-coding genes, the nonsynonymous and synonymous substitution rate ratio (KA/KS) and the radical and conservative amino acid replacement rate ratio (KR/KC). Because the KR/KC ratio depends on the definition of radical and conservative changes in the classification of amino acids, we develop an amino acid classification that maximizes the correlation between KA/KS and KR/KC. An analysis of 3,375 orthologous gene groups among 5 mammalian species shows that our classification gives a significantly higher correlation coefficient between the 2 ratios than those of existing classifications. However, there are many orthologous gene groups with a low KA/KS but a high KR/KC ratio. Examining the functions of these genes, we found an overrepresentation of functional categories related to development. To determine if the overrepresentation is stage specific, we examined the expression patterns of these genes at different developmental stages of the mouse. Interestingly, these genes are highly expressed in the early middle stage of development (blastocyst to amnion). It is commonly thought that developmental genes...

Words: 5125 - Pages: 21

Free Essay

Advanced Algorithms

...Vijay V. Vazirani College of Computing Georgia Institute of Technology Copyright c 2001 Approximation Algorithms Springer Berlin Heidelberg NewYork Barcelona Hong Kong London Milan Paris Singapore Tokyo To my parents Preface Although this may seem a paradox, all exact science is dominated by the idea of approximation. Bertrand Russell (1872–1970) Most natural optimization problems, including those arising in important application areas, are NP-hard. Therefore, under the widely believed conjecture that P = NP, their exact solution is prohibitively time consuming. Charting the landscape of approximability of these problems, via polynomial time algorithms, therefore becomes a compelling subject of scientific inquiry in computer science and mathematics. This book presents the theory of approximation algorithms as it stands today. It is reasonable to expect the picture to change with time. The book is divided into three parts. In Part I we cover a combinatorial algorithms for a number of important problems, using a wide variety of algorithm design techniques. The latter may give Part I a non-cohesive appearance. However, this is to be expected – nature is very rich, and we cannot expect a few tricks to help solve the diverse collection of NP-hard problems. Indeed, in this part, we have purposely refrained from tightly categorizing algorithmic techniques so as not to trivialize matters. Instead, we have attempted to capture, as accurately as possible, the individual character...

Words: 140657 - Pages: 563

Premium Essay

Operational Performance Measurement

...and Eleanor G. Henry, “Budgeting and Performance Evaluation at the Berkshire Toy Company,” Issues in Accounting Education, 15 (2) (May 2000), pp. 283-309.) 15-2 The Mesa Corporation (Source: Robert Capettini, C. W. Chow, and J. E. Williamson, “Instructional case: the Proper Use of Feedback Information,” Issues in Accounting Education, 7 (1) (Spring 1992) pp. 48-56.) Readings 15-1: “Using Enhanced Cost Models in Variance Analysis for Better Control and Decision Making,” by Kennard T. Wing, Management Accounting Quarterly (Winter 2000), pp. 1-9. This article points out that oversimplifications of fixed and variable costs can result in the standard costing system not being used or, if used, can lead to bad decisions. That is, misclassifications of cost behavior patterns make variance analyses “paper tigers.” For variance reporting to be useful, financial managers need to develop cost models that reflect how costs actually behave. Discussion Questions: 1. Describe the implications for variance analysis of analyzing a semi-variable cost as either a variable or fixed cost. 2. Describe the implications for variance analysis of analyzing a step-fixed cost as either a variable or fixed cost. 3. Describe the implications on operating decisions of analyzing an operation with mixed costs as either a variable or fixed cost. 15-2: “Variance Analysis Refines Overhead Cost Control,” by J. C. Cooper and J. D. Suver, Healthcare Financial Management (February 1992)...

Words: 28719 - Pages: 115

Premium Essay

Econometrics Solutions Wooldrige

...have both a cross-sectional and time dimension. I spend almost an entire lecture talking about the problems inherent in drawing causal inferences in the social sciences. I do this mostly through the agricultural yield, return to education, and crime examples. These examples also contrast experimental and nonexperimental data. Students studying business and finance tend to find the term structure of interest rates example more relevant, although the issue there is testing the implication of a simple theory, as opposed to inferring causality. I have found that spending time talking about these examples, in place of a formal review of probability and statistics, is more successful (and more enjoyable for the students and me). 3 CHAPTER 2 TEACHING NOTES This is the chapter where I expect students to follow most, if not all, of the algebraic derivations. In class I like to derive at least the unbiasedness of the OLS slope coefficient, and usually I derive the variance. At a minimum, I talk about the factors affecting the variance. To simplify the notation, after I emphasize the assumptions in the population model, and assume random sampling, I just condition on the values of the explanatory variables in the sample. Technically, this is justified by random...

Words: 73034 - Pages: 293

Premium Essay

Wooldridge - Introductory Econometrics 2nd Ed. Solutions

...that have both a cross-sectional and time dimension. I spend almost an entire lecture talking about the problems inherent in drawing causal inferences in the social sciences. I do this mostly through the agricultural yield, return to education, and crime examples. These examples also contrast experimental and nonexperimental data. Students studying business and finance tend to find the term structure of interest rates example more relevant, although the issue there is testing the implication of a simple theory, as opposed to inferring causality. I have found that spending time talking about these examples, in place of a formal review of probability and statistics, is more successful (and more enjoyable for the students and me). 3 CHAPTER 2 TEACHING NOTES This is the chapter where I expect students to follow most, if not all, of the algebraic derivations. In class I like to derive at least the unbiasedness of the OLS slope coefficient, and usually I derive the variance. At a minimum, I talk about the factors affecting the variance. To simplify the notation, after I emphasize the assumptions in the population model, and assume random sampling, I just condition on the values of the explanatory variables in the sample. Technically, this is justified by random sampling...

Words: 73034 - Pages: 293

Free Essay

Management

...Op"erations Research This page intentionally left blank Copyright © 2007, 2005 New Age International (P) Ltd., Publishers Published by New Age International (P) Ltd., Publishers All rights reserved. No part of this ebook may be reproduced in any form, by photostat, microfilm, xerography, or any other means, or incorporated into any information retrieval system, electronic or mechanical, without the written permission of the publisher. All inquiries should be emailed to rights@newagepublishers.com ISBN (13) : 978-81-224-2944-2 PUBLISHING FOR ONE WORLD NEW AGE INTERNATIONAL (P) LIMITED, PUBLISHERS 4835/24, Ansari Road, Daryaganj, New Delhi - 110002 Visit us at www.newagepublishers.com PREFACE I started my teaching career in the year 1964. I was teaching Production Engineering subjects till 1972. In the year 1972 I have registered my name for the Industrial Engineering examination at National Institution of Industrial Engineering, Bombay. Since then, I have shifted my field for interest to Industrial Engineering subjects and started teaching related subjects. One such subject is OPERATIONS RESEARCH. After teaching these subjects till my retirement in the year 2002, it is my responsibility to help the students with a book on Operations research. The first volume of the book is LINEAR PORGRAMMING MODELS. This was published in the year 2003. Now I am giving this book OPERATIONS RESEARCH, with other chapters to students, with a hope that it will help them to understand...

Words: 242596 - Pages: 971

Free Essay

Hoba Lala

...Delivery and growth Royal Dutch Shell plc Annual Report and Form 20-F for the year ended December 31, 2007 Royal Dutch Shell Our Business With 104,000 employees in more than 110 countries and territories, Shell plays a key role in helping to meet the world’s growing demand for energy in economically, environmentally and socially responsible ways. Our Exploration & Production business searches for and recovers oil and natural gas around the world. Many of these activities are carried out as joint venture partnerships, often with national oil companies. Our Gas & Power business liquefies natural gas and transports it to customers across the world. Its gas to liquids (GTL) process turns natural gas into cleaner-burning synthetic fuel and other products. It develops wind power to generate electricity and invests in solar power technology. It also licenses our coal gasification technology, a cleaner way of turning coal into chemical feedstocks and energy. Our Oil Sands business, the Athabasca Oil Sands Project, extracts bitumen from oil sands in Alberta, western Canada and converts it to synthetic crude oils. Our Oil Products business makes, moves and sells a range of petroleum-based products around the world for domestic, industrial and transport use. Its Future Fuels and CO2 business unit develops fuels such as biofuels and hydrogen and synthetic fuels made from natural gas (GTL Fuel) and potentially from biomass; and leads company-wide activities on CO2 management. With...

Words: 135221 - Pages: 541

Premium Essay

Fraternity

...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 AND...

Words: 108533 - Pages: 435

Premium Essay

Organizational Behavior

...ORGANIZATIONAL BEHAVIOR CONCEPTS CONTROVERSIES APPLICATIONS Seventh Edition Stephen P. Robbins 1996 Contents Part One • Introduction Chapter 1 What Is Organizational Behavior? 2 Chapter 2 Responding to Global and Cultural Diversity 42 Part Two • The Individual Chapter 3 Foundations of Individual Behavior 80 Chapter 4 Perception and Individual Decision Making 130 Chapter 5 Values, Attitudes, and Job Satisfaction 172 Chapter 6 Basic Motivation Concepts 210 Chapter 7 Motivation: From Concepts to Applications 250 Part Three • The Group Chapter 8 Foundations of Group Behavior 292 Chapter 9 Understanding Work Teams 344 Chapter 10 Communication 374 Chapter 11 Leadership 410 Chapter 12 Power and Politics 460 Chapter 13 Conflict, Negotiation, and Intergroup Behavior 502 Part Four - The Organization System Chapter 14 Foundations of Organization Structure 548 Chapter 15 Technology, Work Design, and Stress 588 Chapter 16 Human Resource Policies and Practices 634 Chapter 17 Organizational Culture 678 Part Five - Organizational Dynamics Chapter 18 Organizational Change and Development 714 CHAPTER I • WHAT IS ORGANIZATIONAL BEHAVIOR? What Managers Do Let’s begin by briefly defining the terms manager and the place where managers work—the organization. Then let’s look at the manager’s job; specifically, what do managers do? Managers get things done through other people. They make decisions, allocate resources, and direct the activities of others to attain goals. Managers do...

Words: 146017 - Pages: 585

Free Essay

Accompagnement Stage - Chine

...1. China Mobile, empereur de la téléphonie China Mobile a de quoi faire pâlir de jalousie Orange, SFR et Bouygues réunis. Le premier opérateur mobile de Chine totalise 290 millions de clients, ce qui en fait le plus gros opérateur mobile du monde. La société est issue de la restructuration du secteur des télécommunications chinois en 2000, pour cause d'entrée dans l'organisation mondiale du commerce. - Chiffre d'affaires 2010: 24 milliards d'euros - Résultat opérationnel 2010: 7,3 milliards d'euros 2. Dongfeng, des partenariats pour mieux grandir Dongfeng Motor, troisième constructeur automobile de Chine, n'en finit plus de grandir. Son bénéfice net a augmenté de 69% au premier semestre 2009, à 107,7 millions d'euros. Une des recettes de l'entreprise : monter des co-entreprises avec des acteurs plus expérimentés, tels Honda et PSA. En 2007, Dongfeng lancera sept nouveaux modèles sous sa propre marque. Il est entré en bourse fin 2005. - Chiffre d'affaires semestriel 2010: 2,3 milliards d'euros - Résultat net semestriel 2010: 107,7 millions d'euros 3. Haier, la PME d'Etat devenue empire mondial Haier est tout simplement le symbole du capitalisme chinois. L'ex-PME d'Etat sans le sous est devenue en vingt ans un géant de l'électroménager, pesant 10,3 milliards d'euros de chiffre d'affaires en 2008 contre 2,5 milliards pour le leader français Seb. En revanche, son résultat net a baissé de 35,2% en 2009. - Chiffre d'affaires 2010: 10,3 milliards d'euros - Résultat...

Words: 14201 - Pages: 57

Premium Essay

Hjhjj

...University of South Florida Scholar Commons Textbooks Collection USF Tampa Library Open Access Collections 2012 Social Science Research: Principles, Methods, and Practices Anol Bhattacherjee University of South Florida, abhatt@usf.edu Follow this and additional works at: http://scholarcommons.usf.edu/oa_textbooks Part of the American Studies Commons, Education Commons, Public Health Commons, and the Social and Behavioral Sciences Commons Recommended Citation Bhattacherjee, Anol, "Social Science Research: Principles, Methods, and Practices" (2012). Textbooks Collection. Book 3. http://scholarcommons.usf.edu/oa_textbooks/3 This Book is brought to you for free and open access by the USF Tampa Library Open Access Collections at Scholar Commons. It has been accepted for inclusion in Textbooks Collection by an authorized administrator of Scholar Commons. For more information, please contact scholarcommons@usf.edu. SOCIAL SCIENCE RESEARCH: PRINCIPLES, METHODS, AND PRACTICES ANOL BHATTACHERJEE SOCIAL SCIENCE RESEARCH: PRINCIPLES, METHODS, AND PRACTICES Anol Bhattacherjee, Ph.D. University of South Florida Tampa, Florida, USA abhatt@usf.edu Second Edition Copyright © 2012 by Anol Bhattacherjee Published under the Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License Social Science Research: Principles, Methods, and Practices, 2nd edition By Anol Bhattacherjee First published 2012 ISBN-13: 978-1475146127 ...

Words: 39864 - Pages: 160

Premium Essay

Appollo Hospital

...Chapter 1 [pic] Introduction 1.1 Background Of The Report As being one of the biggest hospitals in Bangladesh, Apollo Hospitals Dhaka is at the forefront of medical technology and expertise and provides a complete range of the latest diagnostic, medical and surgical facilities for the care of its patients. The hospital is having all the characteristics of a world-class hospital with wide range of services and specialists, equipment, & technology, ambience and service quality. But the quality of a hospital service is not defined by the appearance of its facility. Rather the service quality depends more on the sincerity of the hospital and its human resources to serve the patients. In Bangladesh, the health care sector is not yet developed. A large number of people go abroad for treatment due to low quality of medical facilities in Bangladesh. And the main target market of Apollo Hospitals Dhaka is the people who want to get world class treatment inside the country with affordable cost. To ensure the proper customer satisfaction, the hospital management has to employ the right people in right place. Prior to this a detailed job Analysis is almost essential. With Job Descriptions and a sophisticated Job Evaluation system, management will be able to recruit and determine pay levels better, determine the types of training the hospital staff should go on and have a basis to appraise them. Job Descriptions furnished by business units are current and accurate...

Words: 24586 - Pages: 99