problem with table design

[Olivier Salzgeber]

Hello everybody
I'm designing a database for our new Application and have some
problems with the following:

We have a table Jobs in which we store all kind of Jobs.
Looks like this:

tbl_jobs
-
job_id, integer,
name, varchar,
description, varchar

easy so far :)
The problem is we also want to keep track which of the Jobs are
related or almost the same.

Example:
If we have the following jobs:
1 painter 
2 auxiliary worker painter
3 plasterer 
4 auxiliary worker plasterer
5 electrician
6 auxiliary worker electrician

There will be 2 logical groups:
first:
1, 2, 3, 4
second:
5, 6

If I query for plasterer I should get the following result:
- plasterer
- painter
- auxiliary worker painter
- auxiliary worker plasterer

If I query for auxiliary worker electrician I should get this:
- electrician
- auxiliary worker electrician

What is the easiest way to design this?
I thought about this the whole morning but couldn't get a solution.

I hope somebody on this list can point me in the right direction.

Regards,
Olivier Salzgeber

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Fwd: problem with table design

[Olivier Salzgeber]

On Apr 5, 2005 3:15 PM, Martijn Tonies [EMAIL PROTECTED] wrote:
 Hi,

  I'm designing a database for our new Application and have some
  problems with the following:
 
  We have a table Jobs in which we store all kind of Jobs.
  Looks like this:
 
  tbl_jobs
  -
  job_id, integer,
  name, varchar,
  description, varchar
 
  easy so far :)
  The problem is we also want to keep track which of the Jobs are
  related or almost the same.
 
  Example:
  If we have the following jobs:
  1 painter
  2 auxiliary worker painter
  3 plasterer
  4 auxiliary worker plasterer
  5 electrician
  6 auxiliary worker electrician
 
  There will be 2 logical groups:
  first:
  1, 2, 3, 4
  second:
  5, 6
 
  If I query for plasterer I should get the following result:
  - plasterer
  - painter
  - auxiliary worker painter
  - auxiliary worker plasterer
 
  If I query for auxiliary worker electrician I should get this:
  - electrician
  - auxiliary worker electrician
 
  What is the easiest way to design this?
  I thought about this the whole morning but couldn't get a solution.
 
  I hope somebody on this list can point me in the right direction.

 Well, you could add the concept of job_group. Eg, create a table:

 job_groups
 jg_id, integer
 description varchar

 Add a group:
 1, electrician
 2, plasterer

 Now, if any job can belong to a single group, add a column job_group
 to your jobs table.

 When finding results for a certain job, you can check it's job_group
 and select any jobs from that group as well.

 With regards,

 Martijn Tonies
 Database Workbench - developer tool for InterBase, Firebird, MySQL  MS SQL
 Server
 Upscene Productions
 http://www.upscene.com

 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


Thanks for your reply.
I see this could be a possible solution.
But isn't it possible to solve this problem somehow without having to
create an additional job_group table?

Regards,
Olivier

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: OT Gmail

[Olivier Salzgeber]

Transcend Development wrote:
 

--
From: Transcend Development[SMTP:[EMAIL PROTECTED]
Sent: Sunday, August 29, 2004 6:30:01 PM
To: [EMAIL PROTECTED]
Subject: RE: OT Gmail
Auto forwarded by a Rule
  
As I have received many more than 3 requests I thought I should post 
this:

You can get invitations to gmail for about 99 cents on ebay!
That's where I got mine.  I then sold a couple, but it's too much
hassle for too little money!
Anyway I hope some of you can get yours there, as I have not received
any more quote from Google.
Regards,
 

I have 2 invitations left.
The first two who send me a message win :-)
Regards,
Olivier
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]