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: http://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

Premium Essay

Cis 517 Assignment 2

...February 17, 2013 CIS 517 Project Management Dr. Huang Project Title: Green Computing Research Project Project Manager: Rotunda Robinson rrobinson@GCRS.com Requirements Traceability Matrix Requirement No. Name Category Source Status 1 Data Center Building Project Charter Accepted 2 Recycling Building Project Charter Accepted 3 Office Material Operations Project Charter Accepted 4 User Support and Training Operations Project Charter Accepted 5 Working from home Operations Project Charter Accepted 6 Hours of Operation Operations Project Charter Accepted 7 Environmental Friendly Operations Project Charter Accepted 8 CPU & Laptops Hardware Project Charter Accepted 9 Cloud and Virtualization Software Project Charter Accepted 10 Open Source Software Software Project Charter Accepted 11 Solar Computing Energy Source Project Charter Accepted 12 Electricity Outputting Energy Source Project Charter Accepted 13 Power Management Energy Source Project Charter Accepted List of Questions to ask the Sponsors I. When will you expect this project to be completed? II. What are your expectations? III. Do you have any additional resources that could be of assistance to the project? IV. How strenuous will be the training on the new hardware and software? V. Do you have any suggestions? VI. Are there any green technologies available in the area? Project Charter: • Helping to improve the......

Words: 356 - Pages: 2

Free Essay

Cis 505 Assignment 2

...Information today is driving society. Finding the solution to successfully managing it, however, is the gateway to unlimited potential. Imagine only three (3) points are to be rolled out in the first phase. Evaluate each point to determine the most important three (3) for the initial rollout phase. 1.Providing computing capability to all organizational units that legitimately require it. It means to make all the computers extremely fast, accurate and reliable. Can handle large volumes of repetitive tasks. Can store large amounts of information and can recall instantly. Can communicate with its operators and with other machines. It is capable of interactive processing in which the user is put in direct communications with machine. 2.Contain the capital and operations cost in provision of computing services within the organization. Make sure you have a good understanding of all operating expenses associated with the operation of income producing properties.  The On Target investment analysis software can help you assess the impact of operating expenses on an investment property’s income and cash flow.  It provides comprehensive income and expense analysis to assist with the purchase of income producing properties and presentation quality reports to help with the sale. 3.Satisfy special computing needs of user departments. Ask yourself what you need for a computer. What is the main function of whether the computer should be able to do and to meet and what......

Words: 1390 - Pages: 6

Free Essay

Cis 515 Week 5 Assignment

...CIS 515 Week 5 Assignment http://hwguiders.com/downloads/cis-515-week-5-assignment/ Tours Company System – Database Implementation Your Name Your College Your University Date A1 – a) Below is the data model for 2nd Normal form for travel company. Their table name and column names are mentioned in the table. SalesPersonDetails EmployeeId FirstName LastName ToursSold Integer Text Text Integer CustomersData CustomerID CustomerName Address City State ZipCode Integer Text Text Text Text Text CustomerTourDetails CustomerID TourID Numberof PersonsinTour TotalAmount Paid Integer Integer Integer Integer TourDetails TourSeason TourID TourRates PerPerson Date Integer Integer Integer A 1 – b) Table Name: SalesPerson Attributes: EmployeeID, FirstName, LastName, ToursSold Table Name: CustomersData Attributes: CustomerID, CustomerName, Address, city, State, ZipCode For More Information hit Purchase Button to Get Your Assignment CIS 515 Week 5 Assignment http://hwguiders.com/downloads/cis-515-week-5-assignment/ Tours Company System – Database Implementation Your Name Your College Your University Date A1 – a) Below is the data model for 2nd Normal form for travel company. Their table name and column names are mentioned in the......

Words: 1984 - Pages: 8

Free Essay

Cis 515 Week 5 Assignment

...CIS 515 Week 5 Assignment http://hwguiders.com/downloads/cis-515-week-5-assignment/ Tours Company System – Database Implementation Your Name Your College Your University Date A1 – a) Below is the data model for 2nd Normal form for travel company. Their table name and column names are mentioned in the table. SalesPersonDetails EmployeeId FirstName LastName ToursSold Integer Text Text Integer CustomersData CustomerID CustomerName Address City State ZipCode Integer Text Text Text Text Text CustomerTourDetails CustomerID TourID Numberof PersonsinTour TotalAmount Paid Integer Integer Integer Integer TourDetails TourSeason TourID TourRates PerPerson Date Integer Integer Integer A 1 – b) Table Name: SalesPerson Attributes: EmployeeID, FirstName, LastName, ToursSold Table Name: CustomersData Attributes: CustomerID, CustomerName, Address, city, State, ZipCode For More Information hit Purchase Button to Get Your Assignment CIS 515 Week 5 Assignment http://hwguiders.com/downloads/cis-515-week-5-assignment/ Tours Company System – Database Implementation Your Name Your College Your University Date A1 – a) Below is the data model for 2nd Normal form for travel company. Their table name and column names are mentioned in the......

Words: 1984 - Pages: 8

Free Essay

Cis 515 Week 6 Assignment

...• CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment • CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment • CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment • CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment • CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment • CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment • CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment • CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment • CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment • CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment • CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment • CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment • CIS 515 Week 6......

Words: 590 - Pages: 3

Free Essay

Cis 515 Week 6 Assignment

...CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6 Assignment http://hwguiders.com/downloads/cis-515-week-6-assignment/ CIS 515 Week 6 Assignment CIS 515 Week 6......

Words: 760 - Pages: 4

Premium Essay

Cis 106 Assignment 2

... A Computer Home Network Jerry Battle Instructor: Dr. Phillip Duncan CIS 106 June 12, 2015 HP Officejet Pro 6830 Printer IP: 192.168.1.84 HP Officejet Pro 6830 Printer IP: 192.168.1.84 Samsung 55’’ SmartTV Samsung 55’’ SmartTV Lenovo All-In-One PC # 1 Media IP: 192.168.1.79 Lenovo All-In-One PC # 1 Media IP: 192.168.1.79 Laptop #1 Lenovo G50 Notebook IP: 192.168.1.73 Laptop #1 Lenovo G50 Notebook IP: 192.168.1.73 Laptop # 2 Lenovo G50 Notebook IP: 192.168.1.75 Laptop # 2 Lenovo G50 Notebook IP: 192.168.1.75 Samsung Blue-Ray Player Samsung Blue-Ray Player Ethernet Switch Ethernet Switch Wireless Broadband Router Wireless Broadband Router AT&T Home Internet AT&T Home Internet Laptop # 1 Laptop # 2 Acct # 1 Mr. Battle Acct # 1 Joshua Admin Rights, Admin Rights Acct# 2 Ms. Battle Acct # 4 Jaylen Basic User Rights Basic User Rights My Home Network My home network consists of the basic 4 computers and network devices that are need to create a small home network. The hardware that I purchase all came for the same vendor. I have purchased many computer devices from Tiger Direct Store and have always been very pleased with the quality. Below summarizes the hardware that I purchased to setup my home network. 1. Laptop: I chose to purchase the 2 Lenovo G50 Notebook. This laptop is ideal for use at home. G50 Notebook has a 15’’......

Words: 1186 - Pages: 5

Free Essay

Cis 525 Week 2 Assignment 1

...CIS 525 WEEK 2 ASSIGNMENT 1 A+ Graded Tutorial Available At: http://hwsoloutions.com/?product=cis-525-week-2-assignment-1 Visit Our website: http://hwsoloutions.com/ Product Description CIS 525 Week 2 Assignment 1, Assignment 1: Agile versus Waterfall Due Week 2 and worth 80 points The following resources may be helpful when completing this assignment. •Agile vs. waterfall methodology (http://agileintro.wordpress.com/2008/01/04/waterfall-vs-agile-methodology/). •Understanding the pros and cons of the waterfall model of software development. Retrieved from TechRepublic Website (http://www.techrepublic.com/article/understanding-the-pros-and-cons-of-the-waterfall-model-of-software-development/6118423). •Transitioning from waterfall to iterative development. Retrieved from IBM DeveloperWorks Website (http://www.ibm.com/developerworks/rational/library/4243.html). Agile approach to project management has become more and more popular in recent years. Agile framework is different from traditional waterfall model. It has considerable impact on how projects are planned and executed. Imagine that you have been assigned as a project manager to manage your company’s e-Commerce Website where customers can browse the company’s products, place orders, and interact with the company’s customer service representatives. Your project must be completed in three (3) months and you have about twelve (12) people in the team. There are three (3) offshore developers in Ireland and two...

Words: 429 - Pages: 2

Free Essay

Cis 417 Week 2 Assignment 1

...CIS 417 WEEK 2 ASSIGNMENT 1 To purchase this visit here: http://www.activitymode.com/product/cis-417-week-2-assignment-1/ Contact us at: SUPPORT@ACTIVITYMODE.COM CIS 417 WEEK 2 ASSIGNMENT 1 – COMPUTER FORENSIC OVERVIEW Suppose you were recently hired for a new position as the computer forensics specialist at a mediumsized communications company. You have been asked to prepare a presentation to the Board of Directors on your main duties for the company and how your position could help achieve business goals based on security and confidentiality. You are also aware that the company has just had some issues with employee complaints of ongoing sexual harassment over email and instant messaging systems but has been unable to obtain adequate evidence of any kind. Write a two to three (2-3) page paper in which you: 1. Explain the basic primary tasks, high-level investigation processes, and challenges of a computer forensics specialist. 2. Provide an overview of how computing devices are used in crimes of today and how these crimes can affect a company’s data and information. 3. Discuss how computer forensics investigations pertain to the law and trying of cases. More Details hidden… Activity mode aims to provide quality study notes and tutorials to the students of CIS 417 Week 2 Assignment 1 – Computer Forensic Overview in order to ace their studies. CIS 417 WEEK 2 ASSIGNMENT 1 To purchase this visit......

Words: 679 - Pages: 3

Premium Essay

Cis 517 Assignment 2 Waterfall and Agile

...CIS 517 ASSIGNMENT 2 WATERFALL AND AGILE To purchase this visit here: http://www.activitymode.com/product/cis-517-assignment-2-waterfall-and-agile/ Contact us at: SUPPORT@ACTIVITYMODE.COM CIS 517 ASSIGNMENT 2 WATERFALL AND AGILE Research agile methodologies including SCRUM and extreme programming (XP). Write a two to three (2-3) page paper in which you:  Explain waterfall methodologies and identify their relationship to the PMBOK® process groups.  Explain agile methodologies and identify their relationship to the PMBOK® process groups.  Analyze the need for waterfall and agile methodologies.  Explain the advantages of extreme programming (XP) and analyze the advantages of its application in high-budget short-time projects.  Explain the factors to consider when selecting a project management methodology (Waterfall vs Agile).  Use at least two (2) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources. Your assignment must follow these formatting requirements:  Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.  Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment......

Words: 760 - Pages: 4

Premium Essay

Cis 517 Wk 2 Assignment 1 It Project

...CIS 517 WK 2 ASSIGNMENT 1 IT PROJECT To purchase this visit here: http://www.activitymode.com/product/cis-517-wk-2-assignment-1-it-project/ Contact us at: SUPPORT@ACTIVITYMODE.COM CIS 517 WK 2 ASSIGNMENT 1 IT PROJECT CIS 517 WK 2 Assignment 1 - IT Project Management Assessment Research and read an article on recent recipients of the Project Management Institute’s Project of the Year Award. Write a two to three (2-3) page paper in which you: 1. Summarize how the project manager or team exhibited exceptional and ethical project management practices. 2. Discuss the role of the project manager or team, the organizational setting, the recipient’s approach to project integration management, and obstacles that had the potential of adversely impacting the triple constraints. More Details hidden... Activity mode aims to provide quality study notes and tutorials to the students of CIS 517 WK 2 Assignment 1 IT Project in order to ace their studies. CIS 517 WK 2 ASSIGNMENT 1 IT PROJECT To purchase this visit here: http://www.activitymode.com/product/cis-517-wk-2-assignment-1-it-project/ Contact us at: SUPPORT@ACTIVITYMODE.COM CIS 517 WK 2 ASSIGNMENT 1 IT PROJECT CIS 517 WK 2 Assignment 1 - IT Project Management Assessment Research and read an article on recent recipients of the Project Management Institute’s Project of the Year Award. Write a two to three (2-3) page paper in which you: 1. Summarize how the project manager or team exhibited exceptional and......

Words: 633 - Pages: 3

Free Essay

Cis 515 Assignment 3

...CIS 515 ASSIGNMENT 3 To purchase this visit following link: http://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......

Words: 621 - Pages: 3

Free Essay

Cis 170 Assignment 2 Digital Crime Theories

...CIS 170 ASSIGNMENT 2 DIGITAL CRIME THEORIES To purchase this visit following link: http://coursehomework.com/product/cis-170-assignment-2-digital-crime-theories/ Contact us at: HELP@COURSEHOMEWORK.COM CIS 170 ASSIGNMENT 2 DIGITAL CRIME THEORIES Assignment 2 Digital Crime Theories Course Home Work aims to provide quality study notes and tutorials to the students of CIS 170 Assignment 2 Digital Crime Theories Strayer Latest in order to ace their studies. CIS 170 ASSIGNMENT 2 DIGITAL CRIME THEORIES To purchase this visit following link: http://coursehomework.com/product/cis-170-assignment-2-digital-crime-theories/ Contact us at: HELP@COURSEHOMEWORK.COM CIS 170 ASSIGNMENT 2 DIGITAL CRIME THEORIES Assignment 2 Digital Crime Theories Course Home Work aims to provide quality study notes and tutorials to the students of CIS 170 Assignment 2 Digital Crime Theories Strayer Latest in order to ace their studies. CIS 170 ASSIGNMENT 2 DIGITAL CRIME THEORIES To purchase this visit following link: http://coursehomework.com/product/cis-170-assignment-2-digital-crime-theories/ Contact us at: HELP@COURSEHOMEWORK.COM CIS 170 ASSIGNMENT 2 DIGITAL CRIME THEORIES Assignment 2 Digital Crime Theories Course Home Work aims to provide quality study notes and tutorials to the students of CIS 170 Assignment 2 Digital Crime Theories Strayer Latest in order to ace their studies. CIS 170 ASSIGNMENT 2 DIGITAL CRIME THEORIES To purchase this visit following......

Words: 721 - Pages: 3

Free Essay

Cis 510-Week 4 Assignment 2

...Creating a Use Case Samuel Ofarril Dr. Kegan, Samuel CIS 510 Strayer University July 28, 2014 Creating a Use Case In this particular diagram we are showing the basic parts of an use case diagram and the relationship that each item in the case has with each other and possibly with other use cases. The actors in the CSMS marketing subsystem are represented by stick figure that will represent the particular role that it will be playing in the diagram. The actual use case is represented by the oval figures with the name of what it represents on the inside of it. Finally you will have arrows that will demonstrate the relationship that the actors have with the use case and how they interact with each other at different points of the diagram. The first actors which are the merchandising and the marketing share the first part of the use case, add/update product information. Both of these actors depend on the correct product information in order to market it properly to the customers and they know exactly what they are getting. At the same time the merchandising actor needs to ensure that the right product information is available so they can prepare, package and ship the correct item with what the customer is expecting to receive from the company. Both share an equal importance with this use case. Next use case is the add/update promotion, this use case is only handled by the marketing actor. This actor ensures......

Words: 624 - Pages: 3

Premium Essay

Pad 515 Week 6 Assignment 2 Latest Str

...PAD 515 WEEK 6 ASSIGNMENT 2 LATEST STR To Purchase this tutorial visit following link http://wiseamerican.us/product/pad-515-week-6-assignment-2-latest-str/ Contact us at: SUPPORT@WISEAMERICAN.US PAD 515 WEEK 6 ASSIGNMENT 2 LATEST STR Use the basic outline below to draft your paper. Organize your responses to each question (except Question 5) under the following section headings: • Public Leader Overview (Question 1) • Public Leader Comparison and Contrast (Question 2) • Public Leader Evaluation & Analysis (Question 3) • Public Leader Influence (Question 4) • Conclusion Note: You may create and / or make all necessary assumptions needed for the completion of this assignment. Write a four to five (4-5) page paper in which you: 1. Based on your response to Question 3 in Assignment 1, use the Internet to research two (2) renowned public leaders—one (1) male and one (1) female—that embody your selected theory(ies) and styles. Develop a brief overview (i.e., no more than one [1] paragraph for each leader) of the selected leaders and the leadership theory that defines each as a public administrator. …… Further details are hidden… PAD 515 WEEK 6 ASSIGNMENT 2 LATEST STR Use the basic outline below to draft your paper. Organize your responses to each question (except Question 5) under the following section headings: • Public Leader Overview (Question 1) • Public Leader Comparison and Contrast (Question 2) • Public Leader Evaluation & Analysis (Question......

Words: 496 - Pages: 2