Answered Questions

  • Bridge Table

    What is the use of bridge table. Can give a simple example?

    Star Read Best Answer

    Editorial / Best Answer

    Sirini  

    • Member Since Jun-2009 | Jun 14th, 2009


    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.

    tisha24

    • Oct 7th, 2009

    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...