project deliverable 3 database and data warehousing design 9679019 2

/in /by

This assignment consists of two (2) sections: a design document and a revised project plan. You must submit both sections as separate files for the completion of this assignment. Label each file name according to the section of the assignment it is written for. Additionally, you may create and / or assume all necessary assumptions needed for the completion of this assignment.

One of the main functions of any business is to transform data into information. The use of relational databases and data warehousing has gained recognition as a standard for organizations. A quality database design makes the flow of data seamless. The database schema is the foundation of the relational database. The schema defines the tables, fields, relationships, views, indexes, and other elements. The schema should be created by envisioning the business, processes, and workflow of the company. Since your company is an innovative Internet-based company, movement toward data warehousing seems to be one of the most viable options to give your company a competitive advantage; however, these concepts must be explained to the executive board in a manner to garner support.  
Section 1: Design Document
Write a six to ten (6-10) page design document in which you:
  1. Support the need for the use of relational databases and data warehousing. From a management standpoint, it may be important to show the efficiencies that can be gained for executive oversight. 
  2. Create a database schema that supports the company’s business and processes. Explain and support the database schema with relevant arguments that support the rationale for the structure. Note: The minimum requirement for the schema should entail the tables, fields, relationships, views, and indexes.
  3. Identify and create database tables with appropriate field-naming conventions. Then, identify primary keys and foreign keys, and explain how referential integrity will be achieved. Normalize the database tables to third normal form (3NF). 
  4. Identify and create an Entity-Relationship (E-R) Diagram relating the tables of the database schema through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length but must be included in the design document appendix. Explain your rationale behind the design of the E-R Diagram. 
  5. Identify and create a Data Flow Diagram (DFD) relating the tables of your database schema through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length but must be included in the design document appendix. Explain the rationale behind the design of your DFD. 
  6. Illustrate the flow of data including both inputs and outputs for the use of a data warehouse. The diagram should map data between source systems, operational systems, data warehouses and specified data marts. Note: The graphically depicted solution is not included in the required page length.
Your assignment must follow these formatting requirements:
  • Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
  • Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
  • Include charts or diagrams created in MS Visio or Dia as an appendix of the design document. All references to these diagrams must be included in the body of the design document.
Section 2: Revised Project Plan
Use Microsoft Project to:
  1. Update the project plan (summary and detail) template, from Project Deliverable 2: Business Requirements, with three to five (3-5) new project tasks each consisting of five to ten (5-10) subtasks.
The specific course learning outcomes associated with this assignment are:
  • Describe the methods and best practices in implementing process change in IT organizations. 
  • Describe the role and methods of technology-induced process improvement in organizations. 
  • Use technology and information resources to research issues in information systems.
  • Write clearly and concisely about leadership issues and strategic insight of the Information systems domain using proper writing mechanics and technical style conventions.

 

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code “Newclient” for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

The post project deliverable 3 database and data warehousing design 9679019 2 appeared first on Essay Writers.

 

“Are you looking for this answer? We can Help click Order Now”

>Sociology homework help

/in /by

equired Readings
Atlas, R. I. (2003). How are criminals using CPTED? SecurityManagement, 47(5), 148–146.
Hoffmann, J. P. (2010). A life-course perspective on stress,delinquency, and young adult crime. American Journal ofCriminal Justice, 35(3), 105–120.
Menard, S., & Morris, R. G. (2012). Integrated theory andcrimes of trust. Journal of Quantitative Criminology, 28(2),365–387.
Wilcox, P., Quisenberry, N., Cabrera, D. T., & Jones, S.(2004). Busy places and broken windows? Toward defining the role of physical structure and process in community crimemodels. Sociological Quarterly, 45(2), 185–207.
Silver, E., & Miller, L. L. (2004). Sources of informal social control in Chicago neighborhoods. Criminology, 42(3), 551
Required Media
Laureate Education (Producer). (2014d). Sociological theories of criminal behavior I [Video file]. Retrieved from https://class.waldenu.edu
Dr. Charis Kubrin discusses sociological theories of crime. Think about the different sociological theories she presents and how these theories are explained.
Note:  The approximate length of this media piece is 6 minutes.
Accessible player –Downloads–Download Video w/CCDownload AudioDownload Transcript
 
Assignment: Social Control Theory
Social control theory, when applied to the study of criminal behavior, examines the social rules and contracts that influence individual behavior. Social control may be both informal and formal. Informal controls are interwoven with social values, community expectations, and the unwritten social contracts by which communities abide. Alternately, formal social control describes the social laws, rules, and punishments that address behavior that is considered antisocial or criminal.
Social control is effective in preventing criminal behavior when individuals feel connected to a community, a family, or another social entity to which they also feel accountable. On the other hand, it tends not to be effective when individuals feel disconnected from family and community. In fact, the theory contends that criminal behavior flourishes when these links to conventional community standards are broken or missing.
To prepare for this Assignment:

Review the article, “Sources of Informal Social Control in Chicago Neighborhoods,” paying attention to various sources of informal social control. Also consider why methods of social control may develop in disadvantaged neighborhoods.
Search the Internet and select a peer-reviewed article that addresses issues of social control.

Assignment (1–2 pages):

Analyze the degree to which social control theory explains engagement in criminal behavior.
Analyze the degree to which social control theory explains the prevention of criminal behavior.
Based on your analysis, explain how useful control theory might be for understanding and explaining the nature of criminal behavior.

Support your Assignment with specific references to all resources used in its preparation. You are asked to provide a reference list only for those resources not included in the resources for this course.
By Day 7

 
“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”

The post >Sociology homework help appeared first on Nursing Experts Help.

 

“Are you looking for this answer? We can Help click Order Now”

database paper 6 8 pages

/in /by

Your database has been a hit. You have been called back to the customer’s headquarters and they want 

a detailed report and plan of how to convert the mass amounts of data into profitable information. They 

have heard of data warehouses and data mining, but they want you to provide an executive overview and 

a plan with specifics on how they will take their environment to the next level with the implementation of a 

data warehouse and data mining infrastructure. 

 

Write a six to eight (6-8) page paper in which you: 

1. Provide an executive overview that addresses the following: 

a. Explain the benefits and current trends of data warehousing and data mining. 

b. Provide two (2) examples of quality companies successfully using a data warehouse to 

support your answer. 

c. Outline the architecture, models, and views used in the data warehouse. 

2. Discuss optimization techniques specific to data warehousing and data mining. 

3. Assume that the company has accumulated 20TB of data and that 20% per year growth is 

expected in the size of the Data Warehouse. Recommend a solution for this scenario with respect 

to software, hardware, and network requirements. 

4. Create a diagram using Visio, Microsoft Paint, or other graphical creation utility of your choosing 

to illustrate the conceptual data feeds into and out of the data warehouse. Note: The graphically 

depicted solution is not included in the required page length. 

5. Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites 

do not qualify as quality resources. 

 

Your assignment must follow these formatting requirements: 

 Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all 

sides; citations and references must follow APA or school-specific format. Check with your 

professor for any additional instructions. 

 Include a cover page containing the title of the assignment, the student’s name, the professor’s 

name, the course title, and the date. The cover page and the reference page are not included in 

the required assignment page length. 

 Include charts or diagrams created in Excel, Visio, MS Project, or one of their equivalents such as 

Open Project, Dia, and OpenOffice. The completed diagrams/charts must be imported into the 

Word document before the paper is submitted. 

 

The specific course learning outcomes associated with this assignment are: 

 Demonstrate the basic mechanisms for accessing relational databases from various types of 

application development environments. 

 Summarize the difference between online transaction processing (OLTP) and online analytic 

processing (OLAP), and their relationship among business intelligence, data warehousing, and 

data mining. 

 Summarize how database systems support enterprise and Web-based applications. 

 Use technology and information resources to research issues in database systems. 

 Write clearly and concisely about relational database management systems using proper writing 

mechanics and technical style conventions. 

  CIS 111 – Assignments and Rubrics

 

© 2013 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary information 

and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written permission of 

Strayer University. 

CIS 111 Student Version 1134 (1143 2-7-2013) Page 24 of 28 

Grading for this assignment will be based on answer quality, logic/organization of the paper, and 

language and writing skills, using the following rubric. 

 

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code “Newclient” for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

The post database paper 6 8 pages appeared first on Essay Writers.

 

“Are you looking for this answer? We can Help click Order Now”

International business 3

/in /by

Part One: 03 Discussion – Foreign Investments – Due Mon 11/27/17

(Needs to be 150 words)

Two types of foreign investment exist: Foreign Portfolio Investments (FPI) and Foreign Direct Investments (FDI). The difference between these two is determined by the level control sought and gained by the investor. FPI is passive while FDI is more aggressive in its methods of acquisitions. Because of its aggressiveness, most investment theories are based on the assumptions of FDI. Therefore, strategies to acquire goods, services, and capital have an active sense of investment.

With the above in mind, identify and discuss an investment strategy. Express the advantages of your strategy based on an international investment theory.

_____________

Part Two: 03 Discussion – The Dominance of the iPod – Due Mon 11/2717

(150 words)

Apple’s iPod has claimed a large share of the MP3 player market. Which firm-based trade theory would best fit the dominance that Apple has in this market? Why?

_______________

Part Three: 03 Written Assignment – Comparison of Two Systems

The foreign exchange system contains the prices of currencies of other countries. These prices fluctuate based on demand and supply. Individuals buy and sell currency as they would any other commodity. Instead of a product like in other markets of world, the product here is currency, thus the feel of an exchange when it is actually a purchase.

With this in mind, create a 2-3 page response to the following:

  1. Compare and contrast the Foreign Exchange Market and an international market of your choice.
  2. Determine an advantage and disadvantage for each.

Your final assignment should be proofread for correct spelling, grammar, and punctuation.

https://www.studypool.com/discuss/5113218/internat…

 

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code “Newclient” for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.

The post International business 3 appeared first on Top Premier Essays.

 

“Are you looking for this answer? We can Help click Order Now”