Re: SQL Database design question

From: <saghir.taj_at_gmail.com>
Date: 1 Feb 2005 03:33:12 -0800
Message-ID: <1107257592.204481.169620_at_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 - 12:33:12 CET

This message: [ Message body ]
Next message: Paul: "Re: Charades [Was: RE: Define "flatten database" ?]"
Previous message: Dan: "Re: Charades [Was: RE: Define "flatten database" ?]"
Maybe reply: William Cleveland: "Re: SQL Database design question"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message