Home -> Usenet -> comp.databases.theory -> Re: Newbee database design question

Re: Newbee database design question

From: Lauri Pietarinen <lauri.pietarinen_at_atbusiness.com>
Date: 27 Jul 2002 15:20:35 -0700
Message-ID: <e9d83568.0207271420.56b7fcdd_at_posting.google.com> 






Hi,



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



I am assuming that both the branch and main offices
reside in the same table.



Lauri
Received on Sun Jul 28 2002 - 00:20:35 CEST












Original text of this message