SQL Concepts and Database Design Research Paper

Open, View, and/or
Download this Document

Total Length: 1001 words ( 3 double-spaced pages)

Total Sources: 2

Page 1 of 3

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 the expected payment date of invoices due within 30 days of transaction.

select * from Invoices where DueDate + 30

Stuck Writing Your "SQL Concepts and Database Design" Research Paper?

View All Our Example SQL Concepts and Database Design Research Paper

Have A Custom Example Essay Written

The ER diagram should contain the following:

Entity - a class of real world objects that have common properties and characteristics to record information.

Relationship - an association among two or more entities

Attribute - characteristics of a relationship entity.

ER concepts are revealed in the following diagram.

The next step is to assign characters to each entity. Assigning character to the entity is presented below.

Entity

Entity key

Key length (max) in characters

No. Of occurrences

Customer

cust-no

6

80

Job

job-no

24

80

Order

order-no

9

Salesperson

sales-id

20

Department

dept-no

2

10

Item

item-no

6

5

Data Relationship

The next step is to describe the data relationships. The following is the data relationships:

Each customer has one title, however different customers may have the same title.

Each customer could place many orders, however only one customer could place a particular order.

Each department is having many salespeople, however each salesperson is required work to only one department.

Each department is having items for sale; however, each item is sold in one department.

The table below reveals the ER Construct and database file names (FD).

ER Construct

FDs

Job (one):Customer (many cust-no -> job-title

Customer (one): Order (many)

order-no -> cust-no

Department (one):….....

Show More ⇣

     Open the full completed essay and source list


OR

     Order a one-of-a-kind custom essay on this topic


sample essay writing service

Cite This Resource:

Latest APA Format (6th edition)

Copy Reference
"SQL Concepts And Database Design" (2013, August 15) Retrieved May 16, 2025, from
https://www.aceyourpaper.com/essays/sql-concepts-database-design-94609

Latest MLA Format (8th edition)

Copy Reference
"SQL Concepts And Database Design" 15 August 2013. Web.16 May. 2025. <
https://www.aceyourpaper.com/essays/sql-concepts-database-design-94609>

Latest Chicago Format (16th edition)

Copy Reference
"SQL Concepts And Database Design", 15 August 2013, Accessed.16 May. 2025,
https://www.aceyourpaper.com/essays/sql-concepts-database-design-94609
   

Open, View, and/or
Download this Document
order custom essay example