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 > Need Help with database design.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-06-06, 21:21
kevdmiller kevdmiller is offline
Registered User
 
Join Date: Nov 2006
Posts: 3
Need Help with database design.

I am new to databases and I need help designing a database which can tell me which employees at a jobsite have certain skills, I am going to build an application that will get the jobsite and skills. I want it to return the employee list of those with these skills. It will have an employee table,skills table and jobsite table plus other tables for other employee info. Any help would be appreciated.
Reply With Quote
  #2 (permalink)  
Old 11-06-06, 23:02
blindman blindman is offline
World Class Flame Warrior
 
Join Date: Jun 2003
Location: Ohio
Posts: 11,726
When is your homework assignment due?
__________________
If it's not practically useful, then it's practically useless.

blindman
www.chess.com: "sqlblindman"
Reply With Quote
  #3 (permalink)  
Old 11-07-06, 20:43
kevdmiller kevdmiller is offline
Registered User
 
Join Date: Nov 2006
Posts: 3
Need help with database design

It is a homework assignment but I am not sure how to go about making tables to get the information back on the employees who match the skills the employer wants. See the employer will enter the skills and the job site into the application and they want to get back the employees that match these skills at the job.
I do not know enough about databases to figure out how to set up the table and how to get the info back I need. Is there an easy way to set up the table to achieve this?
Reply With Quote
  #4 (permalink)  
Old 11-08-06, 09:35
blindman blindman is offline
World Class Flame Warrior
 
Join Date: Jun 2003
Location: Ohio
Posts: 11,726
Surely you have learned about JOINs and WHERE clauses in your class. If not, read the Books Online section regarding SELECT statements.
__________________
If it's not practically useful, then it's practically useless.

blindman
www.chess.com: "sqlblindman"
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