Forums for the Business Analyst

 
  Modern Analyst Forums  Careers  Getting Started  Data redundancy
Previous Previous
 
Next Next
New Post 4/29/2009 1:23 PM
User is offline radhika
3 posts
No Ranking


Data redundancy 

Recently an interview asked me how would i go with data redundancy , like what steps would i follow to remove the redundancy os the data, in a Data Warehousing project as a Business Analyst.

Could any one reply for this plsss

 
New Post 5/11/2009 7:12 PM
User is offline Tom Miller, CSPO
45 posts
www.linkedin.com/in/tlgalenson
8th Level Poster


Re: Data redundancy 
Modified By Tom Miller, CSPO  on 5/11/2009 10:20:35 PM)

That sounds like they want you to describe the process of converting the data redunacy into "3rd Normal Form" where there is only one copy of the data.  The theoretical basis is from Codds' 13 rules publication.  Let me take a look, Maybe this will help: http://articles.techrepublic.com.com/5100-10878_11-6135910.html

Or this might be clearer: http://databases.about.com/od/specificproducts/a/normalization.htm

I am currently studying "Database Design for Mere Mortals" 2nd Edition, by Michaell J Hernandez  It probably discusses this topic completely but I am still near the beginning.  The book comes highly recommended so you might take a look after you read the two articles I have listed above.

 

Tom

 
Previous Previous
 
Next Next
  Modern Analyst Forums  Careers  Getting Started  Data redundancy

Community Blog - Latest Posts

I have always loved cooking. I learned from my Grandma June and her kitchen was her sanctuary, a small, warm sunlit space filled with jars of spices, stacks of cookbooks, and the comforting smell of something always on the stove or baking in the oven. Grandma June was as great a cook as she was a teacher to me. She never followed a recipe “to...
Now, I know, I don’t know what kind of new intro BPO may require, but at least I can promise you upfront that I have something different to say about Business Process Outsourcing or simply BPO. What is it? This hasn't been a call center job or a sales job as we all think. It is a mammoth profile, and firms are grappling to ge...
Leveraging Blockchain Technology for Enhanced Data Security in Business Operations
In an age where data breaches and cyberattacks are becoming more frequent and sophisticated, businesses are searching for robust solutions to safeguard their data. Blockchain technology has emerged as a promising tool in this quest, offering a way to secure data with unparalleled reliability. Although initially known for powering cryptocurrencies l...

 






 

Copyright 2006-2025 by Modern Analyst Media LLC