Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003
    Posts
    223

    Unanswered: How to check normalized tables?

    Hello, everyone:

    Some tables werer sent from customer. They ask to check if these tables have been normalized. How to check them? Thanks a lot.

    ZYT

  2. #2
    Join Date
    Nov 2003
    Location
    London
    Posts
    169
    Hi,

    If there are more than one table and they have primary and foreign key columns in them i.e. fields in tables that relate to each other, then you can assume that the data has been normalised. Quite how well it has been normalised could be a different question

    Why don't you ask them for a database diagram?

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Only ONE answer to that question....

    READ

    http://www.informatik.uni-trier.de/~...bout/codd.html

    GOOGLE anything about the good Dr. Edgar F Codd...

    The guy who started this whole mess....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •