SQL Concepts and Database Design

Project Description

Objective of this technical paper is to provide the database design and documentation for a finance industry to meet the Sarbanes-Oxley (SOX) compliance. The report aims to prepare the documentation of the sales database of the organization. However, data dictionary is very critical to enhance proper functioning of a database since it holds information about the database as well as the data it stores. This paper prepares the database dictionary for Employee, Invoice, InvoiceLine, Product, Department and Job.

DATA DICTIONARY FOR THE ORGANIZATION

Column Name

Column Type

Column Size in Bytes

Column Status

Employee

This section provides several queries from the database

a) This query identifies the number of days that exist between the first invoice and last invoice for each month:

SELECT * FROM INVOICE_TBL;

SELECT* FIRST INVOICE

SELECT* LAST INVOICE

COMPARE * DateDiff FROM FirstInvoice and LastInvoice

b). A query showing...
[ View Full Essay]