CREATE TABLE Books (Book_Id INTEGER PRIMARY KEY, ISBN INTEGER, Borrower_Id INTEGER, Author CHAR(30), Title CHAR(50))
INSERT INTO Books VALUES (1001, 471402486, 0, 'Cay Horstmann', 'Big Java: Programming and Practice')
INSERT INTO Books VALUES (1002, 471470635, 0, 'Cay Horstmann, Timothy A. Budd', 'Big C++')
INSERT INTO Books VALUES (1003, 201760312, 0, 'Timothy A. Budd', 'An Introduction to Object-Oriented Programming')
INSERT INTO Books VALUES (1004, 234523897, 0, 'Philip M. Lewis', 'Database and Transaction Processing')
INSERT INTO Books VALUES (1005, 135754523, 0, 'Mark Birbeck', 'Professional XML 2nd Edition')
INSERT INTO Books VALUES (1006, 458734515, 0, 'Damon Hougland', 'Core JSP') 
CREATE TABLE Patrons (Name CHAR(50), Patron_ID INTEGER PRIMARY KEY, Address CHAR(100))
INSERT INTO Patrons VALUES ('John Smith', 8245, '111 Somewhere Ln., Dallas, TX 75201')
INSERT INTO Patrons VALUES ('Beverly Green', 8246, '1787 Anywhere St., Corvallis, OR 97330')
INSERT INTO Patrons VALUES ('Juan Martinez', 8247, '782 Main, Montezuma, NM 87731')