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.
Hi all... This is my view on bridge tables:Bridge table in simple can be called as reference tables. As the name indicates, this table can be used to link two tables with 1 reference id...
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...