Re: Newbee database design question
From: ajksharma <ajksharma_at_yahoo.com>
Date: 28 Jul 2002 20:06:44 -0700
Message-ID: <1f7914cf.0207281906.698e1579_at_posting.google.com>
Date: 28 Jul 2002 20:06:44 -0700
Message-ID: <1f7914cf.0207281906.698e1579_at_posting.google.com>
HI ,
> If these are the only columns you actually have you can
> just as well put the columns in the employee-table.
>
> So the employee-table would look like this:
>
> employee
> ---------
> emp_num
> emp_name
> emp_lname
> emp_type -------- ('B'=branch, 'M'=Main office)
> dept_num
> joining_date
The tables were of the above design before. I am just trying to make a sub-category relationship. But my Sql is a little weak.
Regards
Ajay
Received on Mon Jul 29 2002 - 05:06:44 CEST