1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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