Alpha Video Training
Results 1 to 1 of 1

Thread: Identifying Relationship Application

  1. #1
    Member
    Real Name
    Joe Chasko
    Join Date
    Aug 2011
    Location
    Sacramento, California
    Posts
    43

    Default Identifying Relationship Application

    I'm confused about FK's and Identifying relationships (IRs) in MySQL. I've seen that any FK that is part of a unique ID (not the PK) should be an IR. For instance:

    Region
    ID
    Name

    Company
    ID
    fk_Region_ID

    Invoice
    ID
    fk_Company_ID
    fk_Region_ID (Company)

    Invoice_Detail
    ID
    fk_Invoice_ID
    fk_Region_ID (Invoice)

    For the Invoice_Detail Table:
    I assume that fk_Invoice_ID must be identifying?
    What about fk_Region_ID?
    Last edited by jchasko; 08-29-2011 at 01:16 AM.

Similar Threads

  1. Identifying Relationship impact
    By jchasko in forum Database Design
    Replies: 5
    Last Post: 08-31-2011, 06:50 AM
  2. Help with adding a field for identifying odd and even records
    By Judith in forum Alpha Five Version 9 - Desktop Applications
    Replies: 3
    Last Post: 03-10-2010, 08:20 AM
  3. Identifying Records
    By Thomas Holt in forum Alpha Five Version 4
    Replies: 4
    Last Post: 05-17-2006, 01:26 PM
  4. Identifying OLE type in field
    By Steve Bovino in forum Alpha Five Version 6
    Replies: 0
    Last Post: 07-07-2005, 05:13 PM
  5. Identifying clients
    By Don Hutchinson in forum Alpha Five Version 6
    Replies: 4
    Last Post: 04-07-2005, 02:34 AM

Bookmarks

Posting Permissions

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