Newbee database design question

From: ajksharma <ajksharma_at_yahoo.com>
Date: 27 Jul 2002 07:32:35 -0700
Message-ID: <1f7914cf.0207270632.13f3d125_at_posting.google.com>

Hi,

I am designing a database, keeeping in mind the normalization rules. Please see the tables below, and tell me if I am doing it all wrong.

employee

---

emp_num
emp_name
emp_lname
emp_type -------- ('B'=branch, 'M'=Main office)

employee branch

---

emp_num
dept_num
joining_date

employee Main office

---

emp_num
dept_num
joining_date

If the emp_type is 'B', then the employee data is inserted into 'employee branch' table and when it is 'M', in 'employee main office' table.

Is this the right way?

If it is, I am having lots of problem to make a select query for a "particular" employee.
I am using MS sql derver 2000.

Thanks for any help
ajay Received on Sat Jul 27 2002 - 16:32:35 CEST