library contains 36 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
book_author	authorId	int	10			0	FK intentionally omitted to show an implied relationship
book	isbn	bigint	19			0
book_author	isbn	bigint	19			0
book_location	isbn	bigint	19			0
borrowed_book	isbn	bigint	19			0
borrower	address	int	10	√		null
library_branch	address	int	10
publisher	address	int	10	√		null
address	address1	varchar	50				Address line 1
address	address2	varchar	50	√		null	Address line 2 (optional)
address	addressId	int	10		√
author	authorId	int	10		√
borrowed_book	borrowDate	date	10
book_location	branchId	int	10
borrowed_book	branchId	int	10
library_branch	branchId	int	10		√
borrowed_book	cardNo	int	10
borrower	cardNo	int	10		√
address	city	varchar	30
borrowed_book	dueDate	date	10
author	firstName	varchar	32
borrower	firstName	varchar	32
author	lastName	varchar	32
borrower	lastName	varchar	32
author	middleName	varchar	32	√		null
borrower	middleName	varchar	32	√		null
library_branch	name	varchar	64
publisher	name	varchar	64
book_location	numCopies	int	10
borrower	phone	varchar	16	√		null
publisher	phone	varchar	16	√		null
book	publisherId	int	10		√
publisher	publisherId	int	10		√
address	state	char	2
book	title	varchar	128
address	zip	varchar	10				Dash req'd for zip+4