Forums for the Business Analyst

  Modern Analyst Forums  Careers  Getting Started  Data redundancy
Previous Previous
Next Next
New Post 4/29/2009 2: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 8:12 PM
User is offline Tom Miller, CSPO
45 posts
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:

Or this might be clearer:

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.



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

Community Blog - Latest Posts

Hosted by Deirdre Caren on Agora Insight's Blueprints for Success - The AI Business Analyst I recently had an engaging discussion with Maria Becerra, a passionate advocate for AI and an accomplished business analyst, on the AI Business Analyst. Maria is a respected name in strategy, business analysis and AI. Her path from Colombia to Canada ...
Hosted by Deirdre Caren in Agora Insights' Blueprints for Success I'm thrilled to have Susan Moore join us for episode 9 in our Blueprints for Success. In this session, Susan shares her rich tapestry of experiences that have shaped her career. Her journey into business analysis (ba) is a compelling narrative of exploration and disco...
I recently connected with Fabricio Laguna, aka The Brazilian BA. Fabricio is a passionate and pioneering business analyst from Brazil. During our conversation, we had a thought-provoking discussion on how artificial intelligence stands to shape the field of business analysis in the years ahead. While AI promises to transform many aspects of busines...



Copyright 2006-2024 by Modern Analyst Media LLC