Evaluation team in order to meet sarbanes-oxley compliance

Assignment Help Database Management System
Reference no: EM13190253

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

Reference no: EM13190253

Questions Cloud

Derive the frequency integration formula : Derive the frequency integration formula
Who is part of the economic system : Two of the major macroeconomic measures that tell us how 'healthy' the economy is are "the unemployment Rate" and "the rate of Inflation". How do they matter to you as an individual who is part of this economic system
Find the maximum value and minimum value : Identify the critical points and find the maximum value and minimum value on the given interval g(x)=1/1+x^2 ; I=[-3,1]
Viewed in historical terms-federalism has been : Viewed in historical terms, federalism has been a
Evaluation team in order to meet sarbanes-oxley compliance : 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 compliance.
Find the total amount of interest : Find the total amount of interest that Eric and Pamela will pay over the 30 years of the mortgage.
Explain the preventing ip theft : Involving the e-Activity's testimony regarding the FBI's efforts to investigate IP theft, identify two best practices owners / executives can implement to protect against possible IP theft.
What is probability that this runner complete road race : application of the normal distribution let x denote the time taken to runner a road race. suppose x is approximately normally distributed with a mean of 195 minutes and a standard deviation of 21 minutes. if one runner is selected at random what i..
Software relates dosages-regularity and therapeutic : The software relates the dosages, regularity, and therapeutic procedures to the time taken by patients segmented across age- and illness-groups. This software is an example of a(n) ________.

Reviews

Write a Review

 

Database Management System Questions & Answers

  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.

  Draw an er diagram for database scenario

Draw an ER diagram for database scenario. Design a set of 3NF tables for your database scenario.

  What is the key for r

What is the key for R? Decompose R into 2NF, then 3NF relations and what you know about the relation to show that this MD cannot violate 4NF

  Development of an effective entity relationship model

Determine the steps in the development of an effective Entity Relationship Model (ERM) Diagram and determine the possible iterative steps

  What is the two-phase locking protocol

What is the two-phase locking protocol and what is the strict two-phase locking protocol? What is the rigorous two-phase locking protocol? What benefit does strict two-phase locking protocol provide? What benefit does rigorous two-phase locking pr..

  Criteria selecting a life-cycle model for the project

What criteria would you use in selecting a life-cycle model for the project?

  Baxter aviation database

ER diagram for the Baxter Aviation database

  Sketch object-oriented model for private airport database

Sketch an object-oriented model for a small private airport database that is used to keep track of airplanes, their owners, airport employees, and pilots.

  Advantages and inconveniences of new relational scheme

Compare activity (quite theoretical) of the disk (in number of bytes) required for each of both relational. Write down the advantages and inconveniences of new relational scheme.

  Create data warehouse sections including computers-dvds

Create a data warehouse for electronics store chain. The chain has 20 stores in 5 cities. Each store has different sections including computers, DVDs, TVs, audio, home appliances etc.

  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.

  Write table in dbdl notation after applying methodology

Proceed with all steps in information-level design to add this user view to existing cumulative design. Is this table in1st NF?___No____ . If Yes skip. If not, write Table in DBDL notation after applying the methodology we use for converting into 1NF..

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