Database paper

Assignment Help Term Paper
Reference no: EM13780694

Imagine that you work for a finance industry-based organization. Your organization is looking to submit its database design documentation to an evaluation team in order to meet Sarbanes-Oxley (SOX) compliance.

You have been assigned to assist in preparing the documentation of the organization's sales database. You are asked to propose a data dictionary that can be used to document the following: Employee (EmpNumber, EmpFirstName, EmpLastName, CommissionRate, YrlySalary, DepartmentID, JobID) Invoice (InvNumber, InvDate, EmpNumber, InvAmount, CustomerID) InvoiceLine (InvLineNumber, InvNumber, ProductNumber, Quantity) Product (ProductNumber, ProductDescription, ProductCost) Department (DepartmentID, DepartmentDescription) Job (JobID, JobDescription)

Customer (CustomerID, CustomerName, CustomerAddress, CustomerPhone) Write a three to four (3-4) page paper in which you: Create a data dictionary that includes the following:

A description of the content for each field The data type of each field The format the data will be stored as in the field . Imagine that you are asked to identify the number of days that exist between the first invoice and last invoice for each month and complete the following: Construct a query that will show the number of days that exist between the first invoice and last invoice, for each month, for each employee, using the DATEDIFF function.

Be sure to provide the SQL script that will carry out this function. Construct a query to show the expected payment date if invoices are due within 30 days of transaction. Construct a query that will show distinct area codes of the customers.

Create a plan of the necessary activities that would be required to implement a valid database design process by including the following:Steps in the conceptual design stage Steps in DBMS selection stage Steps in logical design stage Steps in physical design stage

Task details of each activity within each stage 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.

Reference no: EM13780694

Questions Cloud

Biotic structure of ecosystem : Name and describe the roles of the three main trophic categories that make up the biotic structure of every ecosystem. Give examples of organisms from each category.
What are the most urgent health care policy issues : What are the most urgent health care policy issues that must be addressed as society deals with issues challenging health care delivery, such as baby boomers, technology and disease management
Difference between disparity and discrimination : Compare and contrast the difference between disparity and discrimination in the criminal justice system. Locate one current event that relates to either one of these terms and summarize the issue and discuss the outcome
How learning experience reflect culturally relevant pedagogy : Descriptions of how the learning experiences reflect culturally relevant pedagogy. Description of how the school and/or program encourages teachers to be more creative in their approach to teaching
Database paper : Imagine that you work for a finance industry-based organization. Your organization is looking to submit its database design documentation to an evaluation team in order to meet Sarbanes-Oxley (SOX) compliance.
The dialectical movement of the divine self-mediation : According to Marx, one of the bad things about capitalism is that it alienates workers from their species-being. What does Marx mean by this? Do you agree or disagree?
What is the best evidence rule : What is the best evidence rule? Explain in detail. Why was the best evidence rule implemented into the U.S. court system? Explain. What is the rationale behind its application
What are the purposes of dna testing : What are the purposes of DNA testing? Explain in detail. Provide examples where necessary. What is law enforcement's role in making DNA testing possible today when it was not possible 15-20 years ago? Explain
Healthcare practice needs a marketing plan : Describe the main reasons why the healthcare practice needs a marketing plan as outlined in the video.

Reviews

Write a Review

Term Paper Questions & Answers

  Generation and evaluation of alternative solutions

Write two pages for "Generation and Evaluation of Alternative Solutions" for Love Canal case. Total 2 Pages for "Generation and Evaluation of Alternative Solutions" for love canal case and including references.

  Paper on deming theory

Paper on Deming theory: Dr. W. Edwards Deming developed a method for the quality improvement process. He believed that the identification and correction of defects after production is not effective.

  Paper on what does autism play in savant syndrome

Write a Paper on Topic:   What does autism play in savant syndrome?

  Write a paper on italy and its democracy

Write a Paper on Topic:  Italy and Its Democracy,  Affecting the Event by “The Economist” and  Democracy Appear to Work with including references.

  Climate change and the north

The essay topic is: Climate Change and the North (with particular Focus on the Inuit).  The purpose of this research paper is to help you engage with current events and contemporary challenges concerning Aboriginal people in Canada.

  Should manitoba adopt a single transferable vote

Write a paper on Topic: Should Manitoba adopt a single transferable vote (STV) electoral system for provincial elections?

  In crisis and reform

In Crisis and Reform:  Current Issues in American Punishment (p. 126), Alexis Durham writes,Please write a reaction paper (4-6 pages in length) to the quote in which you explore global correctional objectives

  Role play as the corporate social responsibility officer

Your Corporate Social Responsibility Officer  Handout and Rubric, This paper gives you an opportunity to "role play" as the Corporate Social Responsibility Officer for an organization of your choice.

  Operationalize sustainability

This assignment is designed for you to analyze an organization and to help develop a plan for that organization to better Operationalize sustainability in the future.

  Gulliver''s view of science

Write on  Gullivers view of science or politics, Jonathan Swift’s view about science is explicitly portrayed in this novel Gulliver’s travel. Jonathan swift says the scientific researches and the experiments will be utter waste of time and it will be..

  Designing a computer interface with visual disability

The topic is about designing a computer interface to people with visual disability (blindness- colour blindness) also , how to apply decision support systems to such interfaces..

  Social issue

Answer the following questions as these general questions pertain to the specific issue selected.The questions that you will cover with respect to your choice of broad social issue in the paper are given.

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