| |
GeekInterview.com > Interview Questions > Data Warehousing > Basics
| Print | |
Question: Bridge Table
Answer: What is the use of bridge table. Can give a simple example? |
| October 10, 2009 08:11:44 |
#3 |
| tisha24 |
Member Since: September 2008 Total Comments: 10 |
RE: Bridge Table
|
A table which maintained to define the relationship between two different tables is known as bridge tables.
For example, say there are two tables one table with employee information (an employee table), and other with deparment details.
Now a bridge table coming to picture to maintain the relationship between an employee with his/her department. which contains informations like which employee belongs to which department.
Here is a example to understand More precisely,
Employee table
--------------------
EMP_CD EMP_name DOJ
1001 MR.X 12-06-2006
1002 Ms.Y 24-11-2004
1003 MS.K 25-02-2004
Department table
-----------------------
DEPT_CD DEPT_NAME SECTOR_CD MANAGER_NM
IT_DEV S/W Developer SDV MR.XL
MNGNT HR Management HRD MS.DS
EMP_DEPT (Bridge Table)
---------------------------------
EMP_CD DEPT_CD
1001 MNGNT
1002 IT_DEV
1003 IT_DEV |
| |
Back To Question | |
