The Library Database Case Study provides an overview of the operations at the West Municipal Library, describes the daily library functions, and presents the database that was designed for the library. Before a database for librarians and members was implemented, an interview was conducted with the librarians at the West Municipal Library to assess the library s business needs. The decisions that the database designer made during the design process are explained in the following sections. The following figure shows the overall schema of the database that was designed for the library | Appendix A Library Database Case Study Introduction The Library Database Case Study provides an overview of the operations at the West Municipal Library describes the daily library functions and presents the database that was designed for the library. Overview of Library Operations Before a database for librarians and members was implemented an interview was conducted with the librarians at the West Municipal Library to assess the library s business needs. The decisions that the database designer made during the design process are explained in the following sections. The following figure shows the overall schema of the database that was designed for the library. Library Database Diagram -H- member PK member no lastname firstname middleinitial photograph adult PK FK1 member no street city state zip phone_no expr_date reservation PK FK1 PK FK2 isbn member no log_date remarks loan PK FK1 PK FK1 isbn copy no FK3 FK2 title_no member_no out_date due_date loanhist PK FK1 PK FK1 PK isbn copy no out date FK2 title_no member_no due_date in_date fine_assessed fine_paid fine_waived remarks juvenile PK FK2 member_no FK1 adult_member_no birth_date item PK isbn FK1 title_no translation cover loanable title PK title_no title author synopsis H- copy H- -CW PK FK1 PK isbn copy no ex FK2 title_no on_loan 2 Appendix A Library Database Case Study Daily Library Functions Many daily library functions exist. The following are some of the most important. Uniquely Identifying Books Some books may have the same title therefore titles cannot be used as a means of identification. Librarians call books items. Items are identified by the International Standard Book Number ISBN . Books with the same title can have different ISBN numbers if they are in different languages and have different bindings hard cover or soft cover . Reserving Books If a member wants a book that is out on loan the book is placed on reserve for them. When the book arrives a librarian must notify the member who has been .
