Notes

Book = {
BookID, Title , Pname
001, 'Harry Potter', 'Bloomsbury'
002, 'Percy Jackson', 'Activision'
003, 'Lord of the Rings', 'Allen & Unwin'
004, 'To Kill a Mockingbird', ' Lippincott'
005, 'The Great Gatsby', 'Charles Scribner'
006, 'The Hobbit', 'Allen & Unwin'
}
Book_Authors = {
BookID, AName
001, 'J.K Rowling'
002, ' Rick Riordan'
003, ' J.J.R Tolkien'
003, ' Johnny Debt'
004, 'Harper Lee'
005, 'F Scott Fitzgerald'
006, 'J.J.R Tolkien'
}
Publisher = {
Pname, Address, Pphone
'Bloomsbury', '123 Seseme St', '111-111-1111'
'Activision', '40 Stupid St', '222-222-2222'
'Allen & Unwin', '100 A&W St', '333-333-3333'
'Lippincott', '50 Forward St', '555-555-5555'
'Charles Scribner', '200 Backwards St', '777-777-7777'
'Allen & Unwin', '888 Lucky St', '888-888-8888'
}
Book_Copies = {
BookID, BranchID, NoOfCopies
001, 100, 3
001, 200, 4
001, 300, 5
001, 400, 1
002, 100, 2
002, 200, 5
002, 300, 2
003, 100, 5
003, 300, 6
004, 100, 2
005, 200, 2
005, 400, 4
006, 400, 6
}
Book_Loans = {
BookID, BranchID, CardNo, DateOut, DueDate, ReturnDate
002, 200, 1000, '04-Feb', ' ', ' '
004, 100, 2000, '04-Feb', ' ', ' '
003, 300, 3000, '07-Feb', ' ', ' '
005, 400, 2000, '03-Mar', ' ', ' '
006, 400, 4000, '15-Mar', ' ', ' '
002, 200, 5000, '20-Mar', ' ', ' '
005, 200, 2000, '02-Apr', ' ', ' '
006, 400, 1000, '05-Apr', ' ', ' '
002, 300, 5000, '15-Apr', ' ', ' '
003, 100, 3000, '01-May', ' ', ' '
002, 100, 4000, '02-May', ' ', ' '
}
Library_Branch = {
BranchID, BranchName, BranchAddress
100, 'Smart Readings', '555 Angel St'
200, 'Dumb Readings', '222 Pam St'
300, 'Happy Library', '777 Rich St'
400, 'Bad Luck Library', '99 Microwave St'
}
Borrower = {
CardNo, Bname, Baddress, Bphone
1000, 'Richard', '20 Pintail Cres', '111'
2000, 'Ilian', '50 York Mills', '222'
3000, 'Taye', '20 York Mills', '333'
4000, 'Adrian', '30 Parkwoods Dr', '444'
5000, 'Liam', '100 Victoria Park Ave', '555'
}