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

  Discuss the role of certificate authentication in e-commerce

Many predict that the future of e-commerce is pegged on the successful implementation of authentication. Discuss.

  What u think about the article database fight funding cuts

What u think about the article Database fight funding cuts

  Determine the maximum period obtainable from lcg

Determine the maximum period obtainable from following LCG? Xn+1 = aXn (mod 24). What must be the value of a?

  Write a sinusoidal function to model this data

Find the number of daylight hours for the middle of each month or the average monthly temperature for your community. Write a sinusoidal function to model this data.

  What was the economic and social impact of choose and book

Clarify and describe the problems of the NHS Choose and Book System. What people, organization, and technology factors were responsible for those problems?

  Explain opportunity cost and provide an example

Explain Opportunity Cost and provide an example.

  Ethical decision model to analyse the situation

Description: Part 2 is a new piece of work that should not include material from Part 1. As before, it is a written analysis (4500 words) of a complex ethical problem similar to that which you might encounter in the IT industry.

  Modeling an emergency communication system

You are modeling an emergency communication system used to contact teachers in case inclement weather emergencies cause delayed openings or closures of the school. You may reach teachers by phone and/or email.

  Draw a centrifugal pump and label its parts

Describe how a steam turbine works. Sketch a simple drawing if needed.

  Largest number of blocks

In the same scenario at (b) above, what is the largest number of blocks that is ever stored in the client buffer, awaiting playout?

  What are the three components of the c.i.a. triangle

What are the three components of the C.I.A. triangle? What are they used for?

  Does the keeper have to sound the horn

If they are less than 300 feet, she plans to sound the horn. How far apart are these vessels? Does the keeper have to sound the horn?

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