Finance industry-based organization

Assignment Help Database Management System
Reference no: EM13190244

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:

  1. Create a data dictionary that includes the following:
    1. A description of the content for each field
    2. The data type of each field
    3. The format the data will be stored as in the field
    4. The range of value for the field
    5. A label, as required, if the attribute is a primary key or foreign key

Note:An example is shown in Table 7.3 in chapter 7 of the textbook.

  1. 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:
    1. 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.
    2. Construct a query to show the expected payment date if invoices are due within 30 days of transaction.
    3. Construct a query that will show distinct area codes of the customers.
  2. Create a plan of the necessary activities that would be required to implement a valid database design process by including the following:
    1. Steps in the conceptual design stage
    2. Steps in DBMS selection stage
    3. Steps in logical design stage
    4. Steps in physical design stage
    5. Task details of each activity within each stage

Reference no: EM13190244

Questions Cloud

Descibe what is intellectual property : Identify the IP rights that are owned by an organization you currently or formerly have worked at. Explain which intellectual property appears the most difficult for a business owner to protect.
Find the equation of the line for the demand equation : a market research company finds that at a price of p=$20, they would sell x=42 tiles each month. If they lower the price to p=$10, then more people would purchase &they can expect to sell x=52 tiles in one month, find the equation of the line for ..
Describe the development of the international space station : Take a stand on whether or not economic growth really makes people better off in the long term. Provide support for your response. Give your opinion on whether or not the development of the International Space Station stimulated economic growth. J..
Reviewing the existing data on seasonal spending : After reviewing the existing data on seasonal spending by his company's customers, Marvin decided he needed new information collected to address his research questions. Marvin will need ___________________ data to address the questions in his market ..
Finance industry-based organization : 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
What is the speed on each part of the trip\ : eist travels 34 miles at a certain speed. The conoeist travels 6 miles on the second part of the trip at a speed at 5 mph slower. The total time of the trip is 5 hours. What is the speed on each part of the trip.
Explain the unemployment and inflation : Analyze how inflation could occur in a society that relies exclusively on barter versus money. Speculate what form inflation would take and how you would recognize it. Provide support for your response.
What is a function rule to represent this situation : Each single burger contains 430 calories. What is a function rule to represent this situation?
Propose an efficient data structure : Propose an efficient data structure that may hold the tour operator's data using a normalization process. Describe each step of the process that will enable you to have a 2nd Normal Form data structure.

Reviews

Write a Review

 

Database Management System Questions & Answers

  Write an application that creates a database named phonebook

Write an application that creates a database named PhoneBook. The database should have a table named Entries, with columns for a person's name and phone number. Next, write an application that lets the user add rows to the Entries table,

  Use three-sphere model for systems management

Use the three-sphere model for systems management and brainstorm issues related to the change based on the business, technology, and organization spheres.

  How database solve multiple concurrent data management issue

Investigate how databases solve multiple concurrent data management issues comprising lost updates, deadlocks and different kinds of lock management styles.

  Relational algebra operations

List the sequence of relational algebra operations needed to implement the queries.

  Develop basic tools to expedite use of oracles dictionary

Write a script that provides all of the information in, and duplicates the formatting of, Oracle's SQL*Plus describe command. Additionally, the output should add the comments on the rows. Input: owner and table name. Output: columns for Name, Null..

  Essay on data mining in warehouse architectures

Course: data mining. Require a 7 page essay on subjects: Warehouse Architectures: the paper requires to contain information about centralized, federated, and tiered data warehouse.

  Describing the select statement

Data processing needs taking or receiving the data from a source and doing something with it. The same can be said about the transaction processing. When working along with a file, whether it be a fixed length.

  Design and implement a small database application

Perform the conceptual database design using Entity-Relationship model. You must submit the Entity-Relationship diagram of your database and develop queries in the target DBMS

  How protocol ensures serializability and deadlock freedom

To lock any other vertex, the transaction must have visited all the parents of that vertex and must be having a lock on one of the parents of the vertex. Show that the protocol ensures serializability and deadlock freedom.

  Give preliminary information on data requirements for gis

You have been requested to give preliminary information on the data requirements for a GIS which is to be used to hold inventory of continental scale vegetation maps for coarse scale land surface

  Based on the schema write sql statements

Based on the schema write SQL statements and provide the equivalent relational algebra expressions - relational algebra expressions return and give the equivalent SQL statements.

  Explain the problems associated with data redundancy

Assignment 5: Logical Design, Part II, Explain the problems associated with data redundancy as it pertains to effectively using information for reporting and analysis.

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