Titlesubj Table

The titlesubj table holds no information of its own. This is a link table, and its only function is to properly model the many-to-many relationship between the title and subject tables. The titlesubj table diagram shows the column properties of the table.

• The bib# column is the foreign key that links the titlesubj table to the title table. The primary key table is title.
• The subj# column is the foreign key that links the titlesubj table to the subject table. The primary key table is subject.

The primary key of the titlesubj table is the concatenation of bib# and subj#, a compound primary key. The table has a unique index on this composite.