Reference no: EM13916949
The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maintained Oracle server. 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
|
Process costing system
: The Gasson Company uses the weighted-average method in its process costing system. The company's ending work in process inventory consists of 11,000 units, The ending work in process inventory is 100% complete with respect to materials and 60% comple..
|
|
Description of the compliance issue
: Write a 1,050- to 1,200- word paper that includes the following: A description of the compliance issue that led to the lawsuit and its ramifications for the organization.
|
|
Assumptions required for statistical tests
: Now create probability-probability (p-p) plots for each variable. This output will give you additional information. Read over the Case Processing Summary. Notice that there is missing data for Days 2 and Day 3. Copy only the Normal p-p Plots into ..
|
|
What is relationship of liabilities and stockholder equity
: When you contrast the liability of the balance sheet for a manufacturing firm to that of financial services company, why would you expect to see a significant difference in the liquidity of the liabilities?
|
|
Test and compile the sql queries
: The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maintained Oracle server.
|
|
Find the mean and variance of the number of spam emails
: It has been known from the past experience that two percents of your emails are spam. Suppose you will receive 200 emails. Find the mean and variance of the number of spam emails among those
|
|
What is the danger of excessive liquidity
: What is meant by aging of accounts receivables, and how can it be usefully applied? What is the biggest obstacle in forecasting a firm's future financial performance and how can financial statements help?
|
|
Managerial report for reep construction
: The main objective of Bob Reep is acquiring a lease that would potentially minimize the monthly cost of meeting trucking requirements for a new project without dismissing off the employees i.e. following his no-layoff policy and using personal driver..
|
|
What proportion of students in the course would pass
: The final score in a statistics course follows a normal distribution with mean 68 and standard deviation 12. What proportion of students in the course would pass if they need at least 50 to pass in the course
|