Reference no: EM13924994
Assignment: SQL Concepts and Database Design
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
Note: An example is shown in Table 7.3 in chapter 7 of the textbook.
2. 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:
|
Approximate real rate of return on this investment
: Last year, you purchased a stock at a price of $53 a share. Over the course of the year, you received $2 in dividends and inflation averaged 2.8 percent. Today, you sold your shares for $53.9 a share. What is your approximate real rate of return on t..
|
|
What is the reorder point for the company
: What is the reorder point for the company if it decides on a 99% service level?
|
|
Which company had the better solvency i
: Based on the ratios computed in Requirements a and b, which company had the better solvency in 2010?
|
|
Projects unit sales for a new seven-octave voice emulation
: Aria Acoustics, Inc. (AAI), projects unit sales for a new seven-octave voice emulation implant as follows: Year Unit Sales 1 78,000 2 91,000 3 105,000 4 100,000 5 81,000 Production of the implants will require $1,570,000 in net working capital to sta..
|
|
Sql concepts and database design
: 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.
|
|
Discuss relevance of the portfolio approach to credit risk
: Discuss the relevance of the portfolio approach to credit risk management given the fact that the banks and financial institutions themselves are borrowers with high levels of leverage.
|
|
Part of assessing the writing situation
: Review your reading about the writing situation, and write a 100-200 word essay-style response. Consider the following questions as a guide for constructing your response: What part of assessing the writing situation, finding your subject, definin..
|
|
Almond corporation
: Almond Corporation, organized on January 3, 2013, had pretax accounting income of $14 million and taxable income of $20 million for the year ended December 31, 2013. The 2013 tax rate is 35%
|
|
Explain how the credit portfolio study would facilitate
: Explain how the credit portfolio study would facilitate or assist the liquidity management of the financial institution or bank.
|