Imagine that you labor for a finance industry-based construction. Your construction is looking to propound its factsbase scheme munimentation to an evaluation team in prescribe to unite Sarbanes-Oxley (SOX) yielding. You accept been assigned to second in preparing the munimentation of the construction’s sales factsbase. You are asked to propound a facts glossary that can be used to muniment the ensueing:
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 indecent (3-4) page tract in which you:
Create a facts glossary that includes the ensueing:
A description of the full for each field
The facts mark of each field
The format the facts succeed be stored as in the field
The order of appraise for the field
A mark, as required, if the manifestation is a original key or irrelevant key
Note: An pattern is pretencen in Table 7.3 in section 7 of the textbook.
Imagine that you are asked to demonstrate the compute of days that insist between the earliest invoice and ultimate invoice for each month and finished the ensueing:
Construct a question that succeed pretence the compute of days that insist between the earliest invoice and ultimate invoice, for each month, for each employee, using the DATEDIFF character. Be firm to arrange the SQL script that succeed push out this character.
Construct a question to pretence the expected cancelment time if invoices are due amid 30 days of performance.
Construct a question that succeed pretence independent area codes of the customers.
Create a guile of the indispensable activities that would be required to utensil a operative factsbase scheme way by including the ensueing:
Steps in the conceptual scheme stage
Steps in DBMS choice stage
Steps in argumentative scheme stage
Steps in tangible scheme stage
Task details of each apparition amid each stage
Your assignment must ensue these formatting requirements:
Be markd, inclose spaced, using Times New Roman font (extent 12), after a while one-inch margins on all sides; citations and allusions must ensue APA or school-peculiar format. Check after a while your adherent for any additional instructions.
Include a overspread page containing the artificeate of the assignment, the student’s artificeate, the adherent’s artificeate, the line artificeate, and the time. The overspread page and the allusion page are not interposed in the required assignment page diffusiveness.
The peculiar line letters outcomes associated after a while this assignment are:
Design a notional factsbase so that it is at meanest in 3NF.
Prepare factsbase scheme muniments using the facts restriction, facts make, and facts manage discourse components of the SQL discourse.
Explain the key principles of facts carelessness and demonstrate facts carelessness destroy and violations in facts skill classification scheme.
Use technology and notice media to discovery issues in the strategic implications and skill of factsbase classifications.
Write distinctly and concisely encircling topics connected to the strategic guilening for factsbase classifications using becoming congruity mechanics and technical name conventions.