Merged Tables or Distributed Table

Discussion in 'Databases' started by protocol96, Feb 28, 2007.

0
  1. #1
    I am confused as to which kinda table should i go for a merged table, so that i mite jut have 2 tables or distributed table where i m gonna have 8 tables.

    Can some1 tell me which 1 is better and y??
     
    protocol96, Feb 28, 2007 IP
  2. ccoonen

    ccoonen Well-Known Member

    Messages:
    1,606
    Likes Received:
    71
    Best Answers:
    0
    Trophy Points:
    160
    #2
    normalization is key (forgive my pun) in the world of databases. If their is a factor you can group buy, then normalize it, and put it in a new table.

    For example, if you have customers and orders, I would set it up like so:

    Order
    OrderLine
    Customer
    CustomerAddress

    Then the Customer has two fields (BillingAddressID, and ShippingAddressID) which link to the CustomerAddress. Same with Order table, OrderLine has a field that joins to the OrderID in the Order Table.

    Normalization is definitely a skill to be aquired, but once you have it down, you will have saved a TON of time!
     
    ccoonen, Mar 5, 2007 IP
  3. spachev

    spachev Peon

    Messages:
    42
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Please clarify your question.
     
    spachev, Mar 8, 2007 IP