​​ Learner Guide ICAPRG527A Last updated: Feb2014, Version No. 1.0 Page 1 of 1 Level 1 841 George Street Sydney NSW 2000 P. +61 (2) 9211 8838 [email protected] WWW.WARWICK.NSW.EDU.AU Assessment 3 – Project Develop a Library Information System Consider the following description for a Library Information System: A library needs to keep records of current loans of copies of books to borrowers and reservations for book titles. Each borrower is identified by a BORROWER# and each copy of a book title in the library is identified by an ACCESS# as the library may have more than one copy of a given book title. The NAME and ADDRESS of each borrower is held so that communications such as overdue loan reminders can be sent when necessary. The information required about book titles is TITLE, AUTHORS, PUBLISHERS, PUBLICATION DATE, and ISBN. For individual copies of a book title the PURCHASE PRICE and CURRENT PRICE are required, where purchase price is the price the library paid at the time of purchase and current price is the current listed price charged to borrowers who lose books. ISBN is an internationally used identifier for a book title. A borrower may have any number of books out on loan at any one time, but a book may be borrowed by only one borrower at a time. The DUE DATE for each loan is recorded so that overdue notices can be sent out. Book titles out on loan may be reserved by other borrowers pending their return. Borrowers may make a reservation for only one book title at a time. Reservations for a book title are processed in order of the date the reservation was made as copies are returned. Your Tasks: According to the program requirement, create a GUI framework, using this interface you should be able to do the followings: 1. Create Labels, Text, buttons(leaving it to your creativity) 2. Navigation Controls (such as: Tree View, Sitemap and menu controls) 3. Membership and Login controls (optional) 4. Using SQL or MS Access create tables as per the design 5. List the contents of all tables. 6. Search/Edit/Update/Delete records from the database. 7. List the records from one of the tables matching a search criterion. This criterion is a value from one of the fields. The value to be matched should be typed into a text box on the web page. 8. Display the results of a query which involves an inner join of two tables. 9. Add new records to the database. 10. Using some dummy data, test your application 11. Attach your screen shots with some coding and submit it to you trainer 12. Save the coding and the screen shots in the design document you have created for future use