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:

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) ________.

User Account

All Pages