DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: database design

Hybrid View

  1. #1
    Join Date
    Jul 2000
    Location
    India
    Posts
    60
    hi,

    i am designing a database where i have a customer_master ,an employee_master and an user_master. my problem is that my users can either be emplyees or customers. what should the design for the user_master be ? can 1 foreign key attribute in a single table refer to 1 of the 2 different parent tables ? what would be an optimum design ?

    satishpc

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    You need 2 FK attributes in the USER entity - one for customer and the for EMPLOYEE.


Posting Permissions

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


Click Here to Expand Forum to Full Width