Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2012
    Posts
    1

    Unanswered: MySQL tables and relationship

    Hello,

    I am currently designing a database for property firm.

    I am getting confuse how to link up a property item to a supplier part which are created by different users; home owner and supplier. Would it be an 1-1 non-identifying relationship to link both tables and the property item is the parent which will have FK from the supplier part table.

    Paul

  2. #2
    Join Date
    Jun 2012
    Location
    Denver, CO, USA
    Posts
    20
    You can take a look at this primer/tutorial on foreign keys to help you decide how you want to do it:
    Eliacom- MySQL Foreign Keys: Introduction, Tutorial, How to Create Them and What They Do

    ____________________
    Juacala - Web Application Developer, Eliacom, Inc.
    MySQL GUI Tools for Online Applications: Eliacom

Posting Permissions

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