Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2006
    Location
    Black Hills of South Dakota
    Posts
    7

    First SQL database

    I am in the design phase of this concept and am looking for input.

    Background: I have a client that is looking for a way to access dispersed information form a single location. Giving them the ability to find out which employees are where, what is there job function there, when did they get there, and how was there performance.

    Clarification of diagram:
    1.Employee Table (i.e. Contact information,hiredate)
    2.Facilities Table (i.e. Address, Contact)
    3.Disciplines Table (i.e. RN, LPN, CPht)
    4.Location Table (Relate employee(s) to facility)
    5.Evaluation Table (i.e. Employee Eval, Facility Eval, Contractor Eval)

    So would I be correct in my diagram on how the database structure should be set up? And since it is a possible that an employee can hold multiple disciplines would I need a PK for that table?
    Attached Thumbnails Attached Thumbnails dmtdb.gif  
    Last edited by Cory_Price; 08-11-06 at 16:59.

  2. #2
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    could an individual employee be associated with more than one dicipline?

    is facilities.contact an employee?
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


  3. #3
    Join Date
    Aug 2006
    Location
    Black Hills of South Dakota
    Posts
    7
    Yes an employee can be associated with more than one discipline. Facility table only list facility information (cntact information would be primary contact and is not an employee)

    Clarification:
    Employee Table will consist of contract employees working at Facilities listed in the Facility Table

Posting Permissions

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