Titleauth Table

The titleauth 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 author tables. The titleauth table diagram shows the column properties of the table.

• The bib# column is the foreign key that links the titleauth table to the title table. The primary key table is title.
• The auth# column is the foreign key that links the titleauth table to the author table. The primary key table is author.

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