Assignment 6 SQL Concepts and Database Design

Feb 16th, 2015
DreamIt
Category:
Computer Science
Price: $65 USD

Question description

  • 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)

    Write a three to four (3-4) page paper in which you:

    1. Create a data dictionary that includes the following:
      1. A description of the content for each field
      2. The data type of each field
      3. The format the data will be stored as in the field
      4. The range of value for the field
      5. A label, as required, if the attribute is a primary key or foreign key

    Note: An example is shown in Table 7.3 in chapter 7 of the textbook.

    1. Imagine that you are asked to identify the number of days that exist between the first invoice and last invoice for each month and complete the following:
      1. Construct a query that will show the number of days that exist between the first invoice and last invoice, for each month, for each employee, using the DATEDIFF function. Be sure to provide the SQL script that will carry out this function.
      2. Construct a query to show the expected payment date if invoices are due within 30 days of transaction. 
      3. Construct a query that will show distinct area codes of the customers.
    2. Create a plan of the necessary activities that would be required to implement a valid database design process by including the following:
      1. Steps in the conceptual design stage
      2. Steps in DBMS selection stage
      3. Steps in logical design stage
      4. Steps in physical design stage
      5. Task details of each activity within each stage

Use this template APA_Template_With_Advice_(6th_Ed) .doc 

Sample info Assignment 6.doc 

[Carlos_Coronel,_Steven_Morris,_Peter_Rob]_Databas(BookZZ.org).epub 

Tutor Answer

(Top Tutor) Daniel C.
(997)
School: UT Austin
PREMIUM TUTOR

Studypool has helped 1,244,100 students

5 Reviews


Summary
Quality
Communication
On Time
Value
ashleyisgod
Nov 27th, 2016
" Top quality work from this guy! I'll be back! "
Molly_Moon
Nov 5th, 2016
" AMAZING as always! "
Hemapathy
Oct 13th, 2016
" all I can say is wow very fast work, great work thanks "
BlueOcean
Sep 30th, 2016
" Awesome! Exactly what I wanted. "
kevin12622
Sep 21st, 2016
" Goes above and beyond expectations ! "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1819 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors