If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > First SQL database

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-10-06, 13:52
Cory_Price Cory_Price is offline
Registered User
 
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
First SQL database-dmtdb.gif  

Last edited by Cory_Price; 08-11-06 at 15:59.
Reply With Quote
  #2 (permalink)  
Old 08-10-06, 15:30
loquin loquin is offline
Super Moderator
 
Join Date: Jun 2004
Location: Arizona, USA
Posts: 1,797
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

Reply With Quote
  #3 (permalink)  
Old 08-10-06, 17:41
Cory_Price Cory_Price is offline
Registered User
 
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On