| |
GeekInterview.com > Interview Questions > Data Warehousing > Basics
| Print | |
Question: Bridge Table
Answer: What is the use of bridge table. Can give a simple example? |
| June 06, 2009 02:22:08 |
#2 |
| Sirini |
Member Since: June 2009 Total Comments: 3 |
RE: Bridge Table
|
An example of a Bridge table would be relationship table between student_master and courses_master. A Student may participate in multiple courses and obviously in a course there will be multiple students. In this scenario to maintain relationships between student_master and courses_master we need another table, which may be called, Student_courses. This table will have all relationships between Students and Courses.A bridge table is a table that only contains the keys between the two tables in a many-to-many relationship. These tables typically consist of mostly key fields, the primary keys of the two tables needing the many to many relationships. Sometimes there are more data elements, but often there are only two columns, both foreign keys.
|
| |
Back To Question | |
