Reference no: EM13333342
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)
1. 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
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:
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.
3. 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
|
Divorce case knowledge that the wife is pregnant
: Under our statue requiring that a petition disclose whether there are any children under ages of 16, making it obligatory upon the court to make such orders respecting custody and support as is best for the child or children, is an attorney guilty of..
|
|
Financial reporting environment for the quarter
: Prepare a 2 page newsletter that identifies and summarises developments and changes in the financial reporting environment for the quarter from January to March 2013.
|
|
What is the estimated cost of common equity using the capm
: Booher Book Stores has a beta of 1.3. The yield on a 3-month T-bill is 5% and the yield on a 10-year T-bond is 6.5%. The market risk premium is 6%. What is the estimated cost of common equity using the CAPM
|
|
The canons of ethics and statutes limit
: To what extent do the Canons of Ethics and Statutes limit the practice of a member of the State Bar who is also a county judge?
|
|
Create a data dictionary
: 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.
|
|
How would this influence the mc andavc curves
: If output totals double, how would this influence the MC and AVCcurves? If the price of labor triples, how would this influence the MC andAVC curves?
|
|
Find what is the projects equivalent annual cost or eac
: A five-year project has an initial fixed asset investment of $300,000, an initial NWC investment of $28,000, and an annual OCF of -$27,000. The fixed asset is fully depreciated over the life of the project and has no salvage value.
|
|
What will be the current value of a share of avrils stock
: avril synchronistics will pay a dividend of $1.30 per share this year. it is expected that this dividend will grow by 5% each year in the future.
|
|
The elasticity of demand tends to be negative by same logic
: In output markets, the elasticity of supply tends to be 'positive'.Is it because supply curve is positive? then the elasticity of demandtends to be negative by same logic?
|