CoolInterview.com - World's Largest Collection of Interview Questions
Start Your Own website Now
Sponsored Links

Interview Questions
Our Services

Get 9,000 Interview Questions & Answers in an eBook.


  • 9500+ Pages
  • 9000 Question & Answers
  • All Tech. Categories
  • 14 MB Content

    Get it now !!



    Send your Resume to 6000 Companies


  • INTERVIEW QUESTIONS DATA WAREHOUSING ENTERPRISE DATA WAREHOUSE DETAILS
    Question :
    Why is the multivalue, multicolumn problem another form of the multivalued dependency problem?
    Category Enterprise Data Warehouse Interview Questions
    Rating (0.7) By 42 users
    Added on 3/19/2012
    Views 219
    Rate it!
    Answers:

    Both problems try to store multiple values on an attribute in a table. In the multivalue, multiplecolumn problem, the multiple values are stored in different columns. In the mutlivalued dependency problem the multiple values are stored in different rows. In both cases, the solution is the same: store the multiple values in a separate table.



    If you have the better answer, then send it to us. We will display your answer after the approval.
    Rules to Post Answers in CoolInterview.com:-

  • There should not be any Spelling Mistakes.
  • There should not be any Gramatical Errors.
  • Answers must not contain any bad words.
  • Answers should not be the repeat of same answer, already approved.
  • Answer should be complete in itself.
  • Name :*
    Email Id :*
    Answer :*
    Verification Code Code Image - Please contact webmaster if you have problems seeing this image code Not readable? Load New Code
    Process Verification  Enter the above shown code:*
    Inform me about updated answers to this question

       
    Related Questions
    View Answer
    What is the multivalue, multicolumn problem? Include an example not used in the text.
    View Answer
    Why do normalized tables require more complex SQL when SQL statements are used in application programs?
    View Answer
    You have been given a set of tables with data and asked to create a new database to store them. When you examine the data values in the tables, what are you looking for?
    View Answer
    What does it mean when we say that a relation is in Boyce-Codd Normal Form (BCNF)?
    View Answer
    What are insertion and deletion anomalies?
    View Answer
    What is a foreign key, and what is it used for?
    View Answer
    Why are functional dependencies not equations?
    View Answer
    Discuss the alternative terminology that is used in the relational model.
    View Answer
    What is an SQL subquery?
    View Answer
    Write an SQL SELECT statement to count the number of rows in STUDENT table and display the result with the label NumStudents.
    View Answer
    Name and briefly describe the five SQL built-in functions.
    View Answer
    Write an SQL SELECT statement to display all the columns of the STUDENT table but only those rows where the Grade column is greater than or equal to 90.
    View Answer
    What is Enterprise Resource Planning (ERP), and what kind of a database is used in an ERP application?
    View Answer
    What is a DBMS?
    View Answer
    Why is a database considered to be "self-describing"?
    View Answer
    Who is E.F. Codd, and why is he significant in the development of modern database systems?
    View Answer
    What is SQL, and why is it important?
    View Answer
    What is Data Warehousing?
    View Answer
    What are fundamental stages of Data Warehousing?
    View Answer
    What is Dimensional Modeling?
    View Answer


    Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

    View ALL Enterprise Data Warehouse Interview Questions

    User Options
    Sponsored Links


    Copyright ©2003-2014 CoolInterview.com, All Rights Reserved.
    Privacy Policy | Terms and Conditions

    Download Yahoo Messenger | Placement Papers| FREE SMS | ASP .Net Tutorial | Web Hosting | Dedicated Servers | C Interview Questions & Answers

    Testing Articles | Testing Books | Testing Certifications | Testing FAQs | Testing Downloads | Testing Interview Questions | Testing Jobs | Testing Training Institutes


    Cache = 0.015625 Seconds