Junction table database management (1 résultats)

Taschenbuch. Etat : Neu. nach der Bestellung gedruckt Neuware - Printed after ordering - Please note that the content of this book primarily consists of articlesavailable from Wikipedia or other free sources online. In databasemanagement systems following the relational model, a junction table is atable that contains common fields from two or more tables. It is on themany side of a one-to-many relationship with each of the other tables.Junction tables are known under many names, among them cross-referencetable, bridge table, join table, map table, intersection table, linkingtable, many-to-many resolver, link table, or association table. Junctiontables are employed when dealing with many-to-many relationships in adatabase. A practical use of a junction table would be to assignpermissions to users. There can be multiple users, and each user can beassigned 0 or more permissions.…