User Account

All Pages

Create a data dictionary that include the data type of filed

Assignment Help Management Information Sys
Reference no: EM132170462 , Length: 3

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:

Create a data dictionary that includes the following:

A description of the content for each field

The data type of each field

The format the data will be stored as in the field

The range of value for the field

A label, as required, if the attribute is a primary key or foreign key

Reference no: EM132170462

Questions Cloud

Explain how thinkers ideas are visible in modernist stories : We have talked of the five important thinkers of the 19thand 20thcenturies which influenced the Modernist literary minds.
Analyze the work based on visual properties : Formal analysis paper (3- page Museum assignment): You are required to visit either the Museum of Contemporary Art or the new Modern Wing at the Art Institute.
How you do or could use operations security in current job : If you are currently unemployed, define the job you are looking to apply for and how you would use operation security in that job position.
Shell marginal revenue as a function of q : What is Shell's marginal revenue as a function of Q?
Create a data dictionary that include the data type of filed : Your organization is looking to submit its database design documentation to an evaluation team in order to meet Sarbanes-Oxley (SOX) compliance.
List the quantitative sources of economic growth : List the qualitative sources of economic growth & List the quantitative sources of economic growth.
Why do economic costs include both explicit : Why do economic costs include both explicit (revealed and expressed) costs and implicit (present but not obvious) costs?
How would one define business intelligence : How would one define business intelligence (BI)? Identify and briefly discuss a real-world application of BI?
How time manipulated or presented in mordernist literature : How is time manipulated or presented in mordernist literature? how important is it for the modernist writer? discuss the issue of time with reference.

Reviews

Write a Review

Management Information Sys Questions & Answers

  Calculate the overall cpi

Suppose we have the following measurement: Frequency of floating point(FP) operations is 25%, average CPI of FP operations is equal to 4.0.

  Write a response about the given post

The two types of cynicism that law enforcement face, organizational cynicism and work Cynicism. (Doerner, 2012). Organizational cynicism means there is distrust of police administration and its rules and regulations. Work cynicism connotes a feeli..

  Implement the unsigned multiplication subroutine unsmul

Implement the unsigned multiplication subroutine UNSMUL. The algorithm requires double-word shifts: ShiftRight(ACC:MPR). You must solve a bit carry-over problem since the double-words are stored as two single words.

  How using the guidance afforded by cloud security alliance

Suppose that you are CIO of a small organization (50 employees) that is considering a cloud migration. You have 10 servers in one data center location that supports an office with staff, a manufacturing plant, and 10 salespeople. Analyze the secur..

  Describe the features this technology will have over its

Describe the features, capabilities, or basic advantages this technology will have over its predecessor.

  Identify three it-related risk management plans

Research and identify three IT-related Risk Management Plans and list your references to the three plans you found.

  Describe the methods for establishing component priorities

Describe the methods for establishing component priorities.Describe the methods for determining component reliance and dependencies.

  Explain how a soa-designed erp system enables erp customers

In your own words, explain how a SOA-designed ERP system enables ERP customers to better integrate existing and new company applications into the vendor's ERP package.

  Description of customer servicebriefly describe what can a

description of customer servicebriefly describe what can a company do to acquire and retain new customers? if a company

  Explain what the future of privacy looks like

Explain what the future of privacy looks like. Discuss whether or not there a need to rethink the concept of privacy in the digital age? Why or why not?

  What you think about all of these strange incidents

At first, he thought this was just a computer vendor who was trying to sell your company some new product, but no vendor has approached the company.

  Are there any web 2.0 technologies

What can you share about the above items that would help someone designing a website for a business other than the one you've been studying?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd