Re: Newbee database design question

From: ajksharma <ajksharma_at_yahoo.com>
Date: 28 Jul 2002 20:06:44 -0700
Message-ID: <1f7914cf.0207281906.698e1579@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 Sun Jul 28 2002 - 22:06:44 CDT