CIS 515 WEEK 7 ASSIGNMENT 6 SQL CONCEPTS AND DATABASE DESIGN
Assignment 6 : SQL Concepts and Database Design Due Week 7 and worth 90 points
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 )