The PAC GPEP Library Proposal

Our domain is the GPEP library and class offerings.

We will be providing a library and class database for all the prisons in the GPEP system.

We will be providing a web frontend for easy management of book and other important supply checkout/checkin. This includes an interface for users to to enter new books and supplies or remove old ones, an interface to easily view sign in/sign out information. We will have an account system where users will only be able to view the data if they are logged in. We will also include an administrative account type that will have user creation/deletion privileges.

We will also be providing a database for GPEP's events, which will include their dates, offerings, attendance, and locations. We will provide a database for GPEP's class offerings/schedules, and which institutions they will be taught at.

We will all be doing serverside programming and data entry.

ER Diagram

Formal Specification

Website

Milestones

February 27:

  • All entities and relationships will have relation tables, and there will be a working web interface for data entry/removal.
  • March 15:

  • There will be an account system. Users will be able to create accounts and log in and out to view and modify the data.
  • February 27:

  • All entities and relationships will have relation tables, and there will be a working web interface for data entry/removal.
  • May 5:

  • Project completion.
  • Our schedule is we'll have the ER diagram by the end of February and all the web functionality shortly after, and the rest of the time will be devoted to filling the database.