Design a query that will allow the finance department

Assignment Help Database Management System
Reference no: EM131414347 , Length: 3

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:

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 your code. Validated query code must be part of your paper.

Compare the code of the query you designed in Question one (1) to one that would show how much total compensation is paid to each employee for the same month.

Determine and explain the factors necessary to ensure referential integrity.

Create an object-oriented model to show how the tables are interrelated through the use of graphical tools. Make sure that you are able to show the relationship types such as 1:M, 1:1, or M:1. Additionally, remember to include the determined factors from the previous assignment requirement. Note: The graphically depicted solution is not included in the required page length.

Identify which data components are the entities and attributes, and the relationship between each using an object representation diagram through the use of graphical tools. Note: The graphically depicted solution is not included in the required page length.

Describe how Big Data could be used to assist in the productivity and forecasting of the organization's products and 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 page length.

Include charts or diagrams created in Excel, Visio, MS Project, or one of their equivalents such as Open Project, Dia, and OpenOffice. The completed diagrams / charts must be imported into the Word document before the paper is submitted.

The specific course learning outcomes associated with this assignment are:

Describe the role of databases and database management systems in managing organizational data and information.

Design and implement a database solution to solve a proposed business problem.

Use technology and information resources to research issues in the strategic implications and management of database systems.

Write clearly and concisely about topics related to the strategic planning for database systems using proper writing mechanics and technical style conventions.

Reference no: EM131414347

Questions Cloud

What sort of resistance would you expect from employees : Suppose you wanted to change your organization's culture. What sort of resistance would you expect from employees? How would you deal with this resistance? To what extent is culture manageable? Changeable?
Assess two different dispute resolution methods : Compare and contrast two differences between employee dismissal and employee discharge. Assess two different dispute resolution methods, in terms of their suitability for use within health care organizations.
How do the four factors in porters diamond : How do the four factors in Porter's diamond explain the success of this industry over related industries in the country? During the next five years what do you predict might happen to the software industry in India based on all that you have learne..
List specific changes that apple has made to its code : List specific changes that Apple has made to its Code of Conduct in recent years. Provide at least one example of each change. Explain the identified changes to the suppliers in such a way.
Design a query that will allow the finance department : 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, finan..
Identify specific challenges that overlapping jurisdictions : Identify the specific challenges that overlapping of jurisdictions pose in the fight against cyber-crime. Next, propose salient solution(s) for overcoming the challenges in question. Justify your response.
Compare and contrast the mis in place in two distinctly : Compare and contrast the MIS in place in two distinctly different organizations. Compare each organization's use of information systems to help manage internal operations and to make decisions. Assess how these two organizations use information tech..
What concept in the assigned reading doodling for dollars : What concept/idea in the assigned reading "Doodling for Dollars" by Rachel Silvermando you find most intriguing or useful? Why? How might you or others apply it?
Compute the average market price of the common shares : Assume that Tracey Corporation earned net income of $2 million during 2011. Compute the amount of dividends that were declared during 2011.

Reviews

Write a Review

 

Database Management System Questions & Answers

  Write sql query to select students having gpa greater than 3

Perform the following operations using SQL. Create a Database ('fdb') using any one from Oracle, Sybase, DB-2, SQL Server or MySQL. Write SQL query to select students having GPA greater than 3 and the result should be sorted according to name

  What are steps you are going to take to complete development

What are the steps you are going to take to complete the development process. You should include a detail requirements (5 pages max), suggested design and ER diagram (you can use MS Word for the diagram)

  Develop database for AITR system

You are required to develop database for AITR system, and provide system mockup for presentation session with AITR Manager - Provide a user interface to maintain reference data like Banks, Newspaper etc. Simply create some test data in your database.

  Data dictionary serves as important data management tool

The data dictionary serves as an important data management tool by? assigning attributes to the data, maintaining data in updated form.

  Method to change column name

Hhow can you change column name or what is a different way to write statement in SQL so it displays the amount column as money.

  Create an employee database

Create a report that contains the above data - be sure to include a Hampton University logo in your report.

  Configuring the authentication mode in ssms

Launch SSMS - Right-click on the SQL Server instance you want to configure and select Properties - you will configure the authentication mode for the SQL Server instance. You will ensure that the authentication mode is set to mixed mode so that the..

  Data security and data integrity

There are six problems that can be minimized by using the database approach: Data redundancy, Data isolation, Data inconsistency and Data security

  Security plan for the database

This project will help you apply all the concepts covered in this course for a given scenario. Vince Roberts runs a vintage record shop in the University district. Security plan for the database

  Explain the different oracle data dictionary views

Explain the different Oracle data dictionary views

  Why heterogeneity is a challenge for distributed system

Explain why heterogeneity is a challenge for distributed system designers and write an essay (word processor document) submitted to Blackboard that is not longer than two double-spaced pages submitted to Blackboard Assignments in the Professional E..

  Design tables in 3nf various codes for at least three fields

Create tables in 3NF. As you create the database, include different codes for at least three of the fields. Use sample data to populate fields for at least three records in each table.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd