Home Forums Database Design Design Ideas and Questions Data modeling TECHNIQUES RE: Data modeling TECHNIQUES

  • May 24, 2016 at 11:59 am

    #1881174

    Rankerg (5/24/2016)

    Hi

    So I will have 1xtra phone number table with customer ID as a foreignkey right? And what do you mean by business requirements for data usually it's business requirements? The challenge I have it since it is migrating an existing old hierarchical database to relational data model I need to analyze the data, so for example the customer table has 5 date of birth columns and don't know which DOB column has true DOB...

    Can you guys send me good data driven data modeling website links please?

    With the understanding that there's a lot more to it, here's a very good introductory article on the subject. Be sure to read the "discussions" under the "Join the Discussion" link near the top of the article.

    http://www.sqlservercentral.com/articles/Database+Design/72054/

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)