wk 7 assign 6

The Strayer Oracle Server may be acclimated to analysis and abridge the SQL Queries developed for this assignment. Your adviser will accommodate you with login accreditation to a Strayer University maintained Oracle server. Imagine that you appointment for a accounts industry-based organization. Your alignment is attractive to abide its database architecture affidavit to an appraisal aggregation in adjustment to accommodated Sarbanes-Oxley (SOX) compliance. You accept been assigned to abetment in advancing the affidavit of the organization’s sales database. You are asked to adduce a abstracts concordance that can be acclimated to certificate 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) folio cardboard in which you: Create a abstracts concordance that includes the following: A description of the agreeable for anniversary field The abstracts blazon of anniversary field The architecture the abstracts will be stored as in the field The ambit of amount for the field A label, as required, if the aspect is a primary key or adopted key Note: An archetype is apparent in Table 7.3 in affiliate 7 of the textbook. Imagine that you are asked to analyze the cardinal of canicule that abide amid the aboriginal balance and aftermost balance for anniversary ages and complete the following: Construct a concern that will appearance the cardinal of canicule that abide amid the aboriginal balance and aftermost invoice, for anniversary month, for anniversary employee, application the DATEDIFF function. Be abiding to accommodate the SQL calligraphy that will backpack out this function. Construct a concern to appearance the accepted acquittal date if invoices are due aural 30 canicule of transaction.   Construct a concern that will appearance audible breadth codes of the customers. Create a plan of the all-important activities that would be appropriate to apparatus a accurate database architecture action by including the following: Steps in the conceptual architecture stage Steps in DBMS alternative stage Steps in analytic architecture stage Steps in concrete architecture stage Task capacity of anniversary action aural anniversary stage Your appointment charge chase these formatting requirements: Be typed, bifold spaced, application Times New Roman chantry (size 12), with one-inch margins on all sides; citations and references charge chase APA or school-specific format. Check with your assistant for any added instructions. Include a awning folio absolute the appellation of the assignment, the student’s name, the professor’s name, the advance title, and the date. The awning folio and the advertence folio are not included in the appropriate appointment folio length. Points: 120 Assignment 6: SQL Concepts and Database Design Criteria Unacceptable Below 70% F Fair 70-79% C Proficient 80-89% B Exemplary 90-100% A 1. Create a abstracts dictionary. 1a. Include a description of the agreeable for anniversary field. Weight: 5% Did not abide or clumsily included a description of the agreeable for anniversary field. Partially included a description of the agreeable for anniversary field. Satisfactorily included a description of the agreeable for anniversary field. Thoroughly included a description of the agreeable for anniversary field. 1b. Include the abstracts blazon of anniversary field. Weight: 5% Did not abide or clumsily included the abstracts blazon of anniversary field. Partially included the abstracts blazon of anniversary field. Satisfactorily included the abstracts blazon of anniversary field. Thoroughly included the abstracts blazon of anniversary field. 1c. Include the architecture the abstracts will be stored as in the field. Weight: 5% Did not abide or clumsily included the architecture the abstracts will be stored as in the field. Partially included the architecture the abstracts will be stored as in the field. Satisfactorily included the architecture the abstracts will be stored as in the field. Thoroughly included the architecture the abstracts will be stored as in the field. 1d. Include the ambit of amount for the field. Weight: 5% Did not abide or clumsily included the ambit of amount for the field. Partially included the ambit of amount for the field. Satisfactorily included the ambit of amount for the field. Thoroughly included the ambit of amount for the field. 1e. Include a label, as required, if the aspect is a primary key or adopted key. Weight: 5% Did not abide or clumsily included a label, as required, if the aspect is a primary key or adopted key. Partially included a label, as required, if the aspect is a primary key or adopted key. Satisfactorily included a label, as required, if the aspect is a primary key or adopted key. Thoroughly included a label, as required, if the aspect is a primary key or adopted key. 2a. Construct a concern that will appearance the cardinal of canicule that abide amid the aboriginal balance and aftermost invoice, for anniversary month, for anniversary employee, application the DATEDIFF function. Be abiding to accommodate the SQL calligraphy that will backpack out this function. Weight: 15% Did not abide or clumsily complete a concern that will appearance the cardinal of canicule that abide amid the aboriginal balance and aftermost invoice, for anniversary month, for anniversary employee, application the DATEDIFF function. Did not abide or clumsily provided the SQL calligraphy that will backpack out this function. Partially complete a concern that will appearance the cardinal of canicule that abide amid the aboriginal balance and aftermost invoice, for anniversary month, for anniversary employee, application the DATEDIFF function. Partially provided the SQL calligraphy that will backpack out this function. Satisfactorily complete a concern that will appearance the cardinal of canicule that abide amid the aboriginal balance and aftermost invoice, for anniversary month, for anniversary employee, application the DATEDIFF function. Satisfactorily provided the SQL calligraphy that will backpack out this function. Thoroughly complete a concern that will appearance the cardinal of canicule that abide amid the aboriginal balance and aftermost invoice, for anniversary month, for anniversary employee, application the DATEDIFF function. Thoroughly provided the SQL calligraphy that will backpack out this function. 2b. Construct a concern to appearance the accepted acquittal date if invoices are due aural 30 canicule of transaction.  Weight: 15% Did not abide or clumsily complete a concern to appearance the accepted acquittal date if invoices are due aural 30 canicule of transaction.   Partially complete a concern to appearance the accepted acquittal date if invoices are due aural 30 canicule of transaction.   Satisfactorily complete a concern to appearance the accepted acquittal date if invoices are due aural 30 canicule of transaction.   Thoroughly complete a concern to appearance the accepted acquittal date if invoices are due aural 30 canicule of transaction.   2c. Construct a concern that will appearance audible breadth codes of the customers. Weight: 10% Did not abide or clumsily complete a concern that will appearance audible breadth codes of the customers. Partially complete a concern that will appearance audible breadth codes of the customers. Satisfactorily complete a concern that will appearance audible breadth codes of the customers. Thoroughly complete a concern that will appearance audible breadth codes of the customers. 3. Create a plan of the all-important activities that would be appropriate to apparatus a accurate database architecture process. 3a. Include accomplish in the conceptual architecture stage. Weight: 5% Did not abide or clumsily included accomplish in the conceptual architecture stage. Partially included accomplish in the conceptual architecture stage. Satisfactorily included accomplish in the conceptual architecture stage. Thoroughly included accomplish in the conceptual architecture stage. 3b. Include accomplish in DBMS alternative stage. Weight: 5% Did not abide or clumsily included accomplish in DBMS alternative stage. Partially included accomplish in DBMS alternative stage. Satisfactorily included accomplish in DBMS alternative stage. Thoroughly included accomplish in DBMS alternative stage. 3c. Include accomplish in analytic architecture stage. Weight: 5% Did not abide or clumsily included accomplish in analytic architecture stage. Partially included accomplish in analytic architecture stage. Satisfactorily included accomplish in analytic architecture stage. Thoroughly included accomplish in analytic architecture stage. 3d. Include accomplish in concrete architecture stage. Weight: 5% Did not abide or clumsily included accomplish in concrete architecture stage. Partially included accomplish in concrete architecture stage. Satisfactorily included accomplish in concrete architecture stage. Thoroughly included accomplish in concrete architecture stage. 3e. Include assignment capacity of anniversary action aural anniversary stage. Weight: 5% Did not abide or clumsily included assignment capacity of anniversary action aural anniversary stage. Partially included assignment capacity of anniversary action aural anniversary stage. Satisfactorily included assignment capacity of anniversary action aural anniversary stage. Thoroughly included assignment capacity of anniversary action aural anniversary stage. 4. Clarity, autograph mechanics, and formatting requirements Weight: 10% More than 6 errors present 5-6 errors present 3-4 errors present 0-2 errors present

Order a unique copy of this paper

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
Top Academic Writers Ready to Help
with Your Research Proposal
Order now and a get a 25% discount with the discount code: COURSEGUYOrder Now!
+ +