As producer on this project I worked with 2 programmers to design and develop a database library system for the physical library at the Entertainment Technology Center.  This system replaced the handwritten on-your-honor system that was originally there and which was replete with errors, lost books and movies and chronically late books.

The new system is based on barcodes that have been placed in every item in the library which includes ~1500 books and ~1000 movies.  Each one of them has an entry into the database which is then used as a checkout system for everyone at the ETC including faculty staff and students.  It sends email reminders, has a hold and renew system, and features a robust search function.

My responsibilities as producer on this project are to:

  • Design and Implement a new library database system
  • Work with programmers to develop the actual database
  • Enter in all items contained in the library
  • Develop maintenance manuals to be used by future students.
  • Monitor and maintain the system during my tenure at the ETC

http://www.etc.cmu.edu/checkout/library