Results 1 to 2 of 2
  1. #1
    Join Date
    May 2011

    Unanswered: Database Relationships

    I need help with creating a database for Supplier - Product relationship.

    Tabe A will have the supplier info ( Name of supplier, contact name, contact phone)
    Table B will have the product info ( Product name , type)

    Here's the tricky part :

    2 or more supplier can have the same products.

    Is this a many-many relationship ?

    How do i make it work ?

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    used an intersection table

    thats is where you have a table that stores the data relevant to the intersection between two (or more) other tables

    the intersection table would associate a supplier with a specific product. often an intersection table contains just the primary keys of the other tables. (eg product and supplier in your case). however that doesn't always hold you can store other data that is part of that intersection or association.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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