Re: SQL Database design question

From: <saghir.taj_at_gmail.com>
Date: 1 Feb 2005 03:33:12 -0800
Message-ID: <1107257592.204481.169620@z14g2000cwz.googlegroups.com>

Dear Dan,

You need three tables simply

Branch

---

BranchCode
BranchName

Employee

---

Ee_Code
Ee_Name
FK_Branch     // Foreign Key for branch, not nullable.

Branch _Employee                  // Junction Table
------------------------------------------
FK_Employee                        // Foreign Key for Employee
FK_Branch                           // Foreign Key for Branch

:) :) :)
Saghir Taj
MDBA
www.dbnest.com :The Nest of DB Professionals. Received on Tue Feb 01 2005 - 05:33:12 CST