Consider the Library database from Part $3.$ Specify what the foreign key$($s$)$ for each table should be$.$ Your answer should be based on our discussion of this database in class, not the specific restrictions imposed in problems $3$a $-3$d$.$

Your answer should include which column$($s$)$ in the referencing table reference which column$($s$)$ in the referenced table. Use this format for your answer:

TableName.ColumnName references TableName.ColumnName $($with TableName and ColumnName replaced with actual table and column names$).$