Table 1: A subset of the database tables for a library system. The attributes in italic are primary or foreign keys.

Table Fields

userid, name, email, user, password
authorid, name
bookid, publisher_id, title, pages, isbn
paperid, title
periodicalid, publisher_id, year, volume, issue, isbn
publisherid, name
tagid, value
messageid, message
bookLoanid, book_id, user_id
periodicalLoanid, periodical_id, user_id
authorBookRelauthor_id, book_id
authorPaperRelid, author_id, paper_id
tagRelid, book_id, paper_id, tag_id
messageRelid, message