Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2012
    Posts
    33

    Database nad simple question ( relations )

    Hello!

    I have some tables:

    - CLIENTS,
    - EMPLOYEES,
    - INVOICES,
    - BILLS,

    My idea on relation is:

    One CLIENT may have one or more INVOICEES or BILLS and one EMPLOYEE may issue one or more INVOICCES or BILLS, then:

    CLIENTS --------------------< INVOICEES >-------- EMPLOYEES
    |
    |
    |
    |
    ^
    BILLS > --- ( line to table EMPLOYEES )

    I greet.

  2. #2
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    What columns and keys have you defined for these tables?

Posting Permissions

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