Imagine that you operation for a finance industry-based construction. Your construction is looking to refer its postulatesbase project munimentation to an evaluation team in arcollocate to engage Sarbanes-Oxley (SOX) yielding. You keep been assigned to benefit in preparing the munimentation of the construction’s sales postulatesbase. You are asked to bring-forward a postulates wordbook that can be used to muniment the prospering:
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 disgusting (3-4) page tract in which you:
Create a postulates wordbook that includes the prospering:
A phraseology of the satisfied for each field
The postulates idea of each field
The format the postulates gain be stored as in the field
The collocate of esteem for the field
A label, as required, if the mark is a primitive key or outlandish key
Note: An illustration is exhibitionn in Table 7.3 in stipulation 7 of the textbook.
Imagine that you are asked to authenticate the enumerate of days that hold among the primitive invoice and ultimate invoice for each month and adequate the prospering:
Construct a question that gain exhibition the enumerate of days that hold among the primitive invoice and ultimate invoice, for each month, for each employee, using the DATEDIFF business. Be certain to agree the SQL script that gain raise out this business.
Construct a question to exhibition the expected acquittal bound if invoices are due among 30 days of affair.
Construct a question that gain exhibition dissimilar area codes of the customers.
Create a contemplation of the expedient activities that would be required to tool a operative postulatesbase project manner by including the prospering:
Steps in the conceptual project stage
Steps in DBMS gathering stage
Steps in close project stage
Steps in natural project stage
Task details of each ghost among each stage
Your assignment must prosper these formatting requirements:
Be idead, embrace spaced, using Times New Roman font (largeness 12), after a while one-inch margins on all sides; citations and regards must prosper APA or school-unfair format. Check after a while your zealot for any affixed instructions.
Include a secure page containing the indicate of the assignment, the student’s indicate, the zealot’s indicate, the succession indicate, and the bound. The secure page and the regard page are not included in the required assignment page elongation.
The unfair succession acquirements outcomes associated after a while this assignment are:
Design a abstract postulatesbase so that it is at lowest in 3NF.
Prepare postulatesbase project muniments using the postulates restriction, postulates composition, and postulates regulate speech components of the SQL speech.
Explain the key principles of postulates safeguard and authenticate postulates safeguard occasion and violations in postulates superintendence classification project.
Use technology and notice media to investigation issues in the strategic implications and superintendence of postulatesbase classifications.
Write plainly and concisely environing topics cognate to the strategic contemplationning for postulatesbase classifications using suited fitness mechanics and technical phraseology conventions.