Having data scattered about the organization

Assignment Help Basic Computer Science
Reference no: EM131660254

Having data scattered about the organization in relational databases is usually not the best approach for decision analysis. For example, related data stored in different DBs can easily have differing formats and/or coding systems. Consider one manufacturer that maintained product data in one DB while maintaining order entry data in a different DB. Orders were placed using a product characterization code of, say, '01.' The problem was that the product management DB might have the same product characterization, but using the code of '010.' When reports were generated for analysis that involved both data sets, analysis anomalies were created on any comparison of that particular product characterization code. One way around this problem is to copy all transactional data to a centralized relational DB, also known as a data store or data warehouse.

What kind of difficulties could you imagine for creating such a DB?

Reference no: EM131660254

Questions Cloud

Should a creditor have a duty to preserve collateral : On April 14, 1992, David and Myrna Grossman borrowed $10,000 from Brookfield Bank in Brookfield, Connecticut, and signed a note to repay the principal.
Procedural language like visual basic : What are the differences among a markup language like HTML, a procedural language like Visual Basic, and a non-procedural query language like SQL?
Partition a disk using the fdisk utility : (1) Discuss the steps required (including exact commands) to partition a disk using the fdisk utility.
Modes of transporting hazardous materials : The nature of a research paper is to prove or disprove a thesis or hypothesis, not simply produce a report or provide information on topic.
Having data scattered about the organization : Having data scattered about the organization in relational databases is usually not the best approach for decision analysis.
Find a suitable diameter for the shaft : Find a suitable diameter for the shaft, if the maximum torque transmitted exceeds the mean by 25%. Take maximum allowable shear stress as 70 MPa
Discuss about the bank security interest for pc contractors : Dean filed a suit in a Missouri state court against Union to recover the equipment, claiming, in part, that the bank's security interest had not attached.
The development or expansion of business ventures : Considering all the risks in the development or expansion of business ventures, how do venture capitalists make money?
What is its corresponding network mask : 1. Given a network with a slash format of /27, what is its corresponding network mask?

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Find the equations of the vertical and horizontal asymptotes

Draw a graph to illustrate each type of asymptote discussed in this lesson: vertical, horizontal, and slant.

  Why are customer services important

1. Why are customer services important. Explain with an appropriate examples or scenario.

  Which of the above parts did you design

Using AND and OR gates, design a circuit to gate a single data input to one of four output lines, determined by the binary-encoded index on the two control lines. Which of the above parts did you design?

  What is quadratic probing

What is quadratic probing? What is double hashing? How are they used in Hash Tables? Why are prime numbers important when using Hash Tables? Discussion of efficiencies should include "Big O" notation, such as O(1), O(log N), O(N), O(N^2), answe..

  What is the identity theft

Identity theft, where people steal personal information, continues to be a problem for consumers and businesses. Assume that you are the database administrator.

  Define scrambling and give its purpose

List three different techniques in serial transmission and explain the differences.

  Write a test class which creates an object of type library

Implement a test functionality, which finds all books authored by Stephen King and deletes them. Finally, display information for each of the remaining books.

  Different queries in sequence within two transactions

Cause a deadlock using updates on Person. Person and Human Resources. Employee. You will have to run different queries in sequence within two transactions using at least two query windows within Management Studio to do this. Hint: If you BEGIN TRA..

  How would a user perceive the mouse motion

Suppose that mouse position changes are being sent over the connection. Assuming that multiple position changes are sent each RTT, how would a user perceive the mouse motion with and without the Nagle algorithm?

  What will the new median and iqr be

If the company recorded the shipping weights of these new packages in pounds instead of ounces, what would the median and IQR be?

  Why and where is flow control needed? explain its parameters

Explain stop-and-wait flow control with special reference to the handling of (i) a damaged frame (ii) a lost frame.

  Steps of hosmers analytical process model

The format and method for solving the case must be based on the steps of Hosmers analytical process model.

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!

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