Designing a Database to Track Inventory and Purchase Data for a Library

PDF Version

The Oconee County Libraries (OCL) has to keep track of information on over 100 pieces of electronics (computers, monitors, printers, etc.)  Currently, a combination of Excel spreadsheets and an online tool from webjunction.org are used to record inventory information.  The result is an unwieldy system that is time consuming to keep updated.  The goal of this project is to create a database to record essential inventory data for both branches.  It is hoped that, if the system performs well, it may one day be expanded to cover the other libraries in the Athens Regional Library System (ARLS).  Most frequently, the system will be used to record or update the location and relation (e.g., which monitor is hooked up to which computer) of pieces of equipment.  In its current incarnation, the database will only be accessed by the author (OCL’s sole IT staffer), but in part that will entail translating requests from the Library’s Manager and Regional Business Office staff into database queries.

View full document

Database Design for Information Professionals

Addresses government and

industry needs for design, implementation, and management of the database systems. Focuses on

the application of data modeling technologies in library and information science practice and

research.

Course Objectives:

  • Upon completion the student will be able to:
  •  Explain the fundamental principles of database systems.
  •  Develop database conceptual design using the Entity Relationship Model approach.
  •  Demonstrate skills and perspective to analyze real-world requirements, produce a data model, and implement the database.
  •  Use Structured Query Language (SQL).
  •  Develop and optimize complex SQL queries to perform tasks such as table creation, data input, and retrieval.
  •  Evaluate trends in database technologies and the application of database technologies to various activities.