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
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

Fabricio Laguna talks Business Analysis and AI
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...
Business Architecture, Ontology and More with Terry Roach
It's been a privilege meeting Terry Roach, a visionary in the field of enterprise architecture and business architecture. Terry's insights into the evolution of business models, the importance of ontology in architecture, and the potential of AI to shape our future were not only thought-provoking but also a reflection of his extensive exper...
Today I had the pleasure of chatting to Jignesh Jamnadas, Chief Operations Officer at Mosaic, about his Blueprints for Success. As a Senior Finance and Operations Executive, Jigs (as he is known to many) has a holistic understanding of all facets of business and a flair for managing both people and processes. Having worked with Jigs, I was struc...

 



Upcoming Live Webinars




 

Copyright 2006-2024 by Modern Analyst Media LLC